kylo-ui unable to start

Description

OS: RHEL 7.4
Built using wizard.
Database: mysql

  1. `kylo-service/application.configuration` did not update the username and password. Caused initlal issues. Upon updating manually, the installation was successful and kylo-service was up.

  2. All services are running. But the UI throws a server error 500. From the kylo-service logs it appears to be database schema issue. Se below:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 2018-01-20 02:22:59 INFO main:KyloVersionUtil:100 - finding version information from /opt/kylo/kylo-services/conf/version201$ 2018-01-20 02:22:59 INFO main:KyloVersionUtil:108 - loaded Kylo version file: 0.8.4.1 build Time: 2017-12-21 20:00 2018-01-20 02:23:02 ERROR main:KyloUpgradeDatabaseVersionChecker:102 - Error has occurred so upgrade is needed java.sql.SQLSyntaxErrorException: (conn:331) Unknown column 'POINT_VERSION' in 'order clause' Query is : SELECT * FROM KYLO_VERSION ORDER BY MAJOR_VERSION DESC, MINOR_VERSION DESC, POINT_VERSION DESC, TAG DESC 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.executeQuery(MariaDbStatement.java:366) at com.thinkbiganalytics.server.upgrade.KyloUpgradeDatabaseVersionChecker.getDatabaseVersion(KyloUpgradeDatabaseVersi$ at com.thinkbiganalytics.server.upgrade.KyloUpgrader.getCurrentVersion(KyloUpgrader.java:93) at com.thinkbiganalytics.server.upgrade.KyloUpgrader.isUpgradeRequired(KyloUpgrader.java:70) at com.thinkbiganalytics.server.KyloServerApplication.main(KyloServerApplication.java:63) Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Unknown column 'POINT_VERSION' in 'order clause' Query is : SELECT * FROM KYLO_VERSION ORDER BY MAJOR_VERSION DESC, MINOR_VERSION DESC, POINT_VERSION DESC, TAG DESC at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1098) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1030).txt 2018-01-20 02:22:59 INFO main:KyloVersionUtil:108 - loaded Kylo version file: 0.8.4.1 build Time: 2017-12-21 20:00 2018-01-20 02:23:02 ERROR main:KyloUpgradeDatabaseVersionChecker:102 - Error has occurred so upgrade is needed java.sql.SQLSyntaxErrorException: (conn:331) Unknown column 'POINT_VERSION' in 'order clause' Query is : SELECT * FROM KYLO_VERSION ORDER BY MAJOR_VERSION DESC, MINOR_VERSION DESC, POINT_VERSION DESC, TAG DESC 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.executeQuery(MariaDbStatement.java:366)

Environment

None

Status

Assignee

Jagrut Sharma

Reporter

Harsh Suri

Labels

Reviewer

None

Story point estimate

None

Components

Priority

High
Configure