Unable to Upgrade Due to Database Permissions
症状
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add column DRAFTPAGEID varchar(255)
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ERROR: must be owner of relation content
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add column DRAFTSPACEKEY varchar(255)
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ERROR: must be owner of relation content
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add column DRAFTTYPE varchar(255)
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ERROR: must be owner of relation content
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add column DRAFTPAGEVERSION int4
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ERROR: must be owner of relation content
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table PAGETEMPLATES add column LABELS varchar(255)
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ERROR: must be owner of relation pagetemplates
原因
The database was owned by a user that is different from the database user used in Confluence.
ソリューション
Ensure that the tables' owner (http://archives.postgresql.org/pgsql-patches/2002-07/msg00198.php) are the same with the database user used by Confluence.
In PostgreSQL, a table's owner can be altered by using the ALTER TABLE query.
The database user is in either <confluence-home>/confluence.cfg.xml or server.xml.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.