Upgrading to Confluence 3.x Fails Due to Table Doesn't Exist

Still need help?

The Atlassian Community is here for you.

Ask the community


During an upgrade to Confluence 3.x the atlassian-confluence.log contains:

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)


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.

(warning) OS_USER table no longer exists in Confluence 5.x and above.


Customers affected by this issue can refer to CONF-17039 for a resolution.

Last modified on Feb 12, 2020

Was this helpful?

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