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

SQL warnings when running a docker instance on PostgreSQL 12.3

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 12.5
    • Fix Version/s: None
    • Component/s: Old Core
    • Labels:
    • Environment:
      Firefox 78, XWiki 12.5 and 12.5.1 on PostgreSQL 12.3, Docker distribution
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Start a fresh Docker instance of XWiki 12.5 (or 12.5.1) with PostgreSQL 12.3
      2. Access the instance from browser
      3. Observe the console
      4. Create a subwiki
      5. Observe the console

      EXPECTED RESULTS

      No warnings/errors are displayed.

      ACTUAL RESULTS

      Some SQL warnings are displayed in console about constraints related to "xwikiattrecyclebin" and "xwikirecyclebin". Stacktrace:

      When first accessing the instance:

      2020-07-07 13:13:06,011 [XWiki initialization] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: 0, SQLState: 00000
      2020-07-07 13:13:06,011 [XWiki initialization] WARN  o.h.e.j.s.SqlExceptionHelper   - constraint "ukk57itp65fntlv128dvxeew9w2" of relation "xwikiattrecyclebin" does not exist, skipping
      2020-07-07 13:13:06,178 [XWiki initialization] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: 0, SQLState: 00000
      2020-07-07 13:13:06,178 [XWiki initialization] WARN  o.h.e.j.s.SqlExceptionHelper   - constraint "ukgm4gg28vt84o24svs1drmg3bq" of relation "xwikirecyclebin" does not exist, skipping

      When creating a subwiki:

      2020-07-07 15:43:35,781 [com.xpn.xwiki.internal.WikiInitializerJob@69bbd457([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: 0, SQLState: 00000
      2020-07-07 15:43:35,782 [com.xpn.xwiki.internal.WikiInitializerJob@69bbd457([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - constraint "ukk57itp65fntlv128dvxeew9w2" of relation "xwikiattrecyclebin" does not exist, skipping
      2020-07-07 15:43:35,966 [com.xpn.xwiki.internal.WikiInitializerJob@69bbd457([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: 0, SQLState: 00000
      2020-07-07 15:43:35,967 [com.xpn.xwiki.internal.WikiInitializerJob@69bbd457([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - constraint "ukgm4gg28vt84o24svs1drmg3bq" of relation "xwikirecyclebin" does not exist, skipping

      However, the issue couldn't be reproduced locally with PostgreSQL 12.3/Tomcat 9.0.36 and it doesn't reproduce with XWiki 12.4 on Docker.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: