Cannot Restore XML Backup Due to Data Truncation - MySQL Driver 3.1

Still need help?

The Atlassian Community is here for you.

Ask the community

Unable to render {include} The included page could not be found.


When importing a backup or space export, the import fails with this message in your logs:

008-04-03 13:43:16,824 ERROR [Importing data task] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
 -- url: /admin/restore-local-file.action | userName: admin | action: restore-local-file
2008-04-03 13:43:16,824 ERROR [Importing data task] [confluence.importexport.impl.ReverseDatabinder] endElement net.sf.hibernate.exception.GenericJDBCException: could not insert: [bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@2fbee3c2]
 -- url: /admin/restore-local-file.action | userName: admin | action: restore-local-file
net.sf.hibernate.exception.GenericJDBCException: could not insert: [bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@2fbee3c2]
	at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(
Caused by: java.sql.SQLException: Data too long for column 'boolean_val' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(
	at com.mysql.jdbc.MysqlIO.sendCommand(
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
	at com.mysql.jdbc.Connection.execSQL(


A MySQL 3.0 jdbc driver (or other drivers pre 3.1 jdbc drivers) are not compatible with MySQL 4.x, 5.x and confluence (Please refer to Database Setup for MySQL).


Upgrade to the latest jdbc driver for MySQL which you can download from here.

Last modified on Mar 30, 2016

Was this helpful?

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