Pivotal Knowledge Base

Follow

How to Recover a Pivotal Greenplum System when the Master Host is Rebooted

Environment

  • Pivotal Greenplum 4.3.x
  • Operating System- Red Hat Enterprise Linux 6.x

Cause

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

Procedure

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 article, How to run gpcheckcat on Pivotal Greenplum database to run a full gpcheckcat

 

Comments

Powered by Zendesk