Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-55399

MySQL Java Driver 8.0.11 does not work with Confluence

XMLWordPrintable

      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

      1. Download the latest MySQL 8.0.x Driver from
      2. As per the Confluence MySQL instructions, copy the driver to <confuence-install>/confluence/WEB-INF/lib
      3. 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

          Form Name

            [CONFSERVER-55399] MySQL Java Driver 8.0.11 does not work with Confluence

              rrobins Rachel Robins
              jrichards@atlassian.com James Richards
              Affected customers:
              0 This affects my team
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: