Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
13.2
-
None
-
Windows 10 Pro 64 bit, Edge 89, using a local instance XWiki 13.2 on HSQLDB 2.5.1, MySQL 8, MariaDB 10.5 and PostgreSQL 13, Tomcat
-
Unknown
-
Description
STEPS TO REPRODUCE
- Click on Notification Bell
- Click 'Watch this wiki' toggle to OFF
- Go to Notifications Settings
- Set 'Automatic page watching' to other option than 'Never' (for ex: 'Every time I make a major modification')
- On Home, create a page with 760 characters in its name (e.g. ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt760) to cumulate in total 768 characters
- Save the page
EXPECTED RESULTS
The page is saved successfully without warnings/errors and is added as a filter preference.
ACTUAL RESULTS
The page is saved, but is not added as a filter preference.
An error is encountered in console, along with some warnings. Here is the stacktrace from MySQL 8/ MariaDB 10.5:
2021-04-05 12:41:25,675 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] WARN o.h.e.j.s.SqlExceptionHelper - SQL Error: 1406, SQLState: 22001 2021-04-05 12:41:25,675 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] ERROR o.h.e.j.s.SqlExceptionHelper - Data truncation: Data too long for column 'nfp_page_only' at row 1 2021-04-05 12:41:25,679 [http-nio-8080-exec-2 - http://localhost:1115/bin/preview/ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768/WebHome] WARN icationFilterPreferenceManager - Unable save the filter preferences [[hasParent = [false], filterPreference = [DefaultNotificationFilterPreference{id='null', internalId=0, owner='null', filterName='scopeNotificationFilter', providerHint='userProfile', enabled=true, active=false, filterType=INCLUSIVE, notificationFormats=[EMAIL, ALERT], startingDate=Mon Apr 05 12:41:25 GMT 2021, eventTypes=[], user='null', pageOnly='xwiki:ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768.WebHome', page='null', wiki='null'}], scopeReference = [Document xwiki:ttttttttttttttttttttttttttttttt1ttttttttttttttttttttttttttttttt2ttttttttttttttttttttttttttttttt3ttttttttttttttttttttttttttttttt4ttttttttttttttttttttttttttttttt5ttttttttttttttttttttttttttttttt6ttttttttttttttttttttttttttttttt7ttttttttttttttttttttttttttttttt8ttttttttttttttttttttttttttttttt9ttttttttttttttttttttttttttttttt10ttttttttttttttttttttttttttttttt11ttttttttttttttttttttttttttttttt12ttttttttttttttttttttttttttttttt13ttttttttttttttttttttttttttttttt14ttttttttttttttttttttttttttttttt15ttttttttttttttttttttttttttttttt16ttttttttttttttttttttttttttttttt17ttttttttttttttttttttttttttttttt18ttttttttttttttttttttttttttttttt19ttttttttttttttttttttttttttttttt20ttttttttttttttttttttttttttttttt21ttttttttttttttttttttttttttttttt22tttttttttttttttttttttttttttttttttttttttt768.WebHome], children = []]] against the provider [userProfile]: [MysqlDataTruncation: Data truncation: Data too long for column 'nfp_page_only' at row 1]
Tested on HSQLDB 2.5.1, MySQL 8, MariaDB 10.5 and PostgreSQL 13.
Attachments
Issue Links
- is related to
-
XWIKI-18429 Increase the limit of the document reference size to the maximum supported by MySQL
- Closed