Upgrading to Confluence 3.x Fails Due to Table Doesn't Exist
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
Problem
During an upgrade to Confluence 3.x the atlassian-confluence.log contains:
1
2
3
4
5
2009-09-23 10:57:35,759 ERROR [Main Thread] [confluence.upgrade.upgradetask.ResizeProfileImagesUpgradeTask] doUpgrade SQL error occured whilst performing ResizeProfileImagesUpgradeTask
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databaseName.OS_USER' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
Cause
The upgrade failed because the upgrade task is not smart enough to identify what case sensitivity is used in the database. The error is a bit misleading because the table OS_USER actually exists, in lowercase.
⚠️ OS_USER table no longer exists in Confluence 5.x and above.
Resolution
Customers affected by this issue can refer to CONF-17039 for a resolution.
Was this helpful?