Pivotal Knowledge Base

Follow

GPSTOP -U Error when Mirror is down: "PID File "/data1/mirror/gpseg13/postmaster.pid" does not exist Is server running"

Environment

 Product  Version
 Pivotal Greenplum   4.3.x
 OS  RHEL 6.x

Symptom

When one mirror is down: 

gpstate -e
20170222:10:21:25:026649 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -e
20170222:10:21:25:026649 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.11.3 build 1'
20170222:10:21:25:026649 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.11.3 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 24 2017 20:28:18'
20170222:10:21:25:026649 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170222:10:21:26:026649 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments...
.
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-Segment Mirroring Status Report
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-Primaries in Change Tracking
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-   Current Primary   Port    Change tracking size   Mirror   Port
20170222:10:21:27:026649 gpstate:mdw:gpadmin-[INFO]:-   sdw4              40001   0 bytes                sdw1     50001

gpstop -u does not work correctly: 

gpstop -u
20170222:10:21:34:026724 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args: -u
20170222:10:21:34:026724 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20170222:10:21:34:026724 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20170222:10:21:34:026724 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170222:10:21:35:026724 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.11.3 build 1'
20170222:10:21:35:026724 gpstop:mdw:gpadmin-[INFO]:-Signalling all postmaster processes to reload
.
20170222:10:21:36:026724 gpstop:mdw:gpadmin-[CRITICAL]:-Error occurred: Error Executing Command:
 Command was: 'ssh -o 'StrictHostKeyChecking no' sdw1 ". /var/vcap/packages/server/greenplum-db-4.3.11.3/greenplum_path.sh; $GPHOME/bin/pg_ctl reload -D /data1/mirror/gpseg13"'
rc=1, stdout='', stderr='pg_ctl: PID file "/data1/mirror/gpseg13/postmaster.pid" does not exist
Is server running?

Cause

This is a software defect reported under MPP-26819.

Resolution

If a mirror is down, gpstop -u will not work, gpstop and gpstart will need to be used as a workaround to reload the configuration. 

Comments

Powered by Zendesk