Viewing a build fail with MySQL Unknown table error
問題
Unable to view build details.
atlassian-bamboo.log に次のメッセージが出力される。
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'ao_7a45fb_aotracking_entry' in information_schema
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1247)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3149)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3137)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3190)診断
Check what is the version of MySQL Connector/J JDBC driver from the following directories:
BAMBOO_INSTALL/libBAMBOO_HOME/lib
原因
Unsupported MySQL Connector/J JDBC driver version 8.0 (com.mysql.cj.jdbc) instead of 5.1 is used in Bamboo as stated in the Bamboo documentation MySQL.
ソリューション
- Shutdown Bamboo
- Delete MySQL JDBC driver version 8.0 from the following directories:
BAMBOO_INSTALL/libBAMBOO_HOME/lib
- Download MySQL JDBC driver version 5.1.x into
BAMBOO_INSTALL/liborBAMBOO_HOME/lib - Restart Bamboo
最終更新日 2018 年 7 月 18 日
Powered by Confluence and Scroll Viewport.