You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I wonder where in the Bamboo database the setting "Clean up plan branch automatically" is stored while creating a new planbranch?
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.
The Plan branch cleanup is defined on the BUILD_DEFINITION table in the database as an XML element within XML_DEFINITION_DATA.
This query might help you locate that information. Works on PostgreSQL.
BMD.BRANCH_NAME AS "branch_name",
WHEN CAST((XPATH('//branchConfiguration/cleanup/disabled/text()',CAST(BD.XML_DEFINITION_DATA AS XML))) AS TEXT) = 'true' THEN 'NO'
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'
Atlassian Support APAC
Ahh, I see, thanks a lot for your reply @Eduardo Alvarenga , very helpful indeed.
Looking at the column with ntext datatype, it is kind of laborious, if the switch would have to be toggled, I would have to work with temporary tables, doing casting, etc.
Isn't there a simpler way in Bamboo to avoid specific plan branches from getting cleaned up automatically (I don't want to uncheck the planbranches manually)? I have to take two options into consideration:
a) cleanup due to git delete branch
b) cleanup due to branch inactivity
What if I would like to avoid bugfix/ branches from getting cleaned up? Is the only chance to look for bugfix/ branches in the tables and set disabled to true in the XML?
Thanks for the feedback. Following the community guidelines please avoid posting different concerns as a follow-up to a question that's been already answered.
If you are satisfied with the first answer please mark it as Accepted and post the next question as a second post and we'll be happy to assist. That eases the web crawler job and enhances indexing (and search) to other users.
Atlassian Support APAC