Details
-
Bug
-
Resolution: Fixed
-
Medium
-
5.10.3, 5.11.1.1
-
None
-
None
Description
Summary
The upgrade from Bamboo 5.10.3 to 5.11.1.1 fails and the following error can be found in the logs:
java.sql.SQLException: Invalid column name 'ID'.
Environment
- Upgrade from Bamboo 5.10.3 to 5.11.1.1
- Backend database on SQL Server
Steps to Reproduce
- Install Bamboo 5.10.3 and run the Setup Wizard
- Follow the Bamboo 5.11.1.1 upgrade guide to upgrade to that version
Expected Results
Once Tomcat is started, the upgrade begins and finishes successfully.
Actual Results
- Once Tomcat is started, the upgrade begins, but upgrade task 51110 : Disallow duplicate trusted keys - remove duplicates fails with the following exception in the log:
ERROR [localhost-startStop-1] [AbstractUpgradeManager] java.sql.SQLException: Invalid column name 'ID'.
java.sql.SQLException: Invalid column name 'ID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.lambda$doUpgrade$20(UpgradeTask51110DisallowDuplicateTrustedKeys.java:46)
at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys$$Lambda$11/405586908.doInHibernateTransaction(Unknown Source)
at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:86)
at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.doUpgrade(UpgradeTask51110DisallowDuplicateTrustedKeys.java:42)
at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:206)
at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.doUpgrade(BootstrapUpgradeManagerImpl.java:59)
at com.atlassian.bamboo.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:359)
at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:77)
at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:117)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Workaround
- Stop Bamboo
- Backup original $BAMBOO_INSTALL/WEB-INF/lib/atlassian-bamboo-deployments-5.11.*.jar
- Copy attached atlassian-bamboo-deployments-5.11.1.1.jar
to $BAMBOO_INSTALL/WEB-INF/lib - Start Bamboo
Attachments
Issue Links
- is duplicated by
-
BDEV-11627 Loading...
- mentioned in
-