Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-59560

Upgrading Confluence v5.0.3 to v7.2 fails on MS SQL Server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 7.2.0, 7.4.0
      • Confluence 5.0.3
      • SQL Server 2017
      • Windows Installer
      • Windows Server 2016

    Description

      Issue Summary

      Upgrading With Windows Installer Confluence 5.0.3 to 7.3 or 7.4.0-m05 Fails

      Steps to Reproduce

      1. Install Confluence 5.0.3 with installer
        • Connect with SQL Server 2017
        • Populate with example data during the set-up wizard
      2. Stop Confluence 5.0.3
      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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mduong@atlassian.com MichaelD
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: