Upgrade Ver 4.3.x from 4.2.x

来源:互联网 发布:飞鹰网络电视破解版 编辑:程序博客网 时间:2024/05/01 09:00
级到遇到个小问题,解决细节记录如下。
[gpadmin@wx60 ~]$ gpmigrator /usr/local/greenplum-db-4.2.7.2 /usr/local/greenplum-db-4.3.3.120141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Beginning upgrade20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking configuration20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-gpmigrator version 4.3.3.1 build 120141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Python version 2.6.2 final 020141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Operating System: Linux 2.6.18-348.el520141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking version compatibility20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Source Version: (Greenplum Database) 4.2.7.2 build 120141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Target Version: (Greenplum Database) 4.3.3.1 build 120141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Source Catalog version number: 20110921020141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Target Catalog version number: 20131015020141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Data Catalog version number: 20110921020141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Versions are compatible20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Found previous upgrade20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-... State not resumable, restarting upgrade20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running20141020:10:29:05:005944 gpmigrator:wx60:gpadmin-[INFO]:-Starting old Greenplum postmaster20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Extracting configuration information20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking that all segments are valid20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Creating list of databases20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking gpmigrator user20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating hosts20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating indexes20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Validating database encoding20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Configuration acquired20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[WARNING]:-/data/gp/master/gpmigrator : File exists20141020:10:29:14:005944 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories20141020:10:29:15:005944 gpmigrator:wx60:gpadmin-[INFO]:-Creating temporary directories20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Segment binary version20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking GUCs20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Free Space20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-Checking Catalog20141020:10:29:17:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking template120141020:10:30:44:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking postgres20141020:10:32:12:005944 gpmigrator:wx60:gpadmin-[INFO]:-... Checking gtlions20141020:10:33:45:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-Fatal error occurred - Recovering20141020:10:33:45:005944 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down old Greenplum postmaster20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running20141020: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 details20141020:10:33:50:005944 gpmigrator:wx60:gpadmin-[CRITICAL]:-***************************************[gpadmin@wx60 ~]$ more /data/gp/master/gpmigrator/gpcheckcat_gtlions.logConnected as user 'gpadmin' to database 'gtlions', port '5432', gpdb version '4.2'-------------------------------------------------------------------Performing test 'duplicate'Total runtime for this test: 0:00:15.68Performing test 'missing_extraneous'Total runtime for this test: 0:00:19.76Performing test 'inconsistent'Total runtime for this test: 0:00:49.11Performing test 'foreign_key'Total runtime for this test: 0:00:05.20Performing test 'acl'Total runtime for this test: 0:00:00.32Performing test 'persistent'Total runtime for this test: 0:00:00.19Performing test 'pgclass'Total runtime for this test: 0:00:00.01Performing test 'namespace'Total runtime for this test: 0:00:00.06Performing test 'distribution_policy'Total runtime for this test: 0:00:00.01Performing test 'dependency'Total runtime for this test: 0:00:00.30Performing test 'owner'Total runtime for this test: 0:00:00.25Performing test 'part_integrity'Total runtime for this test: 0:00:00.07Performing test 'part_constraint'Total runtime for this test: 0:00:00.13Performing 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.12SUMMARY REPORT===================================================================Total runtime for 14 test(s): 0:01:32.28Failed test(s) that are not reported here: namespaceSee /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/bashcd $(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.sqlDROP SCHEMA IF EXISTS "pg_temp_54" CASCADE;[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ sh runsql.shDropping 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 acceptingconnections on Unix domain socket "/tmp/.s.PGSQL.5432"?[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ sh runsql.shDropping temporary schemas[gpadmin@wx60 ~]$ exitlogout[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 -a20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a20141020: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 mode20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:44:15:003808 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:44:16:003808 gpstart:wx60:gpadmin-[INFO]:-Database successfully started[gpadmin@wx60 ~]$ ll总计 20drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:44 gpdrwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:28 gpAdminLogsdrwxrwxr-x 2 gpadmin gpadmin 4096 10-20 10:24 gpcheckcat.repair.2014-10-20.10.22.34drwxrwxr-x 3 gpadmin gpadmin 4096 10-20 10:42 gpcheckcat.repair.2014-10-20.10.32.12drwxrwxr-x 2 gpadmin gpadmin 4096 08-29 09:45 gpconfigs[gpadmin@wx60 ~]$ sh gpcheckcat.repair.2014-10-20.10.32.12/runsql.shDropping 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/bashcd $(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, skippingDROP SCHEMA[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ vacuumdb gtlions[gpadmin@wx60 gpcheckcat.repair.2014-10-20.10.32.12]$ exitlogout[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.120141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Beginning upgrade20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking configuration20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-gpmigrator version 4.3.3.1 build 120141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Python version 2.6.2 final 020141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Operating System: Linux 2.6.18-348.el520141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking version compatibility20141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Source Version: (Greenplum Database) 4.2.7.2 build 120141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Target Version: (Greenplum Database) 4.3.3.1 build 120141020:10:47:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-Source Catalog version number: 20110921020141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Target Catalog version number: 20131015020141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Data Catalog version number: 20110921020141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Versions are compatible20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Found previous upgrade20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-... State not resumable, restarting upgrade20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Extracting configuration information20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking that all segments are valid20141020:10:47:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-Creating list of databases20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking gpmigrator user20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating hosts20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating indexes20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Validating database encoding20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Configuration acquired20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[WARNING]:-/data/gp/master/gpmigrator : File exists20141020:10:47:51:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories20141020:10:47:52:004496 gpmigrator:wx60:gpadmin-[INFO]:-Creating temporary directories20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Segment binary version20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking GUCs20141020:10:47:54:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Free Space20141020:10:47:55:004496 gpmigrator:wx60:gpadmin-[INFO]:-Checking Catalog20141020:10:47:55:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking template120141020:10:49:22:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking postgres20141020:10:50:49:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Checking gtlions20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-Locking database20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Creating upgrade user20141020:10:52:24:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Creating pg_hba.conf20141020:10:52:25:004496 gpmigrator:wx60:gpadmin-[INFO]:-... Syncing20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Database Locked20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Generating config files20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Configuration files generated20141020:10:52:27:004496 gpmigrator:wx60:gpadmin-[INFO]:-Extracting list of catalog files20141020:10:52:28:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down old Greenplum postmaster20141020:10:52:33:004496 gpmigrator:wx60:gpadmin-[INFO]:-Looking for highest OID20141020:10:52:34:004496 gpmigrator:wx60:gpadmin-[INFO]:-Building skeleton cluster20141020:10:53:16:004496 gpmigrator:wx60:gpadmin-[INFO]:-Modifying catalog version of skeleton cluster20141020:10:53:17:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adjusting configuration20141020:10:53:18:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode20141020:10:53:21:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster20141020:10:53:23:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode20141020:10:53:31:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster20141020:10:53:37:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode20141020:10:53:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-Performing catalog transformation20141020:10:53:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-... template120141020:10:53:46:004496 gpmigrator:wx60:gpadmin-[INFO]:-... template020141020:10:53:48:004496 gpmigrator:wx60:gpadmin-[INFO]:-... postgres20141020:10:53:50:004496 gpmigrator:wx60:gpadmin-[INFO]:-... gtlions20141020:10:53:52:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Postmaster not running20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:---------------------------------------------------20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Stage 1 complete20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:---------------------------------------------------20141020:10:53:57:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adding gp_dbid file20141020:10:53:58:004496 gpmigrator:wx60:gpadmin-[INFO]:-Linking backup20141020:10:53:58:004496 gpmigrator:wx60:gpadmin-[INFO]:-... This may take a while20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Linking upgrade20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-... This may take a while20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Adjusting configuration20141020:10:54:03:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in utility mode20141020:10:54:05:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster20141020:10:54:07:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster in upgrade mode20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-***************************************20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-Warnings generated starting cluster20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-Check /home/gpadmin/gpAdminLogs/gpstart_20141020.log for detailed warnings20141020:10:54:14:004496 gpmigrator:wx60:gpadmin-[WARNING]:-***************************************20141020:10:54:15:004496 gpmigrator:wx60:gpadmin-[INFO]:-Shutting down new Greenplum postmaster20141020:10:54:20:004496 gpmigrator:wx60:gpadmin-[INFO]:-Starting new Greenplum postmaster20141020:10:54:28:004496 gpmigrator:wx60:gpadmin-[INFO]:-Installing gp_toolkit20141020:10:54:30:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing upgrade user20141020:10:54:31:004496 gpmigrator:wx60:gpadmin-[INFO]:-Unlocking database20141020:10:54:44:004496 gpmigrator:wx60:gpadmin-[INFO]:-Removing temporary directories20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-Upgrade Successful20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-Please consult release notes for post-upgrade20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:-instructions to complete environment configuration20141020:10:54:45:004496 gpmigrator:wx60:gpadmin-[INFO]:----------------------------------------------------[gpadmin@wx60 ~]$ more /home/gpadmin/gpAdminLogs/gpstart_20141020.log20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a20141020: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 required20141020:09:36:53:002934 gpstart:wx60:gpadmin-[INFO]:-Commencing recovery startup checks20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-No socket connection or lock file in /tmp found for port=543220141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-No Master instance process, entering recovery startup mode20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-Clearing Master instance pid file20141020:09:36:54:002934 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode20141020:09:36:56:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:09:36:57:002934 gpstart:wx60:gpadmin-[INFO]:-Commencing forced instance shutdown20141020:09:36:58:002934 gpstart:wx60:gpadmin-[INFO]:-Starting Master instance in admin mode20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:09:36:59:002934 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:09:37:05:002934 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:09:37:07:002934 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:09:37:07:002934 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:19:24:007210 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:19:25:007210 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:19:29:007210 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:19:30:007210 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:19:30:007210 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:28:50:005936 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a20141020: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 binaries20141020:10:28:51:005936 gpstart:wx60:gpadmin-[ERROR]:-gpstart error: Catalog Versions are incompatible20141020:10:29:06:005972 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:29:08:005972 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:29:13:005972 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:29:14:005972 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:29:14:005972 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:37:28:004720 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:37:29:004720 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:37:34:004720 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:37:35:004720 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:37:35:004720 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:44:09:003808 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a20141020: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 mode20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:44:11:003808 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:44:14:003808 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:44:15:003808 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:44:16:003808 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:53:18:003895 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -U upgrade -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:53:21:003895 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020: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/gpAdminLogs20141020: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 mode20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:53:25:003948 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:53:29:003948 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Testing connection as user gpadmin20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...20141020:10:53:31:003948 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:53:37:004338 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -U upgrade -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:53:38:004338 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:53:43:004338 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Testing connection as user gpadmin20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...20141020:10:53:44:004338 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:54:04:007506 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -m -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:54:05:007506 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020: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/gpAdminLogs20141020: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 mode20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:54:09:007552 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:54:13:007552 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:54:14:007552 gpstart:wx60:gpadmin-[WARNING]:-Command pg_ctl reports Master /data/gp/master/gpseg-1 on port 5432 not running20141020:10:54:14:007552 gpstart:wx60:gpadmin-[WARNING]:-Master could not be started20141020:10:54:20:007854 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs20141020: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 mode20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:54:22:007854 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:54:26:007854 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:54:27:007854 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020:10:54:28:007854 gpstart:wx60:gpadmin-[INFO]:-No standby master configured. skipping...20141020:10:54:28:007854 gpstart:wx60:gpadmin-[INFO]:-Database successfully started20141020:10:54:37:009173 gpstart:wx60:gpadmin-[INFO]:-Starting gpstart with args: -a -d /data/gp/master/gpseg-120141020: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 mode20141020:10:54:38:009173 gpstart:wx60:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information20141020: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 era20141020:10:54:39:009173 gpstart:wx60:gpadmin-[INFO]:-Master Started...20141020:10:54:39:009173 gpstart:wx60:gpadmin-[INFO]:-Shutting down master20141020: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 = 220141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:- Failed segment starts = 020141020:10:54:42:009173 gpstart:wx60:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020141020: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 instances20141020: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-120141020:10:54:43:009173 gpstart:wx60:gpadmin-[INFO]:-Command pg_ctl reports Master wx60 instance active20141020: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-
1 0
原创粉丝点击