Viewing a build fail with MySQL Unknown table error

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

Unable to view build details.

The following appears in the 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)

Diagnosis

Check what is the version of MySQL Connector/J JDBC driver from the following directories:

  • BAMBOO_INSTALL/lib
  • BAMBOO_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.

Resolution

  1. Shutdown Bamboo
  2. Delete MySQL JDBC driver version 8.0 from the following directories:
    • BAMBOO_INSTALL/lib
    • BAMBOO_HOME/lib
  3. Download MySQL JDBC driver version 5.1.x into BAMBOO_INSTALL/lib or BAMBOO_HOME/lib
  4. Restart Bamboo


Last modified on Jul 18, 2018

Was this helpful?

Yes
No
Provide feedback about this article

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.