Kylo启动时Liquibase异常

Question

我从主分支创建了一个rpm，并将其安装在我的HDP 2.4沙箱上，并为Kylo安装了mysql默认元存储。在启动kylo服务后，我遇到了以下问题。以前有没有人遇到过这种情况？

Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:com/thinkbiganalytics/db/changelog/0.0.0/2017-03-24-1135-automated-export.xml::1490096811017-68::ru186002 (generated):
     Reason: liquibase.exception.DatabaseException: Specified key was too long; max key length is 1000 bytes [Failed SQL: CREATE INDEX NN_EXEC_PARAMS_STRING_VAL ON kylo.BATCH_JOB_EXECUTION_PARAMS(KEY_NAME, STRING_VAL)]
        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:1637)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
        ... 16 more

Answer 1

问题可能是Kylo需要更新版本的MySQL服务器。

您可以尝试手动升级数据库并将SQL脚本修改为使用较短的键：http://kylo.readthedocs.io/en/latest/how-to-guides/DatabaseUpgrades.html