Update for CHILD_POSITION Table Fails Due to Database Permissions
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
After an upgrade, Confluence does not render. The logs contain something similar to:
1
2
3
4
2008-04-20 13:18:18,957 ERROR [http-8080-Processor4] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Unknown column 'contentent1_.CHILD_POSITION' in 'field list'
-- url: /dashboard.action | userName: STAPPEND | action: dashboard
....
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'contentent1_.CHILD_POSITION' in 'field list'
Cause
The DB login supplied by confluence does not have sufficient permissions to modify the schema of the DB. The column child_position (from content table), introduced in version 2.8, could not be created. This error can happen from any upgrade prior to 2.8 to 2.8 or above.
Resolution
Grant sufficient permissions to the confluence database. The database user and password are stored in the
confluence-home/confluence.cfg.xmlfile as the hibernate user and password.Restore an older version of Confluence and the confluence database.
Repeat the upgrade process.
Check if the table has been created.
Was this helpful?