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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

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.

*Fisheye および Crucible は除く

問題

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)
...

診断

環境

  • Database: Microsoft SQL Server Database

原因

Confluence Database transaction log is full.

ソリューション

 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:

 

最終更新日 2016 年 8 月 5 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.