How to check the greenplum state

The gadget spec URL could not be found
Note:Checking Greenplum state
The gadget spec URL could not be found

1. Check system status,  use command: gpstate
[gpadmin@sachi gpdba]$ gpstate
20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args:
20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:51:41:001021 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'
20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:51:41:001021 gpstate:sachi:gpadmin-[INFO]:-Gathering data from segments...
..
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-Greenplum instance status summary
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Master instance = Active
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Master standby = No master standby configured
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total segment instance count from metadata = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Primary Segment Status
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segments = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segment valid (at master) = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total primary segment failures (at master) = 0
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid files missing = 0
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid files found = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid PIDs missing = 0
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of postmaster.pid PIDs found = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of /tmp lock files missing = 0
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number of /tmp lock files found = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number postmaster processes missing = 0
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Total number postmaster processes found = 2
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Mirror Segment Status
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:- Mirrors not configured on this array
20150117:14:51:43:001021 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found
 
2. Show complete system configuration and status, use command: gpstate -s
[gpadmin@sachi gpdba]$ gpstate -s
20150117:14:52:40:001154 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -s
20150117:14:52:40:001154 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:52:40:001154 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'
20150117:14:52:40:001154 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:52:40:001154 gpstate:sachi:gpadmin-[INFO]:-Gathering data from segments...
..
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:--Master Configuration & Status
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master host = sachi
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master postgres process ID = 12286
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master data directory = /home/gpmaster/gpsne-1
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master port = 5432
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master current role = dispatch
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Greenplum initsystem version = 4.2.2.4 build 1 Community Edition
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Greenplum current 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
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Postgres version = 8.2.15
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Master standby = No master standby configured
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-Segment Instance Status Report
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Segment Info
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Hostname = sachi
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Address = sachi
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Datadir = /disk1/gpdata1/gpsne0
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Port = 40000
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Status
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- PID = 12257
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Configuration reports status as = Up
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Database status = Up
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:-----------------------------------------------------
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Segment Info
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Hostname = sachi
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Address = sachi
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Datadir = /disk2/gpdata2/gpsne1
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Port = 40001
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Status
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- PID = 12258
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Configuration reports status as = Up
20150117:14:52:42:001154 gpstate:sachi:gpadmin-[INFO]:- Database status = Up
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found
 
3. To show orts used by system,  use command: gpstate -p
[gpadmin@sachi gpdba]$ gpstate -p
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -p
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:54:24:001423 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'
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:--Master segment instance /home/gpmaster/gpsne-1 port = 5432
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:--Segment instance port assignments
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:-----------------------------------
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- Host Datadir Port
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- sachi /disk1/gpdata1/gpsne0 40000
20150117:14:54:24:001423 gpstate:sachi:gpadmin-[INFO]:- sachi /disk2/gpdata2/gpsne1 40001
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found
 
4. To show segment mirror configuration, use command: gpstate -m
[gpadmin@sachi gpdba]$ gpstate -m
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -m
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:55:45:001489 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'
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:--------------------------------------------------------------
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:-physical mirroring not used
20150117:14:55:45:001489 gpstate:sachi:gpadmin-[WARNING]:--------------------------------------------------------------
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found
 
5. Check primary to mirror mapping,  use command: gpstate -c
[gpadmin@sachi gpdba]$ gpstate -c
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -c
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:56:57:001555 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'
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:--------------------------------------------------------------
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:--Primary list [physical mirroring not used]
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:--------------------------------------------------------------
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:- Primary Datadir Port
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:- sachi /disk1/gpdata1/gpsne0 40000
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:- sachi /disk2/gpdata2/gpsne1 40001
20150117:14:56:57:001555 gpstate:sachi:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found
6. Show details on primary/mirror segment pairs that have potential issue,use command: gpstate -e
[gpadmin@sachi gpdba]$ gpstate -e
20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -e
20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:58:34:001652 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'
20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:58:34:001652 gpstate:sachi:gpadmin-[INFO]:-Physical mirroring is not configured
[gpadmin@sachi gpdba]$
7. To get Greenplum database version details, use command: gpstate -i
[gpadmin@sachi gpdba]$ gpstate -i
20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Starting gpstate with args: -i
20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.2.4 build 1 Community Edition'
20150117:14:59:40:001725 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'
20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Obtaining Segment details from master...
20150117:14:59:40:001725 gpstate:sachi:gpadmin-[INFO]:-Loading version information
..
20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- Host Datadir Port Version
20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /home/gpmaster/gpsne-1 5432 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
20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /disk1/gpdata1/gpsne0 40000 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
20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:- sachi /disk2/gpdata2/gpsne1 40001 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
20150117:14:59:42:001725 gpstate:sachi:gpadmin-[INFO]:-All segments are running the same software version
[gpadmin@sachi gpdba]$
The gadget spec URL could not be found

The gadget spec URL could not be found

The gadget spec URL could not be found

The gadget spec URL could not be found

The gadget spec URL could not be found


Comments