Could not delete plan
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Log contains errors similar to this (right after message about successful Bamboo start)
1
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
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):
1
select FULL_KEY from BUILD where MARKED_FOR_DELETIONThen follow the article Deleting orphaned BuildResultSummary records modifying the queries to be executed:
instead of using:
1
WHERE B.FULL_KEY IS NULLuse the list of plan keys from previous query, ie:
1
WHERE B.FULL_KEY IN ('PLAN-A', 'PLAN-B', 'PLAN-C')Was this helpful?