Confluence site import fails at 90 percent with an error "There was an error during import/export with plugin Confluence Space IA Plugin"
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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
Problem
Restoring an XML backup taken MySQL Server and importing into MySQL, fails at 90% with an error:
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.6.35
- minor version:6
- major version:5
Driver:
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.46 ( Revision: 9cc87a48e75c2d2e87c1a293b2862ce651cb256e )
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_9412A1_AONOTIFICATION' already exists
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:53)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:77)Diagnosis
Environment
- Export from MySQL Server to MySQL
Cause
This error is likely due to the AO tables which seems to already exist.
Workaround
- From the atlassian-confluence.log, find the entries which contain "Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table" using below:
aansari@C02ZF00KNCM3 application-logs % grep -rh "Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table" atlassian-confluence.log|sort -u
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_12D412_CFM_IFRAME_PREFS' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_21F425_USER_PROPERTY_AO' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_26DB7F_ENTITIES_TO_ROOM_CFG' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_4789DD_HEALTH_CHECK_STATUS' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_6384AB_FEATURE_METADATA_AO' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_88BB94_BATCH_NOTIFICATION' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_9412A1_AONOTIFICATION' already exists
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_ED669C_SEEN_ASSERTIONS' already exists
aansari@C02ZF00KNCM3 application-logs % - Drop the AO tables from the new Database where the import is failing
DROP TABLE AO_12D412_CFM_IFRAME_PREFS
DROP TABLE AO_21F425_USER_PROPERTY_AO
DROP TABLE AO_26DB7F_ENTITIES_TO_ROOM_CFG
DROP TABLE AO_4789DD_HEALTH_CHECK_STATUS
DROP TABLE AO_6384AB_FEATURE_METADATA_AO
DROP TABLE AO_88BB94_BATCH_NOTIFICATION
DROP TABLE AO_9412A1_AONOTIFICATION
DROP TABLE AO_ED669C_SEEN_ASSERTIONS- Re-import the XML backup.