The gadget spec URL could not be found
Note:Checking Greenplum state The gadget spec URL could not be found [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 -s20150117: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 -p20150117: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 -m20150117: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 -e20150117: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 -i20150117: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 |