Upgrade Fails on Postgres
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
The following error appears in confluence-atlassian.log
1
2
3
4
5
6
2016-05-03 10:10:05,976 ERROR [localhost-startStop-1] [atlassian.confluence.plugin.PluginFrameworkContextListener]launchUpgrades Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.DropSpaceGroupTablesUpgradeTask@7c9e5eb8 failed
during the SCHEMA_UPGRADE phase due to: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE SPACES DROP COLUMN SPACEGROUPID]; SQL state [2BP01]; error code [0]; ERROR: cannot drop table spaces column spacegroupid because other objects depend on it
Detail: view content_with_group_perms depends on table spaces column spacegroupid
Hint: Use DROP ... CASCADE to drop the dependent objects too.; nested exception is org.postgresql.util.PSQLException: ERROR: cannot drop table spaces column spacegroupid because other objects depend on it
Detail: view content_with_group_perms depends on table spaces column spacegroupid
Hint: Use DROP ... CASCADE to drop the dependent objects too.or
A view is mentioned while DROPPING or UPDATING a table/column
1
Detail: view content_with_group_perms depends on table spaces column spacegroupidCause
A view was manually created. This view is a shortcut for a query.
Workaround
Return to the pre-upgrade state(rollback)
Drop the view with the following query:
1
DROP view <view-name>Upgrade Confluence.
Was this helpful?