gpstart error in the Master log: "Invalid IP Mask"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Starting GPDB using gpstart fails with the below message:

20140523:18:21:53:307652 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20140523:18:21:55:307652 gpstart:mdw:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode
20140523:18:21:55:307652 gpstart:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1
 Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /data/master/gpseg-1 -l /data/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -b 1 -z 0 --silent-mode=true -i -M master -C -1 -x 66 -c gp_role=utility " start'
rc=1, stdout='waiting for server to start......could not start server
', stderr='pg_ctl: PID file "/data/master/gpseg-1/postmaster.pid" does not exist
'

Checking the master log at $MASTER_DATA_DIRECTORY/pg_log reports this message:

2014-05-23 18:21:53.860954 SGT,,,p307667,th-116709600,,,,0,,,seg-1,,,,,"LOG","F0000","invalid IP mask ""trust"": Name or service not known",,,,,"line 110 of configuration file ""/data/master/gpseg-1/pg_hba.conf""",,0,,"hba.c",992,
2014-05-23 18:21:53.861037 SGT,,,p307667,th-116709600,,,,0,,,seg-1,,,,,"FATAL","XX000","could not load pg_hba.conf",,,,,,,0,,"postmaster.c",1547,

Environment

Cause

As indicated by the message on the pg_logs, the file "/data/master/gpseg-1/pg_hba.conf" at line 110 has an invalid MASK for the IP address. The operation load/cache the pg_hba.conf in the memory is hence being aborted.

Checking the pg_hba.conf shows that the IP mask entry for line 110 was missing:

host     all         gpadmin         192.168.xx.xxx       trust

 

Resolution

To resolve this issue, follow the below steps: 

1. Please refer to this guide to see how to configure the pg_hba.conf.

2. Fix the pg_hba.conf file after applying the CIDR-ADDRESS or adding IP MASK format to the incorrect record (here we have used CIDR-ADDRESS format).

For example:

host     all         gpadmin         192.168.xx.xxx/32       trust

3. Attempt to start the database now:

gpstart -a