Upgrade to Confluence 4.x Fails with "Cannot drop the index 'ATTACHMENTDATA.attch_idver_idx'"
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
症状
- You are upgrading from Confluence 3.4.x directly to Confluence 4.x or above.
The following error appears in the UI indicating upgrade failure:
You cannot access Confluence at present. Look at the table below to identify the reasons. Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade.atlassian-confluence.logに次のメッセージが表示される。2012-03-22 10:46:33,471 INFO [main] [confluence.upgrade.ddl.HibernateDdlExecutor] executeDdlStatements Executing DDL: drop index attch_idver_idx on ATTACHMENTDATA 2012-03-22 10:46:33,596 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.AddUniqueAttachmentIdConstraintToAttachmentDataUpgradeTask@a6cdf5 failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [drop index attch_idver_idx on ATTACHMENTDATA]; nested exception is java.sql.SQLException: Cannot drop the index 'ATTACHMENTDATA.attch_idver_idx', because it does not exist or you do not have permission.
原因
This error is typically caused when trying to upgrade from a pre-3.5.x version directly to 4.x. This bug has been filed here: CONFSERVER-27597 - Upgrading Confluence from 3.3.x and below to 4.x directly can fail with "Cannot drop the index 'ATTACHMENTDATA.attch_idver_idx'"
回避策
Try upgrading to 3.5.17 first as an intermediate step prior to going to 4.x.
ソリューション
The relevant bug (CONFSERVER-27597 - Upgrading Confluence from 3.3.x and below to 4.x directly can fail with "Cannot drop the index 'ATTACHMENTDATA.attch_idver_idx'") has been resolved in Confluence 4.3.7. You will no longer run into this issue when upgrading directly to this version or above.