Details
-
Bug
-
Resolution: Fixed
-
Medium
-
6.0.6, 6.2.0, 6.1.3, 6.4.1, 6.8.0
-
None
-
16
-
Severity 2 - Major
-
94
-
Description
STEPS TO REPLICATE
- Create a page in Confluence.
- Insert the following macro:
- attachments macro
- blog-posts macro
- change-history macro
- children macro
- contentbylabel macro
- content-by-user macro
- content-report-table macro
- contributors-summary macro
- create-from-template macro
- create-space-button macro
- favourite pages macro
- labels list macro
- network macro
- popular label macro
- recently updated macro
- recently updated dashboard macro
- recently used labels macro
- related labels macro
- space attachments macro
- space details macro
- spaces list macro
- Save the page.
- Edit the page again and insert cheese macro on top op the page.
- Save the page.
EXPECTED BEHAVIOUR
The page will be save.
ACTUAL BEHAVIOUR
An ERROR appear while saving the page Unable to communicate with server. Saving is not possible at the moment.
ERROR below appear in the atlassian-confluence.log file:
MySQL:
2017-05-30 22:33:58,383 ERROR [http-nio-8090-exec-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Data truncation: Data too long for column 'STRINGVAL' at row 1 -- referer: http://localhost:8090/pages/resumedraft.action?draftId=327700&draftShareId=2d93ae94-a816-4402-b016-6640fe292ee9 | url: /rest/api/content/327693 | traceId: 7c333ddb6362d6b8 | userName: admin 2017-05-30 22:33:58,398 WARN [http-nio-8090-exec-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions: ->[com.atlassian.confluence.api.impl.service.content.draft.ContentDraftServiceImpl.publishEditDraft]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #413923909) [null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #2053122999) -- referer: http://localhost:8090/pages/resumedraft.action?draftId=327700&draftShareId=2d93ae94-a816-4402-b016-6640fe292ee9 | url: /rest/api/content/327693 | traceId: 7c333ddb6362d6b8 | userName: admin 2017-05-30 22:33:58,429 ERROR [http-nio-8090-exec-1] [rest.api.model.ExceptionConverter] convertServiceException No status code found for exception, converting to internal server error : -- referer: http://localhost:8090/pages/resumedraft.action?draftId=327700&draftShareId=2d93ae94-a816-4402-b016-6640fe292ee9 | url: /rest/api/content/327693 | traceId: 7c333ddb6362d6b8 | userName: admin org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
H2 database:
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "STRINGVAL VARCHAR(255)": "'blog-posts,contributors-summary,favpages,change-history,attachments,recently-used-labels,listlabels,create-from-template,space-... (256)"; SQL statement: insert into CONTENTPROPERTIES (PROPERTYNAME, STRINGVAL, LONGVAL, DATEVAL, PROPERTYID) values (?, ?, ?, ?, ?) [22001-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:178) at org.h2.table.Column.validateConvertUpdateSequence(Column.java:332) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726) at org.h2.command.dml.Insert.insertRows(Insert.java:152) at org.h2.command.dml.Insert.update(Insert.java:115) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:254) at org.h2.server.TcpServerThread.process(TcpServerThread.java:346) at org.h2.server.TcpServerThread.run(TcpServerThread.java:160) at java.lang.Thread.run(Thread.java:745)
WORKAROUND
- Edit the page and insert additional macro with longer name (Tasks Report macro or Table of Content Zone macro, for example)
- Save the page.