4-Failed segment恢复.pdf - 墨天轮文档

4-Failed segment恢复.pdf

布衣

231

9页

3次

2024-01-06

10墨值下载

注：

FTS（Fault Tolerance Server）进程负责故障检测。该进程是master上的一个子进程，可以快速检测

到primary或者mirror是否宕机，并及时让primary/mirror进行故障切换。如果fts挂掉了，master还

会再重新fork出一个。

一、模拟segment异常

1、登录segment 存储节点，删除服务器上的数据：

1 [gpadmin@segment1 data]$ pwd

2 /u05/data

3 [gpadmin@segment1 data]$ ls

4 mirror mirror1 mirror2 mirror3 mirror4 primary primary1 primary2 primary3 primar

5 [gpadmin@segment1 data]$ rm -rf *

2、查询segment 状态：

1 [gpadmin@master ~]$ gpstate -m

2 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-Starting gpstate with args: -m

3 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-local Greenplum Version: 'postgre

4 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-master Greenplum Version: 'Postgr

5 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:-Obtaining Segment details from ma

6 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------

7 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:--Current GPDB mirror list and sta

8 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:--Type = Group

9 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------

10 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- Mirror Datadir

11 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror1/g

12 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror2/g

13 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror3/g

14 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment1 /u05/data/mirror4/g

15 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror1/g

16 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror2/g

17 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror3/g

18 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- segment2 /u05/data/mirror4/g

19 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror1/g

20 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror2/g

21 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror3/g

22 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- standby /u05/data/mirror4/g

23 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror1/g

24 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror2/g

25 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror3/g

26 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:- master /u05/data/mirror4/g

27 20231217:03:10:12:007919 gpstate:master:gpadmin-[INFO]:---------------------------------

28 20231217:03:10:12:007919 gpstate:master:gpadmin-[WARNING]:-4 segment(s) configured as mir

29 20231217:03:10:12:007919 gpstate:master:gpadmin-[WARNING]:-4 mirror segment(s) acting as

3、gpcc 监控平台显示：

4、数据库查询显示：

segment1 的实例status 均为 "d"

1 postgres=# select * from gp_segment_configuration order by role,dbid;

3 ------+---------+------+----------------+------+--------+------+----------+----------+--

4 6 | 4 | m | p | n | d | 6000 | segment1 | segment1 | /u

5 7 | 5 | m | p | n | d | 6001 | segment1 | segment1 | /u

6 8 | 6 | m | p | n | d | 6002 | segment1 | segment1 | /u

7 9 | 7 | m | p | n | d | 6003 | segment1 | segment1 | /u

8 18 | 0 | m | m | n | d | 7000 | segment1 | segment1 | /u

9 19 | 1 | m | m | n | d | 7001 | segment1 | segment1 | /u