Confluence site import fails at 90 percent with an error "There was an error during import/export with plugin Confluence Space IA Plugin"
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
問題
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)診断
環境
- Export from MySQL Server to MySQL
原因
This error is likely due to the AO tables which seems to already exist.
回避策
- 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.
最終更新日: 2024 年 12 月 31 日
Powered by Confluence and Scroll Viewport.