Unable to Create New Space When Using Database MySQL 5.6
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
MySQL 5.6 (version 5.6.16) is only supported with Confluence 5.5 and newer version. (check supported platform documentation)
User is unable to create a new space in Confluence.
The following appears in the atlassian-confluence.log:
1
2
3
4
5
6
7
8
9
10
caused by: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not insert: [com.atlassian.confluence.spaces.Space#173637642]; SQL []; Could not retrieve transation read-only status server; nested exception is java.sql.SQLException: Could not retrieve transation read-only status server
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
caused by: java.sql.SQLException: Could not retrieve transation read-only status server
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 302,711 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor643.newInstance(Unknown Source)
caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3119)
Cause
Confluence runs with MySQL driver version 5.1.26 (or older).
Resolution
Update database driver to MySQL 5.1.29 (or newer)
OR
Downgrade to MySQL version 5.5 (it's highly recommended to use the Supported Platformssupported platforms according to Confluence version)
Was this helpful?