Upgrading to Confluence 3.x Fails Due to Table Doesn't Exist
Problem
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)
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.
Last modified on Feb 12, 2020
Powered by Confluence and Scroll Viewport.