目的

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.

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.

 注意:

Deleting the branch via the UI or the REST API calls will directly apply to the repositories thus there isn't any push reference being recorded in the sta_repo_push_ref table. There is currently an open feature request to add this to audit logging located at  BSERV-7046 - Getting issue details... STATUS