gpstate显示正在运行的Greenplum数据库系统的状态。
概要
1gpstate [-d master_data_directory] [-B parallel_processes]
2 [-s | -b | -Q | -e] [-m | -c] [-p] [-i] [-f] [-v | -q] | -x
3 [-l log_directory]
4gpstate -? | -h | --help
描述
gpstate工具显示有关正在运行的Greenplum数据库实例的信息。 由于Greenplum数据库系统由跨多台机器的多个PostgreSQL数据库实例（Segment）组成， 因此用户可能需要了解关于Greenplum数据库系统的额外信息。gpstate 工具为Greenplum数据库系统提供了额外的状态信息，例如：
哪台Segment主机已被关闭？
Master和Segment配置信息（主机、数据目录等）。
系统使用的端口。
主Segment到其相应的镜像Segment的映射。
选项
-b（简要状态）
可选。显示Greenplum数据库系统状态的简要概述。这是默认选项。
-B parallel_processes
并行检查的Segment数。如果未指定，则工具将根据需要检查多少个Segment实例启动最多60个并行进程。
-c（显示主Segment到镜像Segment的映射）
可选。显示主Segment到镜像Segment的映射。
-d master_data_directory
可选。Master的数据目录。如果未指定，则使用为$MASTER_DATA_DIRECTORY 设置的值。
-e（显示镜像状态出问题的Segment）
显示具有潜在问题的主要/镜像Master对的详细信息，例如1）活动Segment正在Change Tracking模式下运行， 表示Segment处于关闭状态；2）活动Segment处于重新同步模式，这意味着它正在赶上对镜像的更改；3） 一个Segment不是它的首选角色，例如在系统初始化时作为一个主Segment的现在作为一个镜像Segment， 这意味着用户可能有一台或多台Segment主机的处理负载不平衡。
-f（显示后备Master的详情）
显示后备Master主机的详细信息（如果配置）。
-i（显示Greenplum数据库的版本）
显示每个实例的Greenplum数据库软件版本信息。
-l logfile_directory
写入日志文件的目录。默认为~/gpAdminLogs。
-m（列出镜像）
可选。列出系统中的镜像Segment实例及其当前角色和同步状态。
-p（显示端口）
列出整个Greenplum数据库系统使用的端口号。
-q（没有屏幕输出）
可选。以静默模式运行。除了警告信息之外，屏幕上不显示命令输出。但是， 这些信息仍然写入到日志文件中。
-Q（快速状态）
可选。在Master主机上的系统目录中检查Segment的状态。不直接向Segment征询状态。
-s（详细状态）
可选。显示Greenplum数据库系统的详细状态信息.
-v（详细输出）
可选。显示错误消息并输出详细的状态和进度信息。
-x (expand)
Optional. Displays detailed information about the progress and state of a Greenplum system expansion.
-? | -h | —help (help)
显示在线帮助。
输出字段定义
以下输出字段由主机的gpstate -s报告：
| 输出数据 | 描述 |
|---|---|
| Master host | Master的主机名 |
| Master postgres process ID | 主数据库侦听进程的PID |
| Master data directory | 主数据目录的文件系统位置 |
| Master port | Master上postgres数据库监听器进程的端口 |
| Master current role | dispatch = 常规操作模式utility = 维护模式 |
| Greenplum array configuration type | Standard = 每台主机一个NICMulti-Home = 每台主机多个NIC |
| Greenplum initsystem version | 系统第一次初始化时的Greenplum数据库版本 |
| Greenplum current version | Greenplum数据库当前的版本 |
| Postgres version | Greenplum数据库基于的PostgreSQL版本 |
| Greenplum mirroring status | 物理镜像或无镜像 |
| Master standby | 后备Master的主机名 |
| Standby master state | 后备Master的状态：活跃或被动 |
以下输出字段由gpstate -s为每个Segment报告：
| 输出数据 | 描述 |
|---|---|
| Hostname | 系统配置的主机名 |
| Address | 网络地址主机名（NIC名称） |
| Datadir | Segment数据目录的文件系统位置 |
| Port | Segment的postgres数据库监听器进程的端口号 |
| Current Role | Segment的当前角色：Mirror或 Primary |
| Preferred Role | 系统初始化时的角色：Mirror或 Primary |
| Mirror Status | 主/镜像Segment对的状态：Synchronized = 两者上的数据都是最新Resynchronization = 数据当前正被从一个拷贝到另一个Change Tracking = Segment停止并且活动Segment正在记录更改 |
| Change tracking data size | 当处于Change Tracking模式中时， 更改日志文件的尺寸（如果应用压缩，尺寸可能增长或者收缩） |
| Estimated total data to synchronize | 当处于Resynchronization模式中时， 剩下要同步的数据的估计尺寸 |
| Data synchronized | 当处于Resynchronization模式中时， 已经被同步的数据的估计尺寸 |
| Estimated resync progress with mirror | 当处于Resynchronization模式中时， 完成百分比的估计值 |
| Estimated resync end time | 当处于Resynchronization模式中时， 完成时间的估计 |
| File postmaster.pid | postmaster.pid锁文件的状态： Found或Missing |
| PID from postmaster.pid file | postmaster.pid文件中找到的PID |
| Lock files in tmp | 为Segment的postgres会在 tmp中创建Segment端口锁文件（当Segment关闭时会移除该文件） |
| Active PID | Segment的活动进程ID |
| Master reports status as | 系统目录中报告的Segment状态： Up或Down |
| Database status | Greenplum数据库对进入请求的状态： Up、Down或Suspended。 Suspended状态意味着当Segment正从一种状态转移到另一种状态时， 数据库活动被临时暂停。 |
以下输出字段由gpstate -f为每个后备Master复制状态报告：
| 输出数据 | 描述 |
|---|---|
| Standby address | 后备Master的主机名 |
| Standby data dir | 后备Master的数据目录的文件系统位置 |
| Standby port | 后备Master的postgres数据库监听器进程的端口 |
| Standby PID | 后备Master的进程ID |
| Standby status | 后备Master的状态：Standby host passive |
| WAL Sender State | 预写式日志（WAL）流状态： streaming、 startup、backup、catchup |
| Sync state | WAL发送者同步状态：sync |
| Sent Location | WAL发送者事务日志（xlog）记录发送位置 |
| Flush Location | WAL接收者xlog记录刷入位置 |
| Replay Location | 后备上xlog记录重放位置 |
命令示例
显示Greenplum数据库系统的详细信息：
1gpstate -s
在Master主机系统目录中快速检查下游Segment：
1gpstate -Q
显示关于镜像Segment实例的信息：
1gpstate -m
显示关于后备Master配置的信息：
1gpstate -f
显示Greenplum软件版本信息：
1gpstate -i
示例详情
1[gpadmin@mdw ~]$ gpstate
220221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
320221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
420221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16'
520221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
620221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
7.....
820221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary
920221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
1020221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Master instance = Active
1120221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
1220221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total segment instance count from metadata = 32
1320221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
1420221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Primary Segment Status
1520221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
1620221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segments = 16
1720221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segment valid (at master) = 16
1820221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
1920221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid files missing = 4 <<<<<<<<
2020221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 12
2120221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid PIDs missing = 4 <<<<<<<<
2220221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 12
2320221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of /tmp lock files missing = 4 <<<<<<<<
2420221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 12
2520221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number postmaster processes missing = 4 <<<<<<<<
2620221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 12
2720221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
2820221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Mirror Segment Status
2920221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
3020221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segments = 16
3120221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment valid (at master) = 16
3220221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment failures (at master) = 0
3320221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid files missing = 4 <<<<<<<<
3420221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 12
3520221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid PIDs missing = 4 <<<<<<<<
3620221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 12
3720221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of /tmp lock files missing = 4 <<<<<<<<
3820221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 12
3920221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number postmaster processes missing = 4 <<<<<<<<
4020221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 12
4120221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as primary segments = 0
4220221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as mirror segments = 16
4320221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
44[gpadmin@mdw ~]$ gpstate -m
4520221230:13:45:30:133051 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -m
4620221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
4720221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16'
4820221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
4920221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
5020221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status
5120221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--Type = Group
5220221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
5320221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
5420221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam1/gpseg0 7000 Passive Synchronized
5520221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam2/gpseg1 7001 Passive Synchronized
5620221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam3/gpseg2 7002 Passive Synchronized
5720221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam4/gpseg3 7003 Passive Synchronized
5820221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam1/gpseg4 7000 Passive Synchronized
5920221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam2/gpseg5 7001 Passive Synchronized
6020221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam3/gpseg6 7002 Passive Synchronized
6120221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam4/gpseg7 7003 Passive Synchronized
6220221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam1/gpseg8 7000 Passive Synchronized
6320221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam2/gpseg9 7001 Passive Synchronized
6420221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam3/gpseg10 7002 Passive Synchronized
6520221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam4/gpseg11 7003 Passive Synchronized
6620221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam1/gpseg12 7000 Passive Synchronized
6720221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam2/gpseg13 7001 Passive Synchronized
6820221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam3/gpseg14 7002 Passive Synchronized
6920221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam4/gpseg15 7003 Passive Synchronized
7020221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
71[gpadmin@mdw ~]$ gpstate -s
7220221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -s
7320221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
7420221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16'
7520221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
7620221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
77....
7820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
7920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:--Master Configuration & Status
8020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
8120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master host = mdw
8220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master postgres process ID = 23516
8320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master data directory = /data/gpmaster/gpseg-1
8420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master port = 5432
8520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master current role = dispatch
8620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Greenplum initsystem version = 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source
8720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Greenplum current version = PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16
8820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Postgres version = 9.4.24
8920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
9020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
9120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-Segment Instance Status Report
9220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
9320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
9420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
9520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
9620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg0
9720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
9820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
9920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
10020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
10120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
10220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
10320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56866
10420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
10520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
10620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
10720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
10820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
10920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
11020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg0
11120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
11220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
11320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
11420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
11520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
11620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
11720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E11/7A333218
11820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E11/7A333218
11920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E11/7A3331B0 (104 bytes left)
12020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
12120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203157
12220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
12320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
12420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
12520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
12620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
12720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
12820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg1
12920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
13020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
13120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
13220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
13320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
13420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
13520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56860
13620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
13720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
13820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
13920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
14020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
14120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
14220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg1
14320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
14420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
14520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
14620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
14720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
14820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
14920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E0F/4AEA3FA0
15020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E0F/4AEA3FA0
15120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E0F/4AEA3F38 (104 bytes left)
15220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
15320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203153
15420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
15520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
15620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
15720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
15820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
15920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
16020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg2
16120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
16220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
16320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
16420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
16520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
16620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
16720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56867
16820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
16920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
17020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
17120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
17220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
17320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
17420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg2
17520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
17620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
17720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
17820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
17920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
18020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
18120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E48/3448B900
18220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E48/3448B900
18320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E48/3448B898 (104 bytes left)
18420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
18520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203158
18620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
18720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
18820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
18920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
19020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
19120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
19220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg3
19320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
19420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
19520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
19620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
19720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
19820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
19920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56856
20020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg3
20720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
20820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
21020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
21120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
21220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
21320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E38/A0D49C40
21420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E38/A0D49C40
21520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E38/A0D49BD8 (104 bytes left)
21620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
21720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203149
21820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
21920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
22020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
22120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
22220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
22320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
22420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg4
22520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
22620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
22720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
22820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
22920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
23020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
23120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203155
23220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
23320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
23420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
23520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
23620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
23720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
23820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg4
23920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
24020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
24120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
24220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
24320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
24420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
24520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E6B/EC522DF8
24620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E6B/EC522DF8
24720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E6B/EC522D90 (104 bytes left)
24820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
24920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134495
25020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
25120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
25220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
25320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
25420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
25520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
25620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg5
25720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
25820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
25920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
26020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
26120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
26220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
26320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203156
26420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
26520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
26620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
26720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
26820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
26920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
27020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg5
27120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
27220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
27320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
27420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
27520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
27620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
27720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E2B/E4AF0DD0
27820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E2B/E4AF0DD0
27920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E2B/E4AF0D68 (104 bytes left)
28020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
28120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134489
28220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
28320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
28420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
28520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
28620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
28720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
28820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg6
28920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
29020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
29120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
29220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
29320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
29420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
29520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203152
29620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
29720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
29820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
29920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
30020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
30120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
30220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg6
30320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
30420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
30520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
30620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
30720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
30820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
30920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E21/51932448
31020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E21/51932448
31120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E21/519323E0 (104 bytes left)
31220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
31320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134493
31420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
31520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
31620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
31720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
31820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
31920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
32020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg7
32120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
32220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
32320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
32420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
32520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
32620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
32720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203147
32820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
32920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
33020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
33120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
33220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
33320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
33420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg7
33520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
33620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
33720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
33820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
33920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
34020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
34120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E19/7FE0EBF8
34220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E19/7FE0EBF8
34320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E19/7FE0EB90 (104 bytes left)
34420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
34520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134488
34620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
34720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
34820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
34920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
35020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
35120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
35220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg8
35320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
35420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
35520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
35620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
35720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
35820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
35920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134494
36020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
36120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
36220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
36320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
36420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
36520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
36620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg8
36720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
36820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
36920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
37020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
37120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
37220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
37320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
37420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
37520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E5B/3C6C5490
37620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E5B/3C6C5490
37720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E5B/3C6C5428 (104 bytes left)
37820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
37920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
38020221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
38120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
38220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
38320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
38420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
38520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg9
38620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
38720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
38820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
38920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
39020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
39120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
39220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134492
39320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
39420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
39520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
39620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
39720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
39820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
39920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg9
40020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
40120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
40220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
40320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
40420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
40520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
40620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
40720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
40820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E21/57CAF898
40920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E21/57CAF898
41020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E21/57CAF830 (104 bytes left)
41120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
41220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
41320221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
41420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
41520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
41620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
41720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
41820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg10
41920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
42020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
42120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
42220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
42320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
42420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
42520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134491
42620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
42720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
42820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
42920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
43020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
43120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
43220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg10
43320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
43420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
43520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
43620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
43720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
43820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
43920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
44020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
44120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E3B/5EAFCA90
44220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E3B/5EAFCA90
44320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E3B/5EAFCA28 (104 bytes left)
44420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
44520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
44620221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
44720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
44820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
44920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
45020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
45120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg11
45220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
45320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
45420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
45520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
45620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
45720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
45820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134484
45920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
46020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
46120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
46220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
46320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
46420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
46520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg11
46620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
46720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
46820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
46920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
47020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
47120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
47220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
47320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
47420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E30/ADF49A08
47520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E30/ADF49A08
47620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E30/ADF499A0 (104 bytes left)
47720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
47820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
47920221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
48020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
48120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
48220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
48320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
48420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg12
48520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
48620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
48720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
48820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
48920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
49020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
49120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
49220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
49320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
49420221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
49520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
49620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
49720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
49820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
49920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg12
50020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
50120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
50220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
50320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
50420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
50520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
50620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E25/F06DF888
50720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E25/F06DF888
50820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E25/F06DF820 (104 bytes left)
50920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
51020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56863
51120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
51220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
51320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
51420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
51520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
51620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
51720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg13
51820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
51920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
52020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
52120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
52220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
52320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
52420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
52520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
52620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
52720221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
52820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
52920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
53020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
53120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
53220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg13
53320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
53420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
53520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
53620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
53720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
53820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
53920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E1F/83E23F60
54020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E1F/83E23F60
54120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E1F/83E23EF8 (104 bytes left)
54220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
54320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56862
54420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
54520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
54620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
54720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
54820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
54920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
55020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg14
55120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
55220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
55320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
55420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
55520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
55620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
55720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
55820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
55920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
56020221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
56120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
56220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
56320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
56420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
56520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg14
56620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
56720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
56820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
56920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
57020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
57120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
57220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E44/413A3870
57320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E44/413A3870
57420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E44/413A3808 (104 bytes left)
57520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
57620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56865
57720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
57820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
57920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
58020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
58120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
58220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
58320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg15
58420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
58520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
58620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
58720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
58820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
58920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
59020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
59120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
59220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
59320221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
59420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
59520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
59620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
59720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
59820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg15
59920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
60020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
60120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
60220221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
60320221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
60420221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
60520221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E33/A5967B38
60620221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E33/A5967B38
60720221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E33/A5967AD0 (104 bytes left)
60820221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
60920221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56859
61020221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
61120221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
61220221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-*****************************************************
61320221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-Warnings have been generated during status processing
61420221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-Check log file or review screen output
61520221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-*****************************************************
616
报错：gpstate failed.
若是MASTER_DATA_DIRECTORY
配置不正确，则会报错：
1[gpadmin@mdw ~]$ gpstate
220230104:14:24:54:001260 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
320230104:14:24:54:001260 gpstate:mdw:gpadmin-[CRITICAL]:-gpstate failed. (Reason='[Errno 2] No such file or directory: '/data/gpdata/gpmaster/gpseg-1/postgresql.conf'') exiting...
4[gpadmin@mdw ~]$ export MASTER_DATA_DIRECTORY=/home/data/gpdata/gpmaster/gpseg-1
5[gpadmin@mdw ~]$ gpstate
620230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
720230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
820230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Dec 18 2020 22:31:16'
920230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
1020230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
11....
1220230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary
1320230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
1420230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Master instance = Active
1520230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
1620230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total segment instance count from metadata = 4
1720230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
1820230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Primary Segment Status
1920230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
2020230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segments = 4
2120230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segment valid (at master) = 4
2220230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
2320230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
2420230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
2520230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
2620230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
2720230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
2820230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
2920230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes missing = 0
3020230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 4
3120230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
3220230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Mirror Segment Status
3320230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
3420230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Mirrors not configured on this array
3520230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
36[gpadmin@mdw ~]$
37
参考
https://www.bookstack.cn/read/greenplum-admin_guide-6.0-zh/f83cec5984e71625.md
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
