-
Bug
-
Resolution: Tracked Elsewhere
-
Medium
-
None
-
3.1
-
None
Upon Confluence upgrade to 3.1 or later, admin may discover that the IMAGEDETAILS table does not exist.
An upgrade misconfiguration is known to can cause this. For example:
- Admin created a test Confluence instance of the latest version and new database, then shut it down
- Admin imported production database into this new instance
- Admin copied production instance's Confluence Home but kept the test instance's confluence.cfg.xml
- Admin started test instance in the hope that this will upgrade Confluence
- Admin thought wrong! Because Confluence will see that the build number in confluence.cfg.xml is the same as the running Confluence version hence the upgrade is skipped.
Step 3 is wrong. The confluence.cfg.xml should also be updated to reflect the correct build number (click here for Confluence Build Information).
Sample error
2009-12-10 10:57:14,019 ERROR [http-8085-30] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.IMAGEDETAILS' doesn't exist -- referer: http://yourconfluenceurl.com/display/SPACEKEY/PageTitle | url: /pages/removeattachment.action | userName: blah | action: removeattachment | page: 7799349 2009-12-10 10:57:14,022 ERROR [http-8085-30] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.IMAGEDETAILS' doesn't exist -- referer: http://yourconfluenceurl.com/display/SPACEKEY/PageTitle | url: /pages/removeattachment.action | userName: blah | action: removeattachment | page: 7799349 2009-12-10 10:57:14,025 ERROR [http-8085-30] [atlassian.confluence.event.ConfluenceEventManager] publishEvent An exception was encountered while processing the event: com.atlassian.confluence.event.events.content.attachment.AttachmentRemoveEvent[source=com.atlassian.confluence.pages.DefaultAttachmentManager@5a0d8695] -- referer: http://yourconfluenceurl.com/display/SPACEKEY/PageTitle | url: /pages/removeattachment.action | userName: blah | action: removeattachment | page: 7799349 org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.IMAGEDETAILS' doesn't exist Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.IMAGEDETAILS' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
This issue can be prevented had we have CONF-18085 implemented.
See also CONF-13798
- is superseded by
-
CONFSERVER-18085 Need an integrity checker to check all required database tables exist after an upgrade
- Gathering Interest
- relates to
-
CONFSERVER-10759 'KEYSTORE' table doesn't exist. BackupEntities couldn't backup database data
- Closed