Summary

When troubleshooting code search issues for a repository, it may be useful to find out the latest commit that has been indexed in the Search instance.

This article describes procedures for retrieving the latest commit that has been indexed.

Environment

• Bitbucket Data Center

• Applies to both bundled and external search instances

Solution

Step 1: Retrieve Repository ID

The repository id can be retrieved with the following methods;

1. from the Bitbucket UI: go to Repository settings > Repository details and get the numeric value from the Location  field.
   Sample:
   If the Location  value is /var/application-data/bitbucket/shared/data/repositories/293 , the repository id is 293.
   
   
2. from the database through the following query:
   

   select r.id as repo_id 
   from repository r
   inner join project p on r.project_id=p.id
   where p.project_key = '<PROJECT_KEY>' and r.slug='<REPO_SLUG>';

   where:
   PROJECT_KEY is the project key in uppercase
   REPO_SLUG is the repository slug in lowercase

Step 2: Query the Search instance with the above Repository ID

Query the Search instance’ bitbucket-index-state  index, passing the repository id value from the previous step.

 curl -k -u <SEARCH_USER>:<SEARCH_PASSWORD> 
'<SEARCH_INSTANCE_URL>/bitbucket-index-state/_doc/<REPO_ID>'

where:
SEARCH_USER - user used by Bitbucket to connect to the Search instance
SEARCH_PASSWORD - password
SEARCH_INSTANCE_URL - base URL for the search instance
REPO_ID - repository id retrieved from the previous step

Sample request:

 curl -k -u bitbucket:password
'https://opensearch:9200/bitbucket-index-state/_doc/293'

Sample output:

{
  "_index": "bitbucket-index-state",
  "_type": "_doc",
  "_id": "293",
  "_version": 34,
  "_seq_no": 2491,
  "_primary_term": 248,
  "found": true,
  "_source": {
    "archived": false,
    "public": false,
    "fork": false,
    "retries": 0,
    "projectId": 322,
    "indexedCommitId": "569ad3a183637661b1c0dead082dd30517f43183"
  }
}

From the response, the latest commit that has been indexed for repo id 293  is 569ad3a183637661b1c0dead082dd30517f43183

Additional Notes

• Bitbucket only indexes the default branch

• Please see other considerations for code search indexing in: Bitbucket search syntax