Menu

#4548 [HHQ-4502] DBUpgrader can downgrade schema version

Bug
open
None
5
2012-10-09
2010-12-10
No

http://jira.hyperic.com/browse/HHQ-4502


If a user starts an older version of HQ (say to roll back to an older release) without restoring the database the schema version will be improperly set causing future upgrades to fail. An example log: (note the user simply started up the 4.4 server, the db migration is done as part of the server startup in HQ 4.2 on)



Property "jboss.home" has not been set


[export-counters] Setting Alert Counter exportDir to ${jboss.home}


[dbupgrade] Starting schema migration: 3.199 -> LATEST


[dbupgrade] DATABASE SUCCESSFULLY UPGRADED TO 3.196



Obviously this is not a supported operation, however we shouldn't let the DB upgrader go 'backwards'. I'd suggest that if this is detected the server should fail to start.

Discussion

Anonymous
Anonymous

Add attachments
Cancel