数据库

 首页 > 数据库 > MySql > Upgrade Ver 4.3.x from 4.2.x

Upgrade Ver 4.3.x from 4.2.x

分享到:
【字体:
导读:
         摘要:级到遇到个小问题,解决细节记录如下。[gpadmin@wx60 ~]$ gpmigrator usrlocalgreenplum-db-4.2.7.2 usrlocalgreenplum-db-4.3.3.120141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:...

Upgrade Ver 4.3.x from 4.2.x
级到遇到个小问题,解决细节记录如下。
[gpadmin@wx60 ~]$ gpmigrator /usr/local/greenplum-db-4.2.7.2 /usr/local/greenplum-db-4.3.3.1
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Beginning upgrade
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking configuration
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-gpmigrator version 4.3.3.1 build 1
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Python version 2.6.2 final 0
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Operating System: Linux 2.6.18-348.el5
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking version compatibility
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Source Version: (Greenplum Database) 4.2.7.2 build 1
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Target Version: (Greenplum Database) 4.3.3.1 build 1
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Source Catalog version number: 201109210
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Target Catalog version number: 201310150
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Data Catalog version number: 201109210
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Versions are compatible
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Found previous upgrade
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-... State not resumable, restarting upgrade
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running
20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Starting old Greenplum postmaster
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Extracting configuration information
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking that all segments are valid
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Creating list of databases
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking gpmigrator user
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating hosts
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating indexes
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating database encoding
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Configuration acquired
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[WARNING]:-/data/gp/master/gpmigrator : File exists
20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories
20141020:10:29:15:005944 gpmigrator:wx60:gpadmin-[INFO]:-Creating temporary directories
20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Segment binary version
20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking GUCs
20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Free Space
20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Catalog
20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking template1
20141020:10:30:44:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking postgres
20141020:10:32:12:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking gtlions
20141020:10:33:45:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-Fatal error occurred - Recovering
20141020:10:33:45:005944 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down old Greenplum postmaster
20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database
20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running
20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-***************************************
20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-Catalog Check Failed - see /data/gp/master/gpmigrator/gpcheckcat_gtlions.log for details
20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-***************************************
[gpadmin@wx60 ~]$ more /data/gp/master/gpmigrator/gpcheckcat_gtlions.log

Connected as user 'gpadmin' to database 'gtlions', port '5432', gpdb version '4.2'
-------------------------------------------------------------------
Performing test 'duplicate'
Total runtime for this test: 0:00:15.68
Performing test 'missing_extraneous'
Total runtime for this test: 0:00:19.76
Performing test 'inconsistent'
Total runtime for this test: 0:00:49.11
Performing test 'foreign_key'
Total runtime for this test: 0:00:05.20
Performing test 'acl'
Total runtime for this test: 0:00:00.32
Performing test 'persistent'
Total runtime for this test: 0:00:00.19
Performing test 'pgclass'
Total runtime for this test: 0:00:00.01
Performing test 'namespace'
Total runtime for this test: 0:00:00.06
Performing test 'distribution_policy'
Total runtime for this test: 0:00:00.01
Performing test 'dependency'
Total runtime for this test: 0:00:00.30
Performing test 'owner'
Total runtime for this test: 0:00:00.25
Performing test 'part_integrity'
Total runtime for this test: 0:00:00.07
Performing test 'part_constraint'
Total runtime for this test: 0:00:00.13
Performing test 'duplicate_persistent'
Total runtime for this test: 0:00:01.12

[INFO]: repair scripts generated in directory gpcheckcat.repair.2014-10-20.10.32.12

SUMMARY REPORT
===================================================================
Total runtime for 14 test(s): 0:01:32.28
Failed test(s) that are not reported here: namespace
See /home/gpadmin/gpAdminLogs/gpcheckcat_20141020.log for detail
[gpadmin@wx60 ~]$ cd gpcheckcat.repair.2014-10-20.10.32.12
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ cat runsql.sh
#!/bin/bash
cd $(dirname $0)
echo "Dropping temporary schemas"
psql -X -a -h wx60 -p 5432 -f fixnamespace.sql "gtlions" > fixnamespace.sql.out 2>&1
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ more fixnamespace.sql
DROP SCHEMA IF EXISTS "pg_temp_54" CASCADE;
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ sh runsql.sh
Dropping temporary schemas
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ psql "gtlions"
psql: could not connect to server: 没有那个文件或目录
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ sh runsql.sh
Dropping temporary schemas
[gpadmin@wx60 ~]$ exit
logout
[root@wx60 ~]# rm -rf /usr/local/greenplum-db
[root@wx60 ~]# ln -s /usr/local/greenplum-db-4.2.7.2 /usr/local/greenplum-db
[root@wx60 ~]# chown -R gpadmin:gpadmin /usr/local/greenplum-db*
[root@wx60 ~]# su - gpadmin
[gpadmin@wx60 ~]$ gpstart -a
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
..
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:44:15:003808 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:44:16:003808 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
[gpadmin@wx60 ~]$ ll
总计 20
drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:44 gp
drwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:28 gpAdminLogs
drwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:24 gpcheckcat.repair.2014-10-20.10.22.34
drwxrwxr-x 3 gpadmin gpadmin 4096 10-20 10:42 gpcheckcat.repair.2014-10-20.10.32.12
drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:45 gpconfigs
[gpadmin@wx60 ~]$ sh gpcheckcat.repair.2014-10-20.10.32.12/runsql.sh
Dropping temporary schemas
[gpadmin@wx60 ~]$ cd gpcheckcat.repair.2014-10-20.10.32.12
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ cat runsql.sh
#!/bin/bash
cd $(dirname $0)
echo "Dropping temporary schemas"
psql -X -a -h wx60 -p 5432 -f fixnamespace.sql "gtlions" > fixnamespace.sql.out 2>&1
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ psql -X -a -h wx60 -p 5432 -f fixnamespace.sql "gtlions"
DROP SCHEMA IF EXISTS "pg_temp_54" CASCADE;
psql:fixnamespace.sql:1: NOTICE: schema "pg_temp_54" does not exist, skipping
DROP SCHEMA
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ vacuumdb gtlions
[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ exit
logout
[root@wx60 ~]# rm -rf /usr/local/greenplum-db
[root@wx60 ~]# ln -s /usr/local/greenplum-db-4.3.3.1 /usr/local/greenplum-db
[root@wx60 ~]# chown -R gpadmin:gpadmin /usr/local/greenplum-db*
[root@wx60 ~]# su - gpadmin
[gpadmin@wx60 ~]$ gpmigrator /usr/local/greenplum-db-4.2.7.2 /usr/local/greenplum-db-4.3.3.1
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Beginning upgrade
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking configuration
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-gpmigrator version 4.3.3.1 build 1
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Python version 2.6.2 final 0
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Operating System: Linux 2.6.18-348.el5
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking version compatibility
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Source Version: (Greenplum Database) 4.2.7.2 build 1
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Target Version: (Greenplum Database) 4.3.3.1 build 1
20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Source Catalog version number: 201109210
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Target Catalog version number: 201310150
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Data Catalog version number: 201109210
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Versions are compatible
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Found previous upgrade
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-... State not resumable, restarting upgrade
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Extracting configuration information
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking that all segments are valid
20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Creating list of databases
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking gpmigrator user
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating hosts
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating indexes
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating database encoding
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Configuration acquired
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[WARNING]:-/data/gp/master/gpmigrator : File exists
20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories
20141020:10:47:52:004496 gpmigrator:wx60:gpadmin-[INFO]:-Creating temporary directories
20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Segment binary version
20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking GUCs
20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Free Space
20141020:10:47:55:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Catalog
20141020:10:47:55:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking template1
20141020:10:49:22:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking postgres
20141020:10:50:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking gtlions
20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-Locking database
20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Creating upgrade user
20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Creating pg_hba.conf
20141020:10:52:25:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Syncing
20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Database Locked
20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Generating config files
20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Configuration files generated
20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Extracting list of catalog files
20141020:10:52:28:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down old Greenplum postmaster
20141020:10:52:33:004496 gpmigrator:wx60:gpadmin-[INFO]:-Looking for highest OID
20141020:10:52:34:004496 gpmigrator:wx60:gpadmin-[INFO]:-Building skeleton cluster
20141020:10:53:16:004496 gpmigrator:wx60:gpadmin-[INFO]:-Modifying catalog version of skeleton cluster
20141020:10:53:17:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adjusting configuration
20141020:10:53:18:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode
20141020:10:53:21:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster
20141020:10:53:23:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode
20141020:10:53:31:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster
20141020:10:53:37:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode
20141020:10:53:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-Performing catalog transformation
20141020:10:53:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-... template1
20141020:10:53:46:004496 gpmigrator:wx60:gpadmin-[INFO]:-... template0
20141020:10:53:48:004496 gpmigrator:wx60:gpadmin-[INFO]:-... postgres
20141020:10:53:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-... gtlions
20141020:10:53:52:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:---------------------------------------------------
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Stage 1 complete
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:---------------------------------------------------
20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adding gp_dbid file
20141020:10:53:58:004496 gpmigrator:wx60:gpadmin-[INFO]:-Linking backup
20141020:10:53:58:004496 gpmigrator:wx60:gpadmin-[INFO]:-... This may take a while
20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Linking upgrade
20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-... This may take a while
20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adjusting configuration
20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode
20141020:10:54:05:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster
20141020:10:54:07:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode
20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-***************************************
20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-Warnings generated starting cluster
20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-Check /home/gpadmin/gpAdminLogs/gpstart_20141020.log for detailed warnings
20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-***************************************
20141020:10:54:15:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster
20141020:10:54:20:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster
20141020:10:54:28:004496 gpmigrator:wx60:gpadmin-[INFO]:-Installing gp_toolkit
20141020:10:54:30:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing upgrade user
20141020:10:54:31:004496 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database
20141020:10:54:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-Upgrade Successful
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-Please consult release notes for post-upgrade
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-instructions to complete environment configuration
20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------
[gpadmin@wx60 ~]$ more /home/gpadmin/gpAdminLogs/gpstart_20141020.log
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[WARNING]:-postmaster.pid file exists on Master, checking if recovery startup required
20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Commencing recovery startup checks
20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-No socket connection or lock file in /tmp found for port=5432
20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-No Master instance process, entering recovery startup mode
20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-Clearing Master instance pid file
20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:09:36:56:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:09:36:56:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:09:36:57:002934 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:09:36:57:002934 gpstart:wx60:gpadmin-[INFO]:-Commencing forced instance shutdown
20141020:09:36:58:002934 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:09:37:01:002934 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:09:37:01:002934 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:09:37:07:002934 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:09:37:07:002934 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs
20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:19:26:007210 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:19:27:007210 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:19:30:007210 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:19:30:007210 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:28:50:005936 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a
20141020:10:28:50:005936 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:28:50:005936 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:28:51:005936 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:28:51:005936 gpstart:wx60:gpadmin-[INFO]:-MASTER_DIRECTORY Catalog Version: '201109210'
20141020:10:28:51:005936 gpstart:wx60:gpadmin-[INFO]:-Catalog Version of master directory incompatible with binaries
20141020:10:28:51:005936 gpstart:wx60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible
20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs
20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:29:09:005972 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:29:10:005972 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:29:14:005972 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:29:14:005972 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs
20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:37:31:004720 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:37:31:004720 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:37:35:004720 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:37:35:004720 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.7.2 build 1'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20141020:10:44:10:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:44:12:003808 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:44:15:003808 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:44:16:003808 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:53:18:003895 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -U upgrade -l /home/gpadmin/gpAdminLogs
20141020:10:53:18:003895 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:53:18:003895 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:53:18:003895 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:53:19:003895 gpstart:wx60:gpadmin-[INFO]:-Master-only start requested for management utilities.
20141020:10:53:19:003895 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:53:21:003895 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:53:21:003895 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:53:21:003895 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:53:21:003895 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:53:23:003948 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs
20141020:10:53:23:003948 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:53:23:003948 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:53:23:003948 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:53:23:003948 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:53:26:003948 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpmigrator/upgrade/gpseg-1
20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Testing connection as user gpadmin
20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs
20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:53:40:004338 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpmigrator/upgrade/gpseg-1
20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Testing connection as user gpadmin
20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -l /home/gpadmin/gpAdminLogs
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Master-only start requested for management utilities.
20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:54:05:007506 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:54:05:007506 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:54:05:007506 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:54:05:007506 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:54:07:007552 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs
20141020:10:54:07:007552 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:54:07:007552 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:54:07:007552 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:54:07:007552 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:54:10:007552 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpmigrator/upgrade/gpseg-1
20141020:10:54:14:007552 gpstart:wx60:gpadmin-[WARNING]:-Command pg_ctl reports Master /data/gp/master/gpseg-1 on port 5432 not running
20141020:10:54:14:007552 gpstart:wx60:gpadmin-[WARNING]:-Master could not be started
20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs
20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:54:23:007854 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:54:27:007854 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:54:28:007854 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:54:28:007854 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -d /data/gp/master/gpseg-1
20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Gathering information and validating the environment...
20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.3.1 build 1'
20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'
20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode
20141020:10:54:38:009173 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20141020:10:54:38:009173 gpstart:wx60:gpadmin-[INFO]:-Obtaining Segment details from master...
20141020:10:54:39:009173 gpstart:wx60:gpadmin-[INFO]:-Setting new master era
20141020:10:54:39:009173 gpstart:wx60:gpadmin-[INFO]:-Master Started...
20141020:10:54:39:009173 gpstart:wx60:gpadmin-[INFO]:-Shutting down master
20141020:10:54:40:009173 gpstart:wx60:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-Process results...
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:- Successful segment starts = 2
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 0
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-Successfully started 2 of 2 segment instances
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-----------------------------------------------------
20141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance wx60 directory /data/gp/master/gpseg-1
20141020:10:54:43:009173 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active
20141020:10:54:43:009173 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...
20141020:10:54:43:009173 gpstart:wx60:gpadmin-[INFO]:-Database successfully started
[gpadmin@wx60 ~]$ psql -ac "select version();" "gtlions"
select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.15 (Greenplum Database 4.3.3.1 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 10 2014 14:31:57
(1 row)


-EOF- Upgrade Ver 4.3.x from 4.2.x
分享到:
【MongoDB】The description of index(一...
【MongoDB】The description of index(一)From this blog, we start to talk about the index in mongo Database, which is similar to the traditional database. Generally speaking, if the index need to be created in the traditional database, so does MongoDB.  In MongoDB ,the field '_id ' has bee...
Index statistics collected bug
Index statistics collected bugSQL执行引擎会从pg_stats、pg_class等相关系统字典表、视图获取生成最佳执行计划的数据,如果相关字典视图的数据不准确就没有办法生成良好的执行计划。 发现以下Bug一枚。 0. 插入数据之后,新创建的索引不会自动更新收集索引的pg_class.relpages\pg_class.reltuples信息; 1. 对一个表,当...
  •         php迷,一个php技术的分享社区,专属您自己的技术摘抄本、收藏夹。
  • 在这里……