How to remove group and project in Gerrit ?

最新推荐文章于 2022-01-20 15:54:48 发布

scm002

最新推荐文章于 2022-01-20 15:54:48 发布

阅读量741

点赞数

分类专栏： Git/Gerrit 文章标签： git 数据库运维

本文链接：https://blog.youkuaiyun.com/scm002/article/details/84832502

版权

Git/Gerrit 专栏收录该内容

29 篇文章

订阅专栏

本文详细介绍了如何通过Gerrit的SQL数据库接口删除组和项目。对于组，需要删除ACCOUNT_GROUP_NAMES和ACCOUNT_GROUPS表中的相关条目；对于项目，需要删除projects、ref_rights表中的记录，并从Git存储库中移除对应的项目文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Group
1. access gerrit sql database
   cmd: ssh -p 29418 150.236.40.165 gerrit gsql
2. gerrit> delete from ACCOUNT_GROUP_NAMES where name='group name';
3. gerrit> delete from ACCOUNT_GROUPS where name='group name';

Project
1. access gerrit sql database
   cmd: ssh -p 29418 150.236.40.165 gerrit gsql
2. gerrit> delete from projects where name=<project name>;
3. gerrit> delete from ref_rights where project_name=<project name>;
4. go to folder /gerrit/review_site/git, remove <project name>.git

Example for remove project:
Step 1:
ecdshawk@mtvserver2:/project/ecds/gerrit/review_site/db>ssh -p 29418 150.236.40.165 gerrit gsql
Welcome to Gerrit Code Review 2.1.6.1
(H2 1.2.134 (2010-04-23))

Type '\h' for help.  Type '\r' to clear the buffer.

gerrit>

Step 2:
gerrit> delete from projects where name='rmproject';
UPDATE 1; 1 ms

Step 3:
gerrit> delete from ref_rights where project_name='rmproject';
UPDATE 1; 1 ms

Step 4:
ecdshawk@mtvserver2:/project/ecds/gerrit/review_site/git>ls
fproject.git  rmproject.git
ecdshawk@mtvserver2:/project/ecds/gerrit/review_site/git>rm -rf rmproject.git/
ecdshawk@mtvserver2:/project/ecds/gerrit/review_site/git>ls
fproject.git

Note: The projects is removed from database with Gerrit version 2.2. The method is simply. Delete project folder from Gerrit repo folder directly and restart Gerrit service.