Can't create a space due to 'Unknown table in information_schema' when using MySQL

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

A space can't be created due to the error below.

The atlassian-confluence.log file will display errors as such:

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_schema

The errors may also occur for other tables.

Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_26DB7F_ENTITIES_TO_ROOMS' in information_schema
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_5FB9D7_AOHIP_CHAT_LINK' in information_schema


Diagnosis

Confluence is connected to MySQL.

Cause

Confluence is using an unsupported version of the MySQL driver (version 8.0).

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.


Last modified on Jul 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article

Related content

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