Details
-
Bug
-
Resolution: Fixed
-
High
-
3.3
-
None
Description
Bamboo 3.3 upgrade fails with following exception;
2011-10-11 17:39:13,823 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] Running upgrade task 2704 : Init BuildResultSummaryRevisionKey 2011-10-11 17:39:13,823 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] -------------------------------------------------------------- 2011-10-11 17:39:13,840 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [UpgradeTask2704InitializeRepositoryChangesets] Binding commits to repository changesets (it might take several minutes) ... 2011-10-11 17:39:13,848 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'UC'. org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'UC'. Caused by: java.sql.SQLException: Incorrect syntax near 'UC'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets$3.doInHibernate(UpgradeTask2704InitializeRepositoryChangesets.java:219) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
The following SQL doesn't work on SQL Server 2005:
update USER_COMMIT UC set UC.REPOSITORY_CHANGESET_ID = ( select REPOSITORY_CHANGESET_ID from REPOSITORY_CHANGESET RC where RC.BUILDRESULTSUMMARY_ID = UC.BUILDRESULTSUMMARY_ID) where UC.REPOSITORY_CHANGESET_ID is null ;