Check segments that are currently resyncing

Post date: Oct 09, 2014 9:41:5 PM

Run SQL

select * from gp_segment_configuration where mode = 'r';

This implies that the segment is in the process of getting resynched. If the state does not change from 'r' to 's' then check the pg_log from the primary and mirror of the impacted 

segments for errors.