Bamboo Server fails to Initialize Plans on Server Restart

Symptoms

Bamboo Server fails to initialize plans and fails with the following exception

Cause

This is caused due to corruption in the Bamboo database, the LIST_POSITION column of CHAIN_STAGE table which stores the list order of Bamboo jobs is corrupted and has a value of -1

Resolution

To check if you're affected by this bug execute the following command:

select BUILD_ID from CHAIN_STAGE where LIST_POSITION= -1;

If the output returns any results, execute the following SQL;

select * from CHAIN_STAGE where BUILD_ID=<VALUE>; 
 

 STAGE_ID CREATED_D UPDATED_D NAME DESCRIPTION BUILD_ID LIST_POSITION MARKED_FOR_DELETION OPTIONAL_STAGE
---------- --------- --------- -------------------- ------------------------------------------------------- ---------- ------------- ------------------- --------------
 71401503 Smoke Test JOB_2 58097680 -1 0 0
 61538457 Build JOB_0 58097680 0 0 0
 71401504 Release JOB_1 58097680 1 0 0


In the example above JOB_2 ha sa LIST_POSITION of -1, instead of 2.

Find the correct List Position for your build and execute the SQL below:

update CHAIN_STAGE set LIST_POSITION = <VALUE> where STAGE_ID = <VALUE>;