Pivotal Knowledge Base

Follow

How to recover a Pivotal Greenplum system when the master host is rebooted

Environment 

 

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x

Symptom

If the master is rebooted while the GPDB cluster is up, this will leave all segment instances up and running while the master instance is down.

Resolution

The following process was followed:

  1. gpstart -m  (start the master instance only)
  2. gpstop -M fast -a (once the master instance has started, shut down the whole cluster for a clean startup)
  3. gpssh -h hostfile ' ps -ef |grep post'  (ensure that no orphan process left at all hosts)
  4. gpstart -a (start the database again)
  5. Follow the directions in the KB article listed below to run a full gpcheckcat:

Comments

Powered by Zendesk