Greenplum使用gpstate查看数据库系统的状态
gpstate显示正在运行的Greenplum数据库系统的状态。
概要
gpstate [-d master_data_directory] [-B parallel_processes]
[-s | -b | -Q | -e] [-m | -c] [-p] [-i] [-f] [-v | -q] | -x
[-l log_directory]
gpstate -? | -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数据库系统的详细信息：
gpstate -s
在Master主机系统目录中快速检查下游Segment：
gpstate -Q
显示关于镜像Segment实例的信息：
gpstate -m
显示关于后备Master配置的信息：
gpstate -f
显示Greenplum软件版本信息：
gpstate -i
示例详情
[gpadmin@mdw ~]$ gpstate
20221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
20221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
20221230: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'
20221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20221230:12:47:02:128776 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
.....
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Master instance = Active
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total segment instance count from metadata = 32
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Primary Segment Status
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segments = 16
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segment valid (at master) = 16
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid files missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid PIDs missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of /tmp lock files missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number postmaster processes missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Mirror Segment Status
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segments = 16
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment valid (at master) = 16
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total mirror segment failures (at master) = 0
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid files missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of postmaster.pid PIDs missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number of /tmp lock files missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[WARNING]:-Total number postmaster processes missing = 4 <<<<<<<<
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 12
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as primary segments = 0
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:- Total number mirror segments acting as mirror segments = 16
20221230:12:47:07:128776 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@mdw ~]$ gpstate -m
20221230:13:45:30:133051 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -m
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
20221230: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'
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--Type = Group
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam1/gpseg0 7000 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam2/gpseg1 7001 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam3/gpseg2 7002 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw2 /data2/gpdatam4/gpseg3 7003 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam1/gpseg4 7000 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam2/gpseg5 7001 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam3/gpseg6 7002 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw3 /data2/gpdatam4/gpseg7 7003 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam1/gpseg8 7000 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam2/gpseg9 7001 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam3/gpseg10 7002 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw4 /data2/gpdatam4/gpseg11 7003 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam1/gpseg12 7000 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam2/gpseg13 7001 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam3/gpseg14 7002 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:- sdw1 /data2/gpdatam4/gpseg15 7003 Passive Synchronized
20221230:13:45:31:133051 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@mdw ~]$ gpstate -s
20221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -s
20221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
20221230: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'
20221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20221230:13:46:50:133581 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
....
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:--Master Configuration & Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master host = mdw
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master postgres process ID = 23516
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master data directory = /data/gpmaster/gpseg-1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master port = 5432
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master current role = dispatch
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Greenplum initsystem version = 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source
20221230: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
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Postgres version = 9.4.24
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-Segment Instance Status Report
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56866
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E11/7A333218
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E11/7A333218
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E11/7A3331B0 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203157
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56860
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E0F/4AEA3FA0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E0F/4AEA3FA0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E0F/4AEA3F38 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203153
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56867
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E48/3448B900
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E48/3448B900
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E48/3448B898 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203158
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56856
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E38/A0D49C40
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E38/A0D49C40
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E38/A0D49BD8 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203149
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203155
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E6B/EC522DF8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E6B/EC522DF8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E6B/EC522D90 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134495
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg5
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203156
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg5
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E2B/E4AF0DD0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E2B/E4AF0DD0
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E2B/E4AF0D68 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134489
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg6
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203152
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg6
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E21/51932448
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E21/51932448
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E21/519323E0 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134493
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw2
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg7
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 203147
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg7
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E19/7FE0EBF8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E19/7FE0EBF8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E19/7FE0EB90 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134488
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134494
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg8
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E5B/3C6C5490
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E5B/3C6C5490
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E5B/3C6C5428 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg9
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134492
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg9
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E21/57CAF898
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E21/57CAF898
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E21/57CAF830 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg10
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134491
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg10
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E3B/5EAFCA90
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E3B/5EAFCA90
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E3B/5EAFCA28 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw3
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg11
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 134484
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Database status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg11
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E30/ADF49A08
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E30/ADF49A08
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E30/ADF499A0 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Segment status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap1/gpseg12
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam1/gpseg12
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7000
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E25/F06DF888
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E25/F06DF888
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E25/F06DF820 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56863
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap2/gpseg13
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam2/gpseg13
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7001
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E1F/83E23F60
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E1F/83E23F60
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E1F/83E23EF8 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56862
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap3/gpseg14
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam3/gpseg14
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7002
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E44/413A3870
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E44/413A3870
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E44/413A3808 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56865
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data1/gpdatap4/gpseg15
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 6003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Primary
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Synchronized
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Error Getting Segment Status = Error getting status from host sdw4
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:- Database status = Unknown -- unable to load segment status <<<<<<<<
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Hostname = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Address = sdw1
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Datadir = /data2/gpdatam4/gpseg15
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Port = 7003
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirroring Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Current role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Preferred role = Mirror
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Mirror status = Streaming
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Replication Info
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Sent Location = E33/A5967B38
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Flush Location = E33/A5967B38
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- WAL Replay Location = E33/A5967AD0 (104 bytes left)
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Status
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- PID = 56859
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Configuration reports status as = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[INFO]:- Segment status = Up
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-*****************************************************
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-Warnings have been generated during status processing
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-Check log file or review screen output
20221230:13:46:59:133581 gpstate:mdw:gpadmin-[WARNING]:-*****************************************************
报错：gpstate failed.
若是MASTER_DATA_DIRECTORY配置不正确，则会报错：
[gpadmin@mdw ~]$ gpstate
20230104:14:24:54:001260 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
20230104: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...
[gpadmin@mdw ~]$ export MASTER_DATA_DIRECTORY=/home/data/gpdata/gpmaster/gpseg-1
[gpadmin@mdw ~]$ gpstate
20230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args:
20230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.13.0 build commit:4f1adf8e247a9685c19ea02bcaddfdc200937ecd Open Source'
20230104: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'
20230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20230104:14:25:11:002335 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
....
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-Greenplum instance status summary
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Master instance = Active
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Master standby = No master standby configured
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total segment instance count from metadata = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Primary Segment Status
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segments = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segment valid (at master) = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid files found = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number of /tmp lock files found = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Total number postmaster processes found = 4
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Mirror Segment Status
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:- Mirrors not configured on this array
20230104:14:25:15:002335 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@mdw ~]$
参考
https://www.bookstack.cn/read/greenplum-admin_guide-6.0-zh/f83cec5984e71625.md
本文参与 腾讯云自媒体同步曝光计划，分享自微信公众号。
原始发表：2023-01-12，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
腾讯云开发者
