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

Error when changing notification filters toggles too fast

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 10.2, 9.11.4
    • Notifications
    • None
    • Windows 10 Pro 64 bit, Edge 16, Firefox 59, IE11, Chrome 66, using a local instance of XWiki 10.2 on PostgreSQL 10
    • Unknown

    Description

      STEPS TO REPRODUCE

      1. Start the XWiki instance
      2. Login as Admin or an user
      3. Go to the Notifications > Settings
      4. In the Filters section, click on some filter toggles right one after another

      EXPECTED RESULTS

      The toggles are turned ON/OFF and a message is displyed on the bottom (for every action) to let the user know that the changes are being saved.

      ACTUAL RESULTS

      When the toggles are clicked too fast one after another, the 'Failed to save your settings' message is displayed and an error is encountered in the console having the following stacktrace:

      2018-04-23 11:39:44.624:INFO:oejshC.xwiki:http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects?media=json&minorRevision=true: RestletServlet: [Restlet] ServerServlet: component class is null
      2018-04-23 11:39:46.977:INFO:oejshC.xwiki:http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/3/properties/isEnabled?media=json&minorRevision=true: RestletServlet: [Restlet] Attaching application: org.xwiki.rest.internal.XWikiRestletJaxRsApplication@3dcfacda to URI: /xwiki/rest
      2018-04-23 11:39:47,364 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/1/properties/isEnabled?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,364 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,364 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/2/properties/isEnabled?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,366 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/1/properties/isEnabled?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - Batch entry 0 insert into xwikircs (XWR_DATE, XWR_COMMENT, XWR_AUTHOR, XWR_DOCID, XWR_VERSION1, XWR_VERSION2) values ('2018-04-23 11:39:47+03', '', 'XWiki.ILIE', 9101869780070765416, 3, 26) was aborted: ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists. Call getNextException to see other errors in the batch.
      2018-04-23 11:39:47,366 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - Batch entry 0 insert into xwikircs (XWR_DATE, XWR_COMMENT, XWR_AUTHOR, XWR_DOCID, XWR_VERSION1, XWR_VERSION2) values ('2018-04-23 11:39:47+03', '', 'XWiki.ILIE', 9101869780070765416, 3, 26) was aborted: ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists. Call getNextException to see other errors in the batch.
      2018-04-23 11:39:47,366 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/2/properties/isEnabled?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - Batch entry 0 insert into xwikircs (XWR_DATE, XWR_COMMENT, XWR_AUTHOR, XWR_DOCID, XWR_VERSION1, XWR_VERSION2) values ('2018-04-23 11:39:47+03', '', 'XWiki.ILIE', 9101869780070765416, 3, 26) was aborted: ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists. Call getNextException to see other errors in the batch.
      2018-04-23 11:39:47,367 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/1/properties/isEnabled?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,367 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,367 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists.
      2018-04-23 11:39:47,367 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/2/properties/isEnabled?media=json&minorRevision=true] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 23505
      2018-04-23 11:39:47,367 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/1/properties/isEnabled?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists.
      2018-04-23 11:39:47,370 [http://localhost:1003/xwiki/rest/wikis/xwiki/spaces/XWiki/pages/ILIE/objects/XWiki.Notifications.Code.ToggleableFilterPreferenceClass/2/properties/isEnabled?media=json&minorRevision=true] ERROR o.h.u.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "xwikircs_pkey"
       Detail: Key (xwr_docid, xwr_version1, xwr_version2)=(9101869780070765416, 3, 26) already exists.

      It is to be mentioned that the issue is reproducing only the first time the filter toggles are changed after the instance is started.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: