There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-308183f8-9c15-452a-8387-0c5448aea49a XWIKI-15209 Open

Error when changing notification filters toggles too fast

 
View issue   ยท   Add comment
 

1 update

 
cid:jira-generated-image-avatar-c12e201f-60ad-4e76-a64d-5f34dfc983e5 Changes by Manuel Leduc on 29/Jan/26 09:49
 
Description: STEPS TO REPRODUCE
# Start the XWiki instance
# Login as Admin or an user
# Go to the Notifications > Settings
# 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 displayed 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:
{code:java}
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.{code}

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