目的

Identify accidentally deleted branches.

ソリューション

Deleted branches can be detected by running the following query in Bitbucket Server:

• Replace <project_key> and <repository_slug> with the appropriate values:

  select p.project_key, r.slug, pr.ref_id, pr.change_type, pr.from_hash, pr.to_hash, nu.name, a.created_timestamp 
  from sta_repo_push_ref pr 
  	join sta_repo_activity ra on ra.activity_id = pr.activity_id 
  	join repository r on r.id = ra.repository_id 
  	join project p on p.id = r.project_id 
  	join sta_activity a on a.id = pr.activity_id 
  	join sta_normal_user nu on nu.user_id = a.user_id 
  where p.project_key = '<project_key>' 
  	and r.slug = '<repository_slug>' 
  	and to_hash like '0000000%' 
  order by a.created_timestamp desc;

• The query checks for branches where the tip of the branch is 0000000000000000000000000000000000000000. This identifies a deleted branch.

The <project_key> is the key defined for the project in the project table, and the <repository_slug> is the repo slug defined in the repository table.

Once the deleted branches have been identified, if the branch has to be restored, follow the instructions on the How to restore a deleted branch page.