Cannot Save Page with Long Body Content
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
This issue affects multiple databases with different error strings. These are the current known errors resulting from this issue:
MySQL
1
2
3
4
5
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
1
2
3
4
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:
1:Insert the text inside Noformat Macro or Code Block Macro.
1
Was this helpful?