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

Superfluous SQL warnings in the xwiki logs

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 12.5-rc-1
    • Mentions
    • None
    • Windows 10 Pro 64 bit, IE11, using a local instance of XWiki 12.5 RC1 on Jetty/HSQLDB
    • Unknown

    Description

      STEPS TO REPRODUCE

      1. Unzip a fresh instance of XWiki 12.5 RC1 (Jetty/HSQLDB)
      2. Start the instance
      3. Go to Administer Wiki > Social > Mentions
      4. Change the colors on MENTIONS COLOR and SELF MENTIONS COLOR (e.g. put #FF0000CC and #32CD3266)
      5. Click 'Save'

      EXPECTED RESULTS

      No warnings/errors are displayed.

      ACTUAL RESULTS

      In console, with each save there are displayed warnings like:

      2020-06-25 16:54:01,231 [qtp1422222071-24 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 16:54:01,231 [qtp1422222071-24 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 16:55:06,718 [qtp1422222071-89 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 16:55:06,718 [qtp1422222071-89 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 16:58:05,688 [qtp1422222071-16 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 16:58:05,688 [qtp1422222071-16 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 16:58:46,745 [qtp1422222071-195 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 16:58:46,745 [qtp1422222071-195 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 17:01:34,951 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 17:01:34,951 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 17:02:31,797 [qtp1422222071-17 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 17:02:31,798 [qtp1422222071-17 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 17:05:23,274 [qtp1422222071-90 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 17:05:23,275 [qtp1422222071-90 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data
2020-06-25 17:27:19,714 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Warning Code: -1100, SQLState: 02000
2020-06-25 17:27:19,715 [qtp1422222071-200 - http://localhost:1250/xwiki/bin/save/XWiki/Mentions/Configuration] WARN  o.h.e.j.s.SqlExceptionHelper   - no data

      The issue was reproduced so far only on Jetty/HSQLDB.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-17618 SQL Warning in the logs when saving XWiki.Notifications.Code.NotificationAdministration document in HSQLDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16558 SQL warnings when saving Mail Sending configuration

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. XWIKI-17421 Support Mentions in platform

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated: