gpcrondump does not finish on Master
search cancel

gpcrondump does not finish on Master

book

Article ID: 296014

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
When running a backup using gpcrondump, the backup finishes on all segments but not on the master.

Below is an example of the backup log for the master.
20181007:01:00:12:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Starting gpcrondump with args: -x maindb  -c -g -G -a -q -r --cleanup-total=1
20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Directory /data/master/gpseg-1/db_dumps/20181007 not found, will try to create
20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Created /data/master/gpseg-1/db_dumps/20181007
20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Checked /data/master/gpseg-1 on master
20181007:01:02:21:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Configuring for single-database, include-table dump
20181007:01:02:23:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Validating disk space
20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Creating filter file: /data/master/gpseg-1/db_dumps/20181007/gp_dump_20181007010025_table
20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Adding compression parameter
20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Adding --no-expand-children
20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Dump process command line gp_dump -p 5432 -U gpadmin --gp-d=db_dumps/20181007 --gp-r=/data/master/gpseg-1/db_dumps/20181007 --gp-s=p --gp-k=20181007010025 --no-lock --gp-c --no-expand-children "maindb" --schema-file=/tmp/schema_list6kHOSd
20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Starting Dump process

Environment


Cause

When checking a master log file, the following entry is produced a few seconds after the dump process is started:
2018-10-07 01:07:54.625740 BST,"gpadmin","maindb",p10644,th1164502816,"169.25.79.22","4456",2018-10-07 01:07:54 BST,76750635,con1101913,,seg-1,,,x76750635,sx1,"FATAL","28000","no pg_hba.conf entry for host ""169.25.79.22"", user ""gpadmin"", database ""maindb"", SSL on",,,,,,,0,,"auth.c",608,

Resolution

Add a missing entry to the pg_hba.conf file for gpadmin. Run the command, gpstop -u to reload the access list and test it by running a backup.