Unable to Upgrade Due to Database Permissions

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms


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

Cause

The database was owned by a user that is different from the database user used in Confluence.

Resolution

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

Was this helpful?

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