gpinitstandby Fails with Error "pg_basebackup: could not read COPY data: server closed the connect" due to Permission Issue with Files in the Directory

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Adding a standby is failing with the following error:

20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname = mdw.gphd.local
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory = /data/master/gpseg-1
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port = 5432
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname = smdw
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port = 5432
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /data/master/gpseg-1
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog = On
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:- Filespace locations
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20150605:16:04:28:209741 gpinitstandby:mdw:gpadmin-[INFO]:-pg_system -> /data/master/gpseg-1
20150605:16:04:30:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby
20150605:16:04:30:209741 gpinitstandby:mdw:gpadmin-[INFO]:-The packages on smdw are consistent.
20150605:16:04:30:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file...
20150605:16:04:30:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file on segments...
20150605:16:04:36:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog...
20150605:16:04:36:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.
20150605:16:06:16:209741 gpinitstandby:mdw:gpadmin-[ERROR]:-Failed to copy filespace directories from master to standby.
20150605:16:06:16:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Trying to rollback changes that have been made...
20150605:16:06:16:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Backing up pg_hba.conf file...
20150605:16:06:16:209741 gpinitstandby:mdw:gpadmin-[ERROR]:-Failed to remove standby from master catalog.
20150605:16:06:16:209741 gpinitstandby:mdw:gpadmin-[INFO]:-Removing filespace directories on standby master...
20150605:16:06:22:209741 gpinitstandby:mdw:gpadmin-[ERROR]:-Error initializing standby master: ExecutionError: 'non-zero rc: 1' occured. Details: 'ssh -o 'StrictHostKeyChecking no' smdw ". /usr/local/greenplum-db/./greenplum_path.sh; pg_basebackup -x -R -E ./pg_log -E ./gp_dumps -E ./gpperfmon/data -D /data/master/gpseg-1 -h mdw.gphd.local -p 5432"' cmd had rc=1 completed=True halted=False
 stdout=''
 stderr='WARNING: skipping special file "./db_dumps"
pg_basebackup: could not read COPY data: server closed the connect

Environment

Cause

There was a file owned by root in the $MASTER_DATA_DIRECTORY:

[gpadmin@gpdbsne gpsne-1]$ find $MASTER_DATA_DIRECTORY -user root
/data/master/gpsne-1/pg_hba.conf.bak

 

Resolution

Correct the permission issue so that the gpadmin user is the owner and is able to copy the file.