Unable to upgrade regarding CONTENTLOCK table
Symptoms
The following appears in the 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.
Diagnosis
When trying to use the installer, this error message can also appear on the UI.
Failing when upgrading JVM Path
Cause
Confluence tries to drop a table that does not exist. So the upgrade fails.
Workaround
You can create the table CONTENTLOCK manually so the upgrade will continue.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.