2011-09-12 20:06:34,167 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [UpgradeTask2704InitializeRepositoryChangesets] Binding commits to repository changesets (it might take several minutes) ... 2011-09-12 20:08:44,082 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from] Caused by: java.sql.SQLException: Unexpected token: FROM in statement [from] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets$3.doInHibernate(UpgradeTask2704InitializeRepositoryChangesets.java:210) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate$2.doInTransactionWithoutResult(BambooTransactionHibernateTemplate.java:51) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate.execute(BambooTransactionHibernateTemplate.java:46) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets.processCommits(UpgradeTask2704InitializeRepositoryChangesets.java:200) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets.doUpgrade(UpgradeTask2704InitializeRepositoryChangesets.java:96) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:662) 2011-09-12 20:08:44,083 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] Completed upgrade task 2704 with errors. 2011-09-12 20:08:44,084 FATAL [main] [UpgradeLauncher] Upgrade task error: Upgrade task for build 2704 failed with exception: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from]
error when upgrading 2704 - unexpected token FROM in statement [from]
2011-09-12 20:06:34,167 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [UpgradeTask2704InitializeRepositoryChangesets] Binding commits to repository changesets (it might take several minutes) ... 2011-09-12 20:08:44,082 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from] Caused by: java.sql.SQLException: Unexpected token: FROM in statement [from] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets$3.doInHibernate(UpgradeTask2704InitializeRepositoryChangesets.java:210) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate$2.doInTransactionWithoutResult(BambooTransactionHibernateTemplate.java:51) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate.execute(BambooTransactionHibernateTemplate.java:46) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets.processCommits(UpgradeTask2704InitializeRepositoryChangesets.java:200) at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets.doUpgrade(UpgradeTask2704InitializeRepositoryChangesets.java:96) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:662) 2011-09-12 20:08:44,083 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] Completed upgrade task 2704 with errors. 2011-09-12 20:08:44,084 FATAL [main] [UpgradeLauncher] Upgrade task error: Upgrade task for build 2704 failed with exception: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Unexpected token: FROM in statement [from]