Could not delete plan
症状
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.
原因
Early implementations of background plan deletion contained some bugs.
ソリューション
Database modification
This resolution includes manual modifications to Bamboo database. Please backup your data before proceeding!
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')