Upgrade Fails on Postgres

Still need help?

The Atlassian Community is here for you.

Ask the community

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 


view is mentioned while DROPPING or UPDATING a table/column

Detail: view content_with_group_perms depends on table spaces column spacegroupid

Cause

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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.