Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.2.0, 7.4.0
-
- Confluence 5.0.3
- SQL Server 2017
- Windows Installer
- Windows Server 2016
-
11
-
Severity 3 - Minor
-
0
-
Description
Issue Summary
Upgrading With Windows Installer Confluence 5.0.3 to 7.3 or 7.4.0-m05 Fails
Steps to Reproduce
- Install Confluence 5.0.3 with installer
- Connect with SQL Server 2017
- Populate with example data during the set-up wizard
- Stop Confluence 5.0.3
- Upgrade to Confluence 7.3 or 7.4.0-m05 using the installer
Expected Results
Confluence upgrades successfully
Actual Results
Upgrade fails
The below exception is thrown in the atlassian-confluence.log file:
2020-03-01 17:51:51,900 INFO [Catalina-utility-1] [atlassian.confluence.upgrade.UpgradeTask] executeStatement About to execute: DROP INDEX "AO_54C900_SPACE_BLUEPRINT_AO"."index_ao_54c900_spa357134289"; 2020-03-01 17:51:51,900 INFO [Catalina-utility-1] [atlassian.confluence.upgrade.UpgradeTask] executeStatement About to execute: DROP INDEX "AO_6384AB_DISCOVERED"."index_ao_6384ab_dis59056004"; 2020-03-01 17:51:51,900 INFO [Catalina-utility-1] [atlassian.confluence.upgrade.UpgradeTask] executeStatement About to execute: DROP INDEX "AO_6384AB_FEATURE_METADATA_AO"."index_ao_6384ab_fea1458039816"; 2020-03-01 17:51:51,900 INFO [Catalina-utility-1] [atlassian.confluence.upgrade.UpgradeTask] executeStatement About to execute: DROP INDEX "AO_6384AB_FEATURE_METADATA_AO"."index_ao_6384ab_fea1458039816"; 2020-03-01 17:51:51,900 WARN [Catalina-utility-1] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions: ->[com.atlassian.confluence.upgrade.upgradetask.MsSqlServerAoUpgradeTask.doUpgrade]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT (Session #1123403011) 2020-03-01 17:51:51,916 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.MsSqlServerAoUpgradeTask@53515d2b failed during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [DROP INDEX "AO_6384AB_FEATURE_METADATA_AO"."index_ao_6384ab_fea1458039816";]; SQL state [S0007]; error code [3701]; Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission. com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.MsSqlServerAoUpgradeTask@53515d2b failed during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [DROP INDEX "AO_6384AB_FEATURE_METADATA_AO"."index_ao_6384ab_fea1458039816";]; SQL state [S0007]; error code [3701]; Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission. at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:237) ... 2020-03-01 17:51:51,916 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1 errors were encountered during upgrade: 2020-03-01 17:51:51,916 ERROR [Catalina-utility-1] [atlassian.confluence.plugin.PluginFrameworkContextListener] launchUpgrades 1: StatementCallback; uncategorized SQLException for SQL [DROP INDEX "AO_6384AB_FEATURE_METADATA_AO"."index_ao_6384ab_fea1458039816";]; SQL state [S0007]; error code [3701]; Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the index 'AO_6384AB_FEATURE_METADATA_AO.index_ao_6384ab_fea1458039816', because it does not exist or you do not have permission.
Workaround
Upgrade to 5.10.9 and then upgrade to 7.4.0 using installers