-
Bug
-
Resolution: Fixed
-
High
-
5.15.7
-
Severity 3 - Minor
-
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