Cannot Save Page with Long Body Content
Symptoms
This issue affects multiple databases with different error strings. These are the current known errors resulting from this issue:
MySQL
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#4784133]; SQL []; Data truncation: Data too long for column 'DESTSPACEKEY' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'DESTSPACEKEY' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)
caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'DESTSPACEKEY' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3561)
PostgreSQL
2010-09-17 14:05:38,098 ERROR [http-8080-5] [confluence.pages.actions.AbstractEditPageAction] doSaveEditPageBean An error occured while storing the requested page!
-- referer: http://localhost:8080/pages/editpage.action?pageId=720902 | url: /pages/doeditpage.action | userName: admin | action: doeditpage | page: 720902
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#852117]; SQL []; ERROR: value too long for type character varying(255); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
Cause
There is a colon contained within square brackets [] after 255 characters, which causes the database to choke. This issue is being tracked by CONF-20558.
Resolution
- Add a space after the opening square bracket '[' or before the closing square bracket '['
Replace the colon ':' with:
:Insert the text inside Noformat Macro or Code Block Macro.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.