Viewing a build fail with MySQL Unknown table error
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
Unable to view build details.
The following appears in the atlassian-bamboo.log
1
2
3
4
5
6
7
8
9
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)Diagnosis
Check what is the version of MySQL Connector/J JDBC driver from the following directories:
BAMBOO_INSTALL/libBAMBOO_HOME/lib
Cause
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.
Solution
Resolution
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/libRestart Bamboo
Was this helpful?