Upgrade Fails on Postgres
Problem
The following error appears in confluence-atlassian.log
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
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:
DROP view <view-name>- Upgrade Confluence.
Last modified on Nov 5, 2017
Powered by Confluence and Scroll Viewport.