Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15215

XWiki 10.3 fails to start on MySQL with utf8mb4 encoding

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 11.3-rc-1
    • 9.11.4, 10.3
    • Event Stream
    • Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 10.2 on MySQL 8.0.11

      MySQL with utf8mb4 encoding
    • Integration
    • Unknown
    • N/A
    • N/A

    Description

      When configured with MySQL Community Server 8.0.11 DB, XWiki 10.3 does not start and the browser gets HTTP ERROR 500.
      Was used JDBC connector 'mysql-connector-java-8.0.11.jar' from https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.11.zip.

      Also, the server was installed using the Legacy Authentication Method (Retain MySQL 5.x Compatibility).

      Please find attached the log containing the stacktrace.

      The issue was also reproduced by Manuel.

      Attachments

        1. 2018_04_25.output.log
          1.05 MB
          Ilie Andriuta
        2. 2018_09_14.output_connector_8_0_12.log
          589 kB
          Ilie Andriuta
        3. MySQL_failed.jpg
          699 kB
          Ilie Andriuta
        4. Subwiki_fail_connector_8_0_12.jpg
          425 kB
          Ilie Andriuta

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-13418 Emoji renders as question marks with MySQL "utf8" encoding

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16470 XWiki fails to start on Oracle Database

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16624 XWiki still fails to start on Oracle Database

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16397 Subwikis cannot be properly created on MySQL 8 using version 8 connector

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-17200 A migration should be implemented for XWIKI-15215

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. XDOCKER-58 Provide one XWiki image for MysqL5 and another one for MySQL8

          • Major - Major loss of function.
          • Closed

          Activity

            People

              tmortagne Thomas Mortagne
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: