1. On the master, run the gpstate utility with the -e option to show segments with error conditions: $ gpstate -e 2. To get detailed information about a failed segment, check the gp_segment_configuration catalog table. For example: $ psql -c "SELECT * FROM gp_segment_configuration WHERE status='d';" [gpadmin@sachi gpsne-1]$ psql -d sachi psql (8.2.15) Type "help" for help. sachi=# SELECT * FROM gp_segment_configuration; dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port | san_mounts ------+---------+------+----------------+------+--------+-------+----------+---------+------------------+------------ 1 | -1 | p | p | s | u | 5432 | sachi | sachi | | 2 | 0 | p | p | s | u | 40000 | sachi | sachi | | 3 | 1 | p | p | s | u | 40001 | sachi | sachi | | (3 rows) sachi=# SELECT * FROM gp_segment_configuration WHERE status='d'; dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port | san_mounts ------+---------+------+----------------+------+--------+------+----------+---------+------------------+------------ (0 rows) sachi=# To show information about mirror segment instances, run: [gpadmin@sachi gpsne-1]$ gpstate -m 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -m 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition' 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:52:28' 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master... 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[WARNING]:-------------------------------------------------------------- 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[WARNING]:-physical mirroring not used 20131117:21:19:39:023443 gpstate:sachi:gpadmin-[WARNING]:-------------------------------------------------------------- |
|
|