Summary

This article explains how to update the "After branch inactivity in repository" setting located inside the Plan > Default plan configuration > Branches page directly in the database. This option is part of the automatic branch management settings and is used by Bamboo to determine when to delete a plan branch after it has gone inactive in the remote repository.

Environment

Bamboo versions 7.0 and higher.

Solution

It is currently not possible to bulk update this setting across different plans from the user interface. The only alternative is to make this change directly in the database. In the following examples we will demonstrate how to identify and enable/disable the "After branch inactivity in repository" setting.

Disable the "After branch inactivity in repository" option

1. Get a list of all the plans with Plan > Default plan configuration > Branches > Delete plan branch > After branch inactivity in repository enabled:

   SELECT build.full_key,
          build_definition.build_id,
          build.created_date,
          build.updated_date
     FROM build
     JOIN build_definition
       ON build.build_id = build_definition.build_id
    WHERE build.marked_for_deletion IS NOT NULL
      AND build_definition.xml_definition_data LIKE '%<inactiveBranchCleanupEnabled>true</inactiveBranchCleanupEnabled>%'
      AND build_type = 'CHAIN'
    ORDER BY updated_date ASC;

2. Take note of the BUILD_ID from the plans that you want to disable the "After branch inactivity in repository" option.

3. Stop Bamboo.

4. Replace the BUILD_ID in the following update query with the ID of plan(s) you want to update:

   UPDATE build_definition
      SET xml_definition_data = REPLACE(xml_definition_data,'<inactiveBranchCleanupEnabled>true</inactiveBranchCleanupEnabled>','<inactiveBranchCleanupEnabled>false</inactiveBranchCleanupEnabled>')
    WHERE build_definition.build_id IN ('BUILD_ID'); 

     You can add a list of BUILD_IDs separated by comma if you're looking to update multiple plans (e.g. '1234','5678','9012' and etc).

5. Run the update query to disable the option.
6. Start Bamboo.

Enable the "After branch inactivity in repository" option

1. Get a list of all the plans with Plan > Default plan configuration > Branches > Delete plan branch > After branch inactivity in repository disabled:

   SELECT build.full_key,
          build_definition.build_id,
          build.created_date,
          build.updated_date
     FROM build
     JOIN build_definition
       ON build.build_id = build_definition.build_id
    WHERE build.marked_for_deletion IS NOT NULL
      AND build_definition.xml_definition_data LIKE '%<inactiveBranchCleanupEnabled>false</inactiveBranchCleanupEnabled>%'
      AND build_type = 'CHAIN'
    ORDER BY updated_date ASC;

2. Take note of the BUILD_ID from the plans that you want to enable the "After branch inactivity in repository" option.

3. Stop Bamboo.

4. Replace the BUILD_ID in the following update query with the ID of plan(s) you want to update:

   UPDATE build_definition
      SET xml_definition_data = REPLACE(xml_definition_data,'<inactiveBranchCleanupEnabled>false</inactiveBranchCleanupEnabled>','<inactiveBranchCleanupEnabled>true</inactiveBranchCleanupEnabled>')
    WHERE build_definition.build_id IN ('BUILD_ID'); 

   You can add a list of BUILD_IDs separated by comma if you're looking to update multiple plans (e.g. '1234','5678','9012' and etc).

5. Replace the BUILD_ID in the following update query with the ID of plan(s) you want to update and yourInactiveDays with the number of days Bamboo should wait before deleting an inactive plan branch (e.g. 10, 30, 45 and etc)
   

   UPDATE build_definition
      SET xml_definition_data = Regexp_replace(xml_definition_data,'<inactivityInDays>\d+</inactivityInDays>','<inactivityInDays>yourInactiveDays</inactivityInDays>','g')
    WHERE build_definition.build_id IN ('BUILD_ID');

6. Run the update queries to enable the "After branch inactivity in repository" option and set the number of days.
7. Start Bamboo.