|
]:-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 ~ |