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

SQL warnings when running a docker instance on PostgreSQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • 12.5
    • Old Core
    • Firefox 78, XWiki 12.5 and 12.5.1 on PostgreSQL 12.3, Docker distribution
    • Unknown

    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

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-19578 Extra warnings related to xwikilinks in the xwiki logs

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated: