Unable to Create New Space When Using Database MySQL 5.6

Still need help?

The Atlassian Community is here for you.

Ask the community

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:

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

Last modified on Nov 2, 2018

Was this helpful?

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