Can't create a space due to 'Unknown table in information_schema' when using MySQL
問題
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_schemaThe errors may also occur for other tables.
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_26DB7F_ENTITIES_TO_ROOMS' in information_schemaCaused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_5FB9D7_AOHIP_CHAT_LINK' in information_schema診断
Confluence is connected to MySQL.
原因
Confluence is using an unsupported version of the MySQL driver (version 8.0).
ソリューション
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.
最終更新日 2018 年 7 月 2 日
Powered by Confluence and Scroll Viewport.