Upgrading to Confluence 3.x Fails Due to Table Doesn't Exist
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.
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.