Bamboo planbranch setting to prevent deletion pendant in database

HeWi_h7vmoz

I wonder where in the Bamboo database the setting "Clean up plan branch automatically" is stored while creating a new planbranch?

(see 2b: https://confluence.atlassian.com/bamboo/using-plan-branches-289276872.html)

Is it maybe stored in a local database or xml file instead? The scheduler will not delete planbranches having the option deactivated and I would like to understand how Bamboo does make a decision between different plan branches.

Eduardo Alvarenga

Hello @HeWi

The Plan branch cleanup is defined on the BUILD_DEFINITION table in the database as an XML element within XML_DEFINITION_DATA.

<cleanup><disabled>true</disabled></cleanup>

This query might help you locate that information. Works on PostgreSQL.

SELECT B.BUILD_ID,
       B.BUILD_TYPE,
       B.FULL_KEY,
       BMD.BRANCH_NAME AS "branch_name",
       CASE
              WHEN CAST((XPATH('//branchConfiguration/cleanup/disabled/text()',CAST(BD.XML_DEFINITION_DATA AS XML)))[1] AS TEXT) = 'true' THEN 'NO'
              ELSE 'YES'
       END AS BRANCH_CLEANUP
FROM   BUILD B
JOIN   BUILD_DEFINITION BD
ON     B.BUILD_ID = BD.BUILD_ID
JOIN   BRANCH_METADATA BMD
ON     BMD.PLAN_ID = B.BUILD_ID
WHERE  B.BUILD_TYPE = 'CHAIN_BRANCH'

Regards,

Eduardo Alvarenga
Atlassian Support APAC