Check segments that are currently in change tracking mode

Post date: Oct 09, 2014 9:38:14 PM


select * from gp_segment_configuration where mode = 'c';

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