[BAM-18445] Fail to upgrade from Bamboo 4.3.x to Bamboo 5.15.x

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 6.1.0, 6.0.4
Affects Version/s: 5.15.7
Component/s: Upgrading
Labels:
- bamboo-bugfix-kanban

Symptom Severity:
Severity 3 - Minor
Bug Fix Policy:
View Atlassian Server bug fix policy

Summary

Upgrading from Bamboo 4.3.x to Bamboo 5.15.x will fail in the Upgrade task 51507

Steps to Reproduce

Install Bamboo version 4.3.x
Upgrade it to Bamboo version 5.15.x

Expected Results

The upgrade will finish successfully without error

Actual Results

The below exception is thrown in the atlassian-bamboo.log file:

2017-06-07 14:06:29,086 INFO [localhost-startStop-1] [AbstractUpgradeManager] Completed task 51503 successfully.
2017-06-07 14:06:29,086 INFO [localhost-startStop-1] [AbstractUpgradeManager] --------------------------------------------
2017-06-07 14:06:29,086 INFO [localhost-startStop-1] [AbstractUpgradeManager] 51507 : Resize changeset columns (bootstrap)
2017-06-07 14:06:29,086 INFO [localhost-startStop-1] [AbstractUpgradeManager] --------------------------------------------
2017-06-07 14:06:29,087 INFO [localhost-startStop-1] [JdbcUtils] Executing: [alter table DEPLOYMENT_VERSION_CHANGESET alter CHANGESET_ID type character varying(128)]
2017-06-07 14:06:29,090 ERROR [localhost-startStop-1] [AbstractUpgradeManager] org.postgresql.util.PSQLException: ERROR: relation "deployment_version_changeset" does not exist
org.postgresql.util.PSQLException: ERROR: relation "deployment_version_changeset" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2310)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2023)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:217)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:421)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:318)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:310)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
	at com.atlassian.bamboo.utils.db.JdbcUtils.execute(JdbcUtils.java:65)
	at com.atlassian.bamboo.utils.db.PostgreSqlDbmsBean.resizeVarcharColumn(PostgreSqlDbmsBean.java:41)
	at com.atlassian.bamboo.upgrade.tasks.v5_15.UpgradeTask51507ResizeChangesetColumns.lambda$doUpgrade$0(UpgradeTask51507ResizeChangesetColumns.java:36)
	at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:83)

Notes

The table "deployment_version_changeset" does not exist in Bamboo version 4.3.x yet

Workaround

Upgrade Bamboo 4.3 to Bamboo version 5.14.x first

Monique Khairuliana (Inactive) made changes - 19/Aug/2019 2:04 AM

Workflow	Original: Bamboo Workflow 2016 v1 - Restricted [ 2306722 ]	New: JAC Bug Workflow v3 [ 3384817 ]
Status	Original: Resolved [ 5 ]	New: Closed [ 6 ]

Owen made changes - 24/Oct/2018 5:27 AM

Symptom Severity

Original: Minor [ 14432 ]

New: Severity 3 - Minor [ 15832 ]

Krystian Brazulewicz made changes - 26/Jun/2017 12:07 PM

Remote Link

New: This issue links to "+core+ Bamboo › C Licence › 6.0-~~BAM-18445~~-shat (tardigrade-bamboo)" [ 301454 ]