2012-12-11 15:45:51,160 INFO [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [AbstractUpgradeManager] Running upgrade task 2701 : Set change set IDs for commits
2012-12-11 15:45:51,160 INFO [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [AbstractUpgradeManager] ----------------------------------------------------------
2012-12-11 15:45:57,871 INFO [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [UpgradeTask2701SetCommitId] Updating commit information for plan PROJ-PLAN (1 of 494)
2012-12-11 15:45:57,954 WARN [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [IgnoreMissingFieldXStream] Unable to resolve class for element name myEnableRemoteApi. Null being returned.
2012-12-11 15:45:57,986 ERROR [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [AbstractUpgradeManager] org.springframework.orm.hibernate.HibernateSystemException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index; nested exception is net.sf.hibernate.PropertyAccessException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index
org.springframework.orm.hibernate.HibernateSystemException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index; nested exception is net.sf.hibernate.PropertyAccessException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index
Caused by: net.sf.hibernate.PropertyAccessException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index
	at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:99)
	at net.sf.hibernate.persister.AbstractEntityPersister.getPropertyValues(AbstractEntityPersister.java:253)
	at net.sf.hibernate.impl.SessionImpl.flushEntity(SessionImpl.java:2504)
	at net.sf.hibernate.impl.SessionImpl.flushEntities(SessionImpl.java:2488)
	at net.sf.hibernate.impl.SessionImpl.flushEverything(SessionImpl.java:2283)
	at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1817)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3654)
	at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
	at com.atlassian.bamboo.repository.PlanRepositoryLinkHibernateDao$1.doInHibernate(PlanRepositoryLinkHibernateDao.java:43)
....
	at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:52)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.GeneratedMethodAccessor200.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at net.sf.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:96)
	... 56 more
Caused by: java.lang.IllegalStateException: Unable to find Stage Test in Chain com.atlassian.bamboo.chains.DefaultChain@c03aa7e3
	at com.atlassian.bamboo.chains.ChainStageImpl.getIndex(ChainStageImpl.java:158)
	... 60 more
2012-12-11 15:45:57,988 INFO [6-UpgradeTaskBackgroundThread:pool-13-thread-1] [AbstractUpgradeManager] Completed upgrade task 2701 with errors.
2012-12-11 15:45:57,989 FATAL [main] [UpgradeLauncher] Upgrade task error: Upgrade task for build 2701 failed with exception: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index; nested exception is net.sf.hibernate.PropertyAccessException: Exception occurred inside getter of com.atlassian.bamboo.chains.ChainStageImpl.index
2012-12-11 15:45:57,990 INFO [main] [ContextHandler] started o.e.j.w.WebAppContext{/,file:/bamboo/ibamboo432/webapp/},./webapp
2012-12-11 15:45:58,046 INFO [main] [/]  [CompressingFilter/1.4] CompressingFilter has initialized
2012-12-11 15:45:58,073 INFO [main] [/] org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
2012-12-11 15:45:58,074 INFO [main] [AccessLogFilter] AccessLogFilter initialized. Format is: <user> <url> <starting memory free (kb)> +- <difference in free mem (kb)> <query time (ms)>
2012-12-11 15:45:58,126 INFO [main] [AbstractConnector] Started SelectChannelConnector@0.0.0.0:8080

select build_id, list_position, count(build_id) from chain_stage group by build_id,list_position having count(build_id)>1;

select stage_id, list_position from chain_stage where build_id=105906195;

select stage_id, build_id, list_position from chain_stage where build_id=105906195 and stage_id=106004492;
select stage_id, build_id, list_position from chain_stage where build_id=105906195 and stage_id=106004493;
select stage_id, build_id, list_position from chain_stage where build_id=105906195 and stage_id=106004494;

update chain_stage set LIST_POSITION=1 where build_id=105906195 and stage_id=106004493;update chain_stage set LIST_POSITION=2 where build_id=105906195 and stage_id=106004494;

SELECT stage_id, row_number() over (partition by build_id order by list_position, stage_id) - 1 as new_list_position INTO TEMP fix_chain_stage_table FROM chain_stage ORDER BY build_id, list_position, stage_id;
UPDATE chain_stage SET list_position = f.new_list_position FROM fix_chain_stage_table f WHERE chain_stage.stage_id = f.stage_id;
DROP TABLE fix_chain_stage_table;