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

Products

• VMware Tanzu Greenplum
• Pivotal Data Suite Non Production Edition
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite
• Greenplum

Issue/Introduction

This article describes how to recover a Greenplum System when the master host is rebooted.

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.

 

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

 

 

Additional Information