Open issues

upgrading failed on fresh install when database name is not 'kylo'
KYLO-3272
When using AWS EMR, SparkLauncher does not set spark env
KYLO-3270
Access to connectors shows no authentication, no access to the page
KYLO-3267
unable to load data from JDBC datasource on Kylo-UI
KYLO-3261
KYLO-UI LOGIN PROBLEM
KYLO-3260
Not able to ingest a file to create a feed
KYLO-3257
How to sample(.csv) data ingest in sandbox kylo
KYLO-3255
Spark Validator fails with Spark 2.3
KYLO-3187
Feed profile data cannot be retrieved
KYLO-2625
Kylo assigns "Controller Service" to the NiFi processor's property even though it had "No value set" during template registration.
KYLO-1489
Need help to trigger a feed from command line with parameters
KYLO-977
Trigger Feed is not working depending on environment.
KYLO-921
Remove "AS" keyword for table aliases in Visual Query Builder
KYLO-576
Kylo - Creating a Template with Resuable Flow - An unknown error has occurred. Contact your Kylo administrator for more info
KYLO-3268
Some access control checks are made against the REST model
KYLO-3169
Kylo NiFi processors should gracefully handle when Kylo is temporarily down
KYLO-2932
Global search not working with the AWS elastic search
KYLO-2767
Migrate datasource-based feed provenance in metadata to data be data set-based
KYLO-2656
List of feeds is not retrieved and shown properly
KYLO-2610
KYLO-HDP-sandbox: UI login failed
KYLO-2569
Skip Header option not taken into account in XML Ingest Template. This causes failures when processing file
KYLO-2432
Enhance our simple credential store to support encrypted credentials
KYLO-2410
Check that standardizer and data types are valid at time of chnage/creation
KYLO-2406
Migrate existing metadata model to Catalog model
KYLO-2390
Need a NiFi processor to identify the source data set for a feed
KYLO-2291
Update visual Query to support input__file__name when processing from flat files
KYLO-2222
Remove dependency on Hive
KYLO-2006
Implement JDBC data set target in the profiler
KYLO-2004
Implement JDBC data set target in standardizers/validators
KYLO-2002
Visual Query fails to write to JDBC source
KYLO-1961
Improve Nifi flow control from Kylo
KYLO-1822
NiFi's WriteAheadProvenanceRepository support
KYLO-1748
Upgrade from 0.8.4 to 0.9.1-SNAPSHOT loses feed details under category node
KYLO-1737
Granting feed details access/edit permissions grants permanent template access
KYLO-1720
Load high-water mark processor max yield count not managed per feed
KYLO-1659
Kylo - Architecture - documentation
KYLO-1612
Kylo for Teradata - Ingest
KYLO-1560
Target Table step in data transformation wizrd does not allow arrays
KYLO-1532
hive connectivity issue
KYLO-1482
Need the ability to choose an existing table when ingesting to hive with mapping capability
KYLO-1449
Unable to authenticate with kerberos for sentry
KYLO-1447
Categories 'Roles inherited by Feeds' has issues
KYLO-1416
Kylo hangs when using it in Google Chrome
KYLO-1405
Decouple Kylo from Hadoop
KYLO-1404
Make Application properties and other fey config files available to edit in the UI
KYLO-1403
Allow a catalog to be defined and Kylo retrieve extra business metadata when showing schema information
KYLO-1402
Allow the capture of metadata against a data source
KYLO-1400
Indexing of complex JSON data types fails
KYLO-1265
A user with the rights to administer groups cannot delete a group that the user created
KYLO-1262
Extend Kylo to talk to solr securely
KYLO-1250
issue 1 of 947

upgrading failed on fresh install when database name is not 'kylo'

Description

Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2019-06-07 14:26:58,869 ERROR main:SpringApplication:771 - Application startup failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'kyloUpgradeConfig': Unsatisfied dependency expressed through field 'liquibase'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:com/thinkbiganalytics/db/changelog/0.8.1/nifi-flow-cache-cluster-sync2.xml::kylo_0.8.1-nifi-flow-cache-mediumtext::sr186054:
Reason: liquibase.exception.DatabaseException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT [Failed SQL: ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:586)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:364)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:134)
at com.thinkbiganalytics.server.upgrade.KyloUpgrader.upgrade(KyloUpgrader.java:57)
at com.thinkbiganalytics.server.KyloServerApplication.main(KyloServerApplication.java:76)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:com/thinkbiganalytics/db/changelog/0.8.1/nifi-flow-cache-cluster-sync2.xml::kylo_0.8.1-nifi-flow-cache-mediumtext::sr186054:
Reason: liquibase.exception.DatabaseException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT [Failed SQL: ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:583)
... 19 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:com/thinkbiganalytics/db/changelog/0.8.1/nifi-flow-cache-cluster-sync2.xml::kylo_0.8.1-nifi-flow-cache-mediumtext::sr186054:
Reason: liquibase.exception.DatabaseException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT [Failed SQL: ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:431)
at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:388)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1689)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1627)
... 29 more
Caused by: liquibase.exception.DatabaseException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT [Failed SQL: ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
... 37 more
Caused by: java.sql.SQLSyntaxErrorException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT
at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:266)
at sun.reflect.GeneratedMethodAccessor372.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
at com.sun.proxy.$Proxy33.execute(Unknown Source)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
... 42 more
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1098)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1030)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:985)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:129)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)
... 49 more
2019-06-07 14:26:58,875 ERROR main:KyloServerApplication:79 - Error during upgrade: Error creating bean with name 'kyloUpgradeConfig': Unsatisfied dependency expressed through field 'liquibase'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:com/thinkbiganalytics/db/changelog/0.8.1/nifi-flow-cache-cluster-sync2.xml::kylo_0.8.1-nifi-flow-cache-mediumtext::sr186054:
Reason: liquibase.exception.DatabaseException: (conn:321) ALTER command denied to user 'kylo'@'localhost' for table 'nifi_flow_cache_update_item'
Query is : ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT [Failed SQL: ALTER TABLE kylo.NIFI_FLOW_CACHE_UPDATE_ITEM MODIFY UPDATE_VALUE MEDIUMTEXT]
2019-06-07 14:26:58,875 ERROR main:KyloServerApplication:80 - ***** Upgrading failed *****

Environment

None

Status

Assignee

Unassigned

Reporter

简传挺

Labels

Reviewer

None

Story point estimate

None

Components

Priority

Highest