-
Bug
-
Resolution: Answered
-
Low
-
None
-
6.8.1
-
None
-
1
-
Severity 3 - Minor
-
Summary
The latest MySQL driver is now 8.0.11, which is the default when going to
Our documentation links to that page.
It does not work with Confluence 6.8.1.
Using this driver causes some AO_ tables to not be successfully created during the database setup stage.
Environment
- MySQL 5.7
- MySQL Connector 8.0.11
Steps to Reproduce
- Download the latest MySQL 8.0.x Driver from
- As per the Confluence MySQL instructions, copy the driver to <confuence-install>/confluence/WEB-INF/lib
- Start a fresh install of Confluence
Expected Results
Installation completes without error.
Actual Results
The below exception is thrown in the atlassian-confluence.log file:
2018-04-21 15:29:21,920 ERROR [http-nio-8090-exec-3] [atlassian.confluence.event.ConfluenceEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.plugin.event.events.PluginFrameworkStartedEvent@5de08ea6 ] from the invoker [com.atlassian.confluence.event.ConfluenceListenerHandlersConfiguration$TimingListenerHandler$1$1@75222ad5] -- referer: http://localhost:8090/setup/setupdbtype-start.action | url: /setup/setuppaths.action | traceId: 00d2c7ac5f3ff7d9 | userName: anonymous | action: setuppaths java.lang.RuntimeException: bundle [com.atlassian.plugins.atlassian-whitelist-core-plugin]. Listener: com.atlassian.plugins.whitelist.core.applinks.ApplicationLinkChangeListener event: com.atlassian.plugin.event.events.PluginFrameworkStar tedEvent ... Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.atlassian-whitelist-core-plugin] ... Caused by: java.lang.RuntimeException: Could not read fields for table AO_21D670_WHITELIST_RULES ... Caused by: java.sql.SQLSyntaxErrorException: Table 'confluence681.AO_21D670_WHITELIST_RULES' doesn't exist
In total the tables that are not created are
- AO_21D670_WHITELIST_RULES
- AO_26DB7F_ENTITIES_TO_ROOMS
- AO_2F1435_HEALTH_CHECK_STATUS
- AO_5FB9D7_AOHIP_CHAT_LINK
- AO_6384AB_DISCOVERED
- AO_92296B_AORECENTLY_VIEWED
- AO_9412A1_AONOTIFICATION
- AO_BAF3AA_AOINLINE_TASK
Notes
For now, our documentation should be updated to link to the 5.1 driver.
Workaround
Continue to use the 5.1.x driver from
- relates to
-
CONFSERVER-52665 Support for MySQL 8
- Closed
-
AO-3462 Loading...
- mentioned in
-
![[Extranet] Page](/images/icons/generic_link_16.png "[Extranet] Page")
Page
Failed to load
[CONFSERVER-55399] MySQL Java Driver 8.0.11 does not work with Confluence
| Remote Link | New: This issue links to "Page (Extranet)" [ 500027 ] |
| Workflow | Original: JAC Bug Workflow v3 [ 2879760 ] | New: CONFSERVER Bug Workflow v4 [ 3005646 ] |
| Workflow | Original: JAC Bug Workflow v2 [ 2789287 ] | New: JAC Bug Workflow v3 [ 2879760 ] |
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Workflow | Original: JAC Bug Workflow [ 2738183 ] | New: JAC Bug Workflow v2 [ 2789287 ] |
| Symptom Severity | Original: Minor [ 14432 ] | New: Severity 3 - Minor [ 15832 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2660540 ] | New: JAC Bug Workflow [ 2738183 ] |
| Remote Link | New: This issue links to "AO-3462 (Ecosystem JIRA)" [ 366529 ] |
| Resolution | New: Answered [ 9 ] | |
| Status | Original: Open [ 1 ] | New: Resolved [ 5 ] |
| Assignee | New: Rachel Robins [ rrobins ] |
| Status | Original: Needs Verification [ 10004 ] | New: Open [ 1 ] |