Check if one or more Greenplum segments are down

posted Oct 9, 2014, 2:12 PM by Sachchida Ojha

select * from gp_segment_configuration where status <> 'u';

This query will return segments that are currently DOWN. If rows are more than 0 this should generate a warning/alert. Check to see if the host that the down segments are from, is responsive. If yes, check the pg_log for the primary and mirror of the down segments to find out the root cause of the segments going done. If no unexpected errors, then run gprecoverseg to bring the segments back online.