Check segments that are currently in change tracking mode

posted Oct 9, 2014, 2:38 PM by Sachchida Ojha
RUN SQL

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
Comments