Upgrade Fails on Postgres
問題
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.
または
A view is mentioned while DROPPING or UPDATING a table/column
Detail: view content_with_group_perms depends on table spaces column spacegroupid原因
A view was manually created. This view is a shortcut for a query.
回避策
- Return to the pre-upgrade state(rollback)
- Drop the view with the following query:
DROP view <view-name>- Upgrade Confluence.
最終更新日 2017 年 11 月 5 日
Powered by Confluence and Scroll Viewport.