Symptoms

Log contains errors similar to this (right after message about successful Bamboo start)

2011-11-21 12:03:13,904 ERROR [0-BAM::Events:pool-1-thread-6] [DeletionServiceImpl] Could not delete plan 'BATCHGTIONCONTR-ZIPPRE'

Then usually are JDBC message errors and stacktrace.

Cause

Early implementations of background plan deletion contained some bugs.

Resolution

In order to get a list of plans that are pending removal execute following DB query (needs to be adapted for DB engines which do not use "boolean" data type):

select FULL_KEY from BUILD where MARKED_FOR_DELETION

Then follow the article Deleting orphaned BuildResultSummary records modifying the queries to be executed:

instead of using:

WHERE B.FULL_KEY IS NULL

use the list of plan keys from previous query, ie:

WHERE B.FULL_KEY IN ('PLAN-A', 'PLAN-B', 'PLAN-C')