Cannot Save Page with Long Body Content

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.

Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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
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

  1. Add a space after the opening square bracket '[' or before the closing square bracket '['
  2. Replace the colon ':' with:

    :
    
  3. Insert the text inside Noformat Macro or Code Block Macro.


Last modified on Jan 23, 2025

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.