网友通过本文主要向大家介绍了greenplum,greenplum官网,greenplum数据库,greenplum教程,greenplum安装等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
Greenplum 由于备master节点故障导致gp无法启动处理
前提环境：1、已经配置了masterstandby节点，如果masterstandby故障是不会影响Greenplum正常运行， 但是如果此时关闭master主节点则无法启法需要将原masterstandby节点移除。
1、启动master节点失败
[gpadmin@mdw ~]$ gpstart
20170329:02:30:38:025343 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args:
20170329:02:30:38:025343 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20170329:02:30:38:025343 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.0.0-alpha.0+dev.266.g923109b build dev'
20170329:02:30:38:025343 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301703191'
20170329:02:30:38:025343 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20170329:02:30:39:025343 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20170329:02:30:39:025343 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170329:02:30:39:025343 gpstart:mdw:gpadmin-[INFO]:-Setting new master era
20170329:02:30:39:025343 gpstart:mdw:gpadmin-[INFO]:-Master Started...
20170329:02:30:40:025343 gpstart:mdw:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 2
Command was: 'ssh -o 'StrictHostKeyChecking no' mdw02 ". /usr/local/gpdb-5.0.0/greenplum_path.sh; $GPHOME/bin/pg_controldata /gpmaster50/gpseg-1"'
rc=2, stdout='', stderr='pg_controldata: could not open file "/gpmaster50/gpseg-1/global/pg_control" for reading: No such file or directory
'
2、移除问题mdw02
[gpadmin@mdw ~]$ gpinitstandby -r mdw02
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Warm master standby removal parameters
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname = mdw
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory = /gpmaster50/gpseg-1
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port = 5432
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname = mdw02
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port = 5432
20170329:02:30:53:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /gpmaster50/gpseg-1
Do you want to continue with deleting the standby master? Yy|Nn (default=N):
> y
20170329:02:30:56:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Removing standby master from catalog...
20170329:02:30:56:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully.
20170329:02:30:56:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Removing filespace directories on standby master...
20170329:02:30:56:025380 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully removed standby master
3、停止master节点
[gpadmin@mdw ~]$ gpstop
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args:
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.0.0-alpha.0+dev.266.g923109b build dev'
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:---------------------------------------------
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Master instance parameters
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:---------------------------------------------
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Master Greenplum instance process active PID = 25353
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Database = template1
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Master port = 5432
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Master directory = /gpmaster50/gpseg-1
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Shutdown mode = smart
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Timeout = 120
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Shutdown Master standby host = Off
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:---------------------------------------------
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:-Segment instances that will be shutdown:
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:---------------------------------------------
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- Host Datadir Port Status
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw01 /gpdata50/gpseg0 40000 u
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw02 /gpdata/mirror50/gpseg0 41000 u
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw02 /gpdata50/gpseg1 40000 u
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw03 /gpdata/mirror50/gpseg1 41000 u
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw03 /gpdata50/gpseg2 40000 u
20170329:02:31:02:025413 gpstop:mdw:gpadmin-[INFO]:- sdw01 /gpdata/mirror50/gpseg2 41000 u
Continue with Greenplum instance shutdown Yy|Nn (default=N):
> y
20170329:02:31:04:025413 gpstop:mdw:gpadmin-[INFO]:-There are 0 connections to the database
20170329:02:31:04:025413 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20170329:02:31:04:025413 gpstop:mdw:gpadmin-[INFO]:-Master host=mdw
20170329:02:31:04:025413 gpstop:mdw:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=smart
20170329:02:31:04:025413 gpstop:mdw:gpadmin-[INFO]:-Master segment instance directory=/gpmaster50/gpseg-1
20170329:02:31:05:025413 gpstop:mdw:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20170329:02:31:05:025413 gpstop:mdw:gpadmin-[INFO]:-Terminating processes for segment /gpmaster50/gpseg-1
20170329:02:31:05:025413 gpstop:mdw:gpadmin-[INFO]:-No standby master host configured
20170329:02:31:05:025413 gpstop:mdw:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait...
20170329:02:31:05:025413 gpstop:mdw:gpadmin-[INFO]:-0.00% of jobs completed
20170329:02:31:15:025413 gpstop:mdw:gpadmin-[INFO]:-100.00% of jobs completed
20170329:02:31:15:025413 gpstop:mdw:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait...
20170329:02:31:15:025413 gpstop:mdw:gpadmin-[INFO]:-0.00% of jobs completed
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-100.00% of jobs completed
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:- Segments stopped successfully = 6
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:- Segments with errors during stop = 0
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-----------------------------------------------------
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-Successfully shutdown 6 of 6 segment instances
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20170329:02:31:25:025413 gpstop:mdw:gpadmin-[INFO]:-C