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

Can't DROP INDEX Warnings in console when first accessing XWiki or create a subwiki on MariaDB 11.0.3 on Docker

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 15.5.2, 14.10.15
    • None
    • None
    • Windows 11 Pro, Edge 116, using Docker instance of XWiki 15.5.2 on MariaDB 11.0, Tomcat 9.0.80
    • Unknown

    Description

      Steps to reproduce

      1. Start XWiki 15.5.2 (or 14.10.15) on Docker with MariaDB 11.0.3 (tested using 15.5.2-mariadb-tomcat image)
      2. Access the instance in browser
      3. Observe the console
      4. Finish the Distribution Wizard
      5. Create a subwiki
      6. Observe the console

      Expected results

      No warnings errors are encountered.

      Actual results

      In XWiki console, the following errors are encountered when first accessing the instance:

      2023-09-01 13:28:56,025 [XWiki initialization] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `UKk57itp65fntlv128dvxeew9w2`; check that it exists
2023-09-01 13:28:56,735 [XWiki initialization] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `XWL_UNIQUE_CONSTRAINT`; check that it exists
2023-09-01 13:28:57,143 [XWiki initialization] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `UKgm4gg28vt84o24svs1drmg3bq`; check that it exists

      The following stacktrace is displayed when creating a subwiki:

      2023-09-01 12:37:40,403 [com.xpn.xwiki.internal.WikiInitializerJob@6560beec([initialization, wiki, subwikiglobal2])] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `UKk57itp65fntlv128dvxeew9w2`; check that it exists
2023-09-01 12:37:42,339 [com.xpn.xwiki.internal.WikiInitializerJob@6560beec([initialization, wiki, subwikiglobal2])] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `XWL_UNIQUE_CONSTRAINT`; check that it exists
2023-09-01 12:37:42,722 [com.xpn.xwiki.internal.WikiInitializerJob@6560beec([initialization, wiki, subwikiglobal2])] WARN  o.m.j.m.s.ErrorPacket          - Error: 1091-42000: Can't DROP INDEX `UKgm4gg28vt84o24svs1drmg3bq`; check that it exists

      It seems the issue reproduces only on Docker and it does not reproduce when using XWiki with MariaDB 10.11.2.

      It also doesn't reproduce at all locally (outside Docker, on Windows 11) with MariaDB 11.0.3 (tested on Tomcat 9.0.80, using connector mariadb-java-client-3.2.0.jar if relevant).

      Attachments

        Activity

          People

            Unassigned Unassigned
            iandriuta Ilie Andriuta
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: