Details
-
Suggestion
-
Resolution: Done
-
None
Description
Problem Definition
Database version or log of upgrade tasks are not currently recorded within the Bamboo database and there is nothing to prevent Bamboo from starting / re-running / skipping upgrade tasks on an already upgraded (or not upgraded) database. This is sometimes very obvious or goes completely undetected until integrity issues present further down the track.
Problems typically present in upgrade and rollback situations where mismatches occur between the version stored on the filesystem vs the state / version of the current database.
Suggested Solution
- Bamboo version stored within the database that reflects the current database state aka 'Database schema version'
- Audit log within database of upgrade tasks that have been run, with timestamp and status (e.g. success or failure). Ideally these log entries would be easily grouped with an identifier per upgrade attempt and show the detected version and the target version aka 'Database changelog table'
- Proactive validation that would prevent Bamboo from starting if a mismatch is detected. This should be clearly displayed in the UI (as opposed to a generic fatal bootstrap error) with an explanation of the error. The concept of filesystem version vs database version and it's importance in our upgrade procedure isn't common knowledge to a lot of Bamboo Administrators.
Attachments
Issue Links
- causes
-
BAM-4033 Bamboo database instance should be tagged with the bamboo revision build number to avoid version conflicts between db schema and bamboo.cfg.xml
- Closed
- has a derivative of
-
BAM-18567 Audit log for upgrade tasks
- Closed
-
BAM-18566 Audit log for upgrade tasks
- Gathering Interest
- is duplicated by
-
BAM-1708 Prevent Bamboo from being run with a database that has been upgraded by a later version
- Closed
-
BAM-18513 Move buildNumber from bamboo.cfg.xml to a database property
- Closed
- is related to
-
BAM-25651 Bamboo database version validation not working correctly allowing version rollbacks
- Closed
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...