How to identify a deleted branch


アトラシアン コミュニティをご利用ください。


プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。


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,, 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 = ra.repository_id join project p on = r.project_id join sta_activity a on = 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.

(warning) 注意:

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

最終更新日 2018 年 8 月 16 日


Powered by Confluence and Scroll Viewport.