gpstart error: Do not have enough valid segments to start the array.

[sudhakar tekkali]

 

[Kushal Choubay]

Hi Sudhakar,

 

 

This can happen when both primary & mirror of one or more content are not available during database start. You can identify from gpstart logs about the content having issues and then check pg_logs for that content to get the error message. To identify the content refer message "No segment started for content x" in gpstart logs.

[sudhakar tekkali]

Thanks Kushal, I followed your steps and verify it. I got error message "PG_CTL failed". For fixing of that error, I followed below steps

- clean the /data1 and /data2 for all the segments mdw, sdw1, sdw2 and sdw3

- Initialization of configuration file using the command: gpinitsystem -c gpinitsystem_config -h hosts-seg

 

Let me know Is it good practice ?

[Kushal Choubay]

This can be tried if you are initializing the cluster but would not be a good practice for clusters already in production. The procedure used will wipe out all data.

 

Ideally log messages should have been analyzed to resolve the root cause .