Can't create a space due to 'Unknown table in information_schema' when using MySQL
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
A space can't be created due to the error below.
The atlassian-confluence.log file will display errors as such:
1
2
3
4
5
6
7
8
9
10
2018-06-23 16:19:22,751 ERROR [http-nio-8095-exec-2] [atlassian.confluence.event.ConfluenceEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.confluence.event.events.content.mail.notification.ContentNotificationAddedEvent[source=com.atlassian.confluence.mail.notification.DefaultNotificationManager@961b8b6]] from the invoker [com.atlassian.confluence.event.ConfluenceListenerHandlersConfiguration$TimingListenerHandler$1$1@2a4e0967]
-- referer: http://localhost:8090/spacedirectory/view.action | url: /rest/create-dialog/1.0/space-blueprint/create-space | traceId: 4e99dd9e50594db4 | userName: admin
java.lang.RuntimeException: bundle [com.atlassian.mywork.confluence-host-plugin]. Listener: com.atlassian.mywork.providers.confluence.ConfluenceEventListener event: com.atlassian.confluence.event.events.content.mail.notification.ContentNotificationAddedEvent
...
Caused by: java.lang.RuntimeException: Could not read fields for table AO_9412A1_AONOTIFICATION
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:139)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
...
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_9412A1_AONOTIFICATION' in information_schemaThe errors may also occur for other tables.
1
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_26DB7F_ENTITIES_TO_ROOMS' in information_schema1
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_5FB9D7_AOHIP_CHAT_LINK' in information_schemaDiagnosis
Confluence is connected to MySQL.
Cause
Confluence is using an unsupported version of the MySQL driver (version 8.0).
Solution
Resolution
Revert to the 5.1.42 driver by downloading it from MySQL's website and following the steps in 5. Download and install the MySQL driver to replace it with the current 8.0 version.
Was this helpful?