How do I find a bitbucket repo name from its numeric ID?..

[Sean Meacher]

We can find which repo corresponds to the numeric ID on disk from this:
https://confluence.atlassian.com/stashkb/identifying-a-repository-on-the-stash-server-292651201.html
but how do we find the repo name,  ie. the other way around?..

Thanks,
Sean

[Jeff Thomas]

Hi Sean,

If you're running Bitbucket Server 4.12+, this information is included in the repository-config file found in the root of the repository. For example, the contents of the file include:

#>***********************************************
# THIS FILE IS MAINTAINED BY ATLASSIAN BITBUCKET
# IT CONTAINS NO USER-SERVICEABLE PARTS.
#>***********************************************
[bitbucket]
 hierarchy = 11b8c8403bf885772b6f
 project = TEST
 repository = repo999

This improvement was tracked at https://jira.atlassian.com/browse/BSERV-3972

If you haven't upgraded to to 4.12 yet, you can run the following database query to get the information:

SELECT *
FROM repository
JOIN project ON project.id = repository.project_id
WHERE repository.id = 1;

Cheers,
Jeff

[Sean Meacher]

Thanks for that.
We are running 4.8.2.
I couldn't find that particular file but the ticket says
data/repositories/1/config (for example)

So, for us it shows:

[core]
repositoryformatversion = 0
filemode = true
bare = true
packedgitlimit = 256m
packedgitwindowsize = 32m
[http]
receivepack = true
[gc "stash-refs/pull-requests/*"]
reflogExpire = never
reflogExpireUnreachable = never
[stash]
hierarchyid = 4d84f350b24a685b122c



 

[Jeff Thomas]

Hi Sean,

The repository-config file won't exist until you're running at least 4.12. Since you're on 4.8, the DB query should give you the information you're after.