目录
环境
文档用途
详细信息
环境
系统平台：N/A
版本：4.5
文档用途
HAC集群环境中，因某种特殊原因需要删除当前data目录并重建数据库，能够快速搭建集群；避免重新安装。
详细信息
1、所有节点停止hghac服务，删除原data目录，重新在主节点initdb（原配置的HAC集群文件不变）
[root@db data]# systemctl stop hghac-vip[root@db data]# initdb -e sm4 -c "echo *******" -D db/hgdbdata/data复制
（左右滑动查看完整内容）
2、启动节点1的HAC服务，此时集群信息显示异常
[root@db data]# opt/HighGo/tools/hghac/hghactl -c opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7072987311974756506) +-----------+| Member | Host | Role | State | TL | Lag in MB |+--------+------+------+-------+----+-----------++--------+------+------+-------+----+-----------+[root@db data]# systemctl status hghac-vip复制
（左右滑动查看完整内容）
● hghac-vip.service - hghac
Loaded: loaded (/etc/systemd/system/hghac-vip.service; enabled; vendor preset: disabled)Active: failed (Result: exit-code) since Fri 2022-03-18 12:16:07 CST; 3min 7s agoProcess: 44961 ExecStart=/opt/HighGo/tools/hghac/hghac opt/HighGo/tools/hghac/hghac.yaml (code=exited, status=1/FAILURE)Main PID: 44961 (code=exited, status=1/FAILURE)Mar 18 12:16:05 db systemd[1]: Started hghac.Mar 18 12:16:07 db systemd[1]: hghac-vip.service: main process exited, code=exited, status=1/FAILUREMar 18 12:16:07 db systemd[1]: Unit hghac-vip.service entered failed state.Mar 18 12:16:07 db systemd[1]: hghac-vip.service failed.[root@db data]# systemctl start hghac-vip[root@db data]# systemctl status hghac-vip复制
（左右滑动查看完整内容）
● hghac-vip.service - hghac
Loaded: loaded (/etc/systemd/system/hghac-vip.service; enabled; vendor preset: disabled)Active: failed (Result: exit-code) since Fri 2022-03-18 12:19:26 CST; 2min 13s agoProcess: 45581 ExecStart=/opt/HighGo/tools/hghac/hghac opt/HighGo/tools/hghac/hghac.yaml (code=exited, status=1/FAILURE)Main PID: 45581 (code=exited, status=1/FAILURE)Mar 18 12:19:24 db systemd[1]: Started hghac.Mar 18 12:19:26 db systemd[1]: hghac-vip.service: main process exited, code=exited, status=1/FAILUREMar 18 12:19:26 db systemd[1]: Unit hghac-vip.service entered failed state.Mar 18 12:19:26 db systemd[1]: hghac-vip.service failed.复制
（左右滑动查看完整内容）
3、HAC集群日志中会报错集群的identifier与原来不一致（因为重新建库了）：
[root@db hghalog]# pwd/db/hgdbdata/hghalog[root@db hghalog]# tail -f patroni.log2022-03-18 12:16:06,807 INFO: Selected new etcd server http://192.168.80.111:23792022-03-18 12:16:06,828 INFO: No PostgreSQL configuration items changed, nothing to reload.2022-03-18 12:16:06,890 CRITICAL: system ID mismatch, node hghaca belongs to a different cluster: 7072987311974756506 != 70762866990207605662022-03-18 12:19:25,967 INFO: Selected new etcd server http://192.168.80.113:23792022-03-18 12:19:25,992 INFO: No PostgreSQL configuration items changed, nothing to reload.2022-03-18 12:19:26,063 CRITICAL: system ID mismatch, node hghaca belongs to a different cluster: 7072987311974756506 != 7076286699020760566复制
（左右滑动查看完整内容）
4、各节点重启etcd和hghac服务后，还是报错如上。
[root@db ~]# opt/HighGo/tools/hghac/etcd/amd64/etcdctl endpoint status --write-out=table+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| ENDPOINT | ID | VERSION | DB SIZE | IS LEADER | IS LEARNER | RAFT TERM | RAFT INDEX | RAFT APPLIED INDEX | ERRORS |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| http://192.168.80.111:2379 | ddbfd190d03ca278 | 3.4.15 | 20 kB | false | false | 218 | 1686066 | 1686066 | || http://192.168.80.112:2379 | 1c703f0b65f7bddb | 3.4.15 | 20 kB | false | false | 218 | 1686066 | 1686066 | || http://192.168.80.113:2379 | 92255e8f5c9ebfcd | 3.4.15 | 20 kB | true | false | 218 | 1686066 | 1686066 | |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+[root@db ~]# systemctl start hghac-vip[root@db ~]# opt/HighGo/tools/hghac/hghactl -c opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7072987311974756506) +-----------+| Member | Host | Role | State | TL | Lag in MB |+--------+------+------+-------+----+-----------++--------+------+------+-------+----+-----------+复制
（左右滑动查看完整内容）
5、原因分析：因为etcd的库文件中记录了此信息，需重新生成etcd的相关信息
[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lshgdw1.etcd[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lshgdw1.etcd[root@db etcd]# mv hgdw1.etcd hgdw1.etcd.bak <--所有节点都改名此目录或删除此目录[root@db etcd]# systemctl stop etcd[root@db etcd]# systemctl start etcd[root@db etcd]# pwd/opt/HighGo/tools/etcd[root@db etcd]# lltotal 0drwx------ 3 root root 20 Mar 18 12:34 hgdw1.etcddrwx------. 3 root root 20 Mar 18 12:27 hgdw1.etcd.bak <--重启etcd会重新生成该目录及其下的所有文件，[root@db etcd]# opt/HighGo/tools/hghac/etcd/amd64/etcdctl endpoint status --write-out=table+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| ENDPOINT | ID | VERSION | DB SIZE | IS LEADER | IS LEARNER | RAFT TERM | RAFT INDEX | RAFT APPLIED INDEX | ERRORS |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+| http://192.168.80.111:2379 | ddbfd190d03ca278 | 3.4.15 | 20 kB | true | false | 2 | 8 | 8 | || http://192.168.80.112:2379 | 1c703f0b65f7bddb | 3.4.15 | 20 kB | false | false | 2 | 8 | 8 | || http://192.168.80.113:2379 | 92255e8f5c9ebfcd | 3.4.15 | 20 kB | false | false | 2 | 8 | 8 | |+----------------------------+------------------+---------+---------+-----------+------------+-----------+------------+--------------------+--------+[root@db etcd]#[root@db etcd]# systemctl start hghac-vip <--此时启动HAC，集群信息显示正常[root@db etcd]# opt/HighGo/tools/hghac/hghactl -c opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7076286699020760566) ----+---------+----+-----------+-----------------+| Member | Host | Role | State | TL | Lag in MB | Pending restart |+--------+---------------------+--------+---------+----+-----------+-----------------+| hghaca | 192.168.80.111:5866 | Leader | running | 2 | | * |+--------+---------------------+--------+---------+----+-----------+-----------------+[root@db etcd]#复制
（左右滑动查看完整内容）
启动其他节点的HAC，结果如下：
[root@db etcd]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list+ Cluster: ha (7076286699020760566) -----+---------+----+-----------+-----------------+| Member | Host | Role | State | TL | Lag in MB | Pending restart |+--------+---------------------+---------+---------+----+-----------+-----------------+| hghaca | 192.168.80.111:5866 | Leader | running | 2 | | * || hghacb | 192.168.80.112:5866 | Replica | running | 2 | 0 | * || hghacc | 192.168.80.113:5866 | Replica | running | 2 | 0 | * |+--------+---------------------+---------+---------+----+-----------+-----------------+复制
（左右滑动查看完整内容）
文章转载自瀚高PG实验室，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
相关阅读
2025年4月中国数据库流行度排行榜：OB高分复登顶，崖山稳驭撼十强
墨天轮编辑部
1631次阅读
2025-04-09 15:33:27
2025年3月国产数据库大事记
墨天轮编辑部
811次阅读
2025-04-03 15:21:16
2025年3月国产数据库中标情况一览：TDSQL大单622万、GaussDB大单581万……
通讯员
576次阅读
2025-04-10 15:35:48
征文大赛 |「码」上数据库—— KWDB 2025 创作者计划启动
KaiwuDB
485次阅读
2025-04-01 20:42:12
数据库，没有关税却有壁垒
多明戈教你玩狼人杀
460次阅读
2025-04-11 09:38:42
国产数据库需要扩大场景覆盖面才能在竞争中更有优势
白鳝的洞穴
440次阅读
2025-04-14 09:40:20
最近我为什么不写评论国产数据库的文章了
白鳝的洞穴
364次阅读
2025-04-07 09:44:54
天津市政府数据库框采结果公布！
通讯员
343次阅读
2025-04-10 12:32:35
9.9 分高危漏洞，尽快升级到 pgAdmin 4 v9.2 进行修复
严少安
331次阅读
2025-04-11 10:43:23
优炫数据库成功入围新疆维吾尔自治区行政事业单位数据库2025年框架协议采购！
优炫软件
320次阅读
2025-04-18 10:01:22
