Unable to upgrade regarding CONTENTLOCK table
症状
atlassian-confluence.log に次のメッセージが表示される。
ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropContentLockTableUpgradeTask@5aaa5f failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [drop table CONTENTLOCK]; nested exception is java.sql.SQLException: Cannot drop the table 'CONTENTLOCK', because it does not exist or you do not have permission.
com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropContentLockTableUpgradeTask@5aaa5f failed during the SCHEMA_UPGRADE phase due to: StatementCallback; bad SQL grammar [drop table CONTENTLOCK]; nested exception is java.sql.SQLException: Cannot drop the table 'CONTENTLOCK', because it does not exist or you do not have permission.
診断
When trying to use the installer, this error message can also appear on the UI.
Failing when upgrading JVM Path
原因
Confluence tries to drop a table that does not exist. So the upgrade fails.
回避策
You can create the table CONTENTLOCK manually so the upgrade will continue.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.