XML Import Failed due to the Transaction Log for Database is Full

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

Problem

XML Import fails and the following appears in the atlassian-confluence.log:

2016-08-04 14:54:01,776 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: 
 -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not update: [com.atlassian.confluence.core.BodyContent#76063435]
        at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:77)
        at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420)
...
Caused by: org.xml.sax.SAXException: Error while importing backup: could not update: [com.atlassian.confluence.core.BodyContent#76063435]
net.sf.hibernate.exception.GenericJDBCException: could not update: [com.atlassian.confluence.core.BodyContent#76063435]
        at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
...
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not update: [com.atlassian.confluence.core.BodyContent#76063435]
        at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
        at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
        at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
...
Caused by: java.sql.SQLException: The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
...
2016-08-04 14:54:04,167 ERROR [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.
 -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
2016-08-04 14:54:04,167 ERROR [Long running task: Importing data] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
 -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
2016-08-04 14:54:04,167 ERROR [Long running task: Importing data] [sal.core.upgrade.PluginUpgrader] doUpgrade Upgrade failed: Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#32827]; SQL []; The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.; nested exception is java.sql.SQLException: The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.
 -- referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#32827]; SQL []; The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.; nested exception is java.sql.SQLException: The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
        at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
...
Caused by: java.sql.SQLException: The transaction log for database 'confluence' is full due to 'LOG_BACKUP'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
...

Diagnosis

Environment

  • Database: Microsoft SQL Server Database

Cause

Confluence Database transaction log is full.

Resolution

 Since this error is related to the Database itself, please contact your Database Admin as this issue is beyond our Atlassian Support Offerings and our area of expertise

Check the Microsoft SQL Server KB article below to fix your database and then reattempt to import the XML backup:

 

Last modified on Aug 5, 2016

Was this helpful?

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