错误信息

  1. [gpadmin@mdw ~]$ gpstart -a
  2. 20200330:20:55:22:006802 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a
  3. 20200330:20:55:22:006802 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
  4. 20200330:20:55:22:006802 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.5.0 build commit:27520b0e901cefe748684c02e5155fb015cd5cc2'
  5. 20200330:20:55:22:006802 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
  6. 20200330:20:55:22:006802 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
  7. 20200330:20:55:23:006802 gpstart:mdw:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode
  8. 20200330:20:55:23:006802 gpstart:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1
  9.  Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master/gpseg-1 -l /opt/greenplum/data/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -c gp_role=utility " start'
  10. rc=1, stdout='waiting for server to start.... stopped waiting
  11. ', stderr='pg_ctl: could not start server
  12. Examine the log output.

错误问题描述

1 被客户不小心强行关闭数据库
2 重启之后启动数据报找不到进程

修改思路

排查masert节点最新日志

查找结果

在opt/greenplum/data/master/gpseg-1/ gpdb-2020-03-30_205337.csv
文件中有报错信息

  1. 2020-03-30 20:53:37.693725 CST,,,p20910,th488097920,,,,0,,,seg-1,,,,,"LOG","F0000","specifying both host name and CIDR mask is invalid: "" ::0/0""",,,,,"line 98 of configuration file ""/opt/greenplum/data/master/gpseg-1/pg_hba.conf""",,0,,"hba.c",1043,
  2. 2020-03-30 20:53:37.694153 CST,,,p20910,th488097920,,,,0,,,seg-1,,,,,"FATAL","F0000","could not load pg_hba.conf",,,,,,,0,,"postmaster.c",1460,

修改结果

根据报错信息，注释掉报错的那一行
image.png

然后启动数据库成功