阅读背景:

Greenplum初始化数据库时出现gpadmin-[ERROR]:-gpstart error: Do not have enough valid segments to start the arr_double_happiness的博客

来源:互联网 

启动初始化greenplum数据库报错信息如下所示

[[email protected] gpAdminLogs]$ gpstart
20181018:01:09:27:043309 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: 
20181018:01:09:27:043309 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20181018:01:09:27:043309 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.11.0 build commit:6f447c24554134df0c1d473e63e0124e7ee6de6b'
20181018:01:09:27:043309 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20181018:01:09:27:043309 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode
20181018:01:09:28:043309 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20181018:01:09:28:043309 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20181018:01:09:28:043309 gpstart:mdw:gpadmin-[INFO]:-Setting new master era
20181018:01:09:28:043309 gpstart:mdw:gpadmin-[INFO]:-Master Started...
20181018:01:09:28:043309 gpstart:mdw:gpadmin-[INFO]:-Shutting down master
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:---------------------------
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Master instance parameters
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:---------------------------
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Database                 = template1
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Master Port              = 5432
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Master directory         = /home/gpadmin/masterdata/gpseg-1
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Timeout                  = 600 seconds
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Master standby           = Off 
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:---------------------------------------
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-Segment instances that will be started
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:---------------------------------------
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-   Host   Datadir                             Port
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-   mdw    /home/gpadmin/segmentdata1/gpseg0   33000
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-   mdw    /home/gpadmin/segmentdata2/gpseg1   33001
20181018:01:09:30:043309 gpstart:mdw:gpadmin-[INFO]:-   mdw    /home/gpadmin/segmentdata3/gpseg2   33002

Continue with Greenplum instance startup Yy|Nn (default=N):
> y
20181018:01:09:32:043309 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
. 
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-Process results...
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[ERROR]:-No segment started for content: 0.
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-dumping success segments: []
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-DBID:2  FAILED  host:'mdw' datadir:'/home/gpadmin/segmentdata1/gpseg0' with reason:'cmd had rc=255 completed=True halted=False
  stdout=''
  stderr='/etc/ssh/ssh_config: line 69: Bad configuration option: clientaliveinterval
/etc/ssh/ssh_config: line 70: Bad configuration option: clientalivecountmax
/etc/ssh/ssh_config: terminating, 2 bad configuration options
''
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-DBID:3  FAILED  host:'mdw' datadir:'/home/gpadmin/segmentdata2/gpseg1' with reason:'cmd had rc=255 completed=True halted=False
  stdout=''
  stderr='/etc/ssh/ssh_config: line 69: Bad configuration option: clientaliveinterval
/etc/ssh/ssh_config: line 70: Bad configuration option: clientalivecountmax
/etc/ssh/ssh_config: terminating, 2 bad configuration options
''
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-DBID:4  FAILED  host:'mdw' datadir:'/home/gpadmin/segmentdata3/gpseg2' with reason:'cmd had rc=255 completed=True halted=False
  stdout=''
  stderr='/etc/ssh/ssh_config: line 69: Bad configuration option: clientaliveinterval
/etc/ssh/ssh_config: line 70: Bad configuration option: clientalivecountmax
/etc/ssh/ssh_config: terminating, 2 bad configuration options
''
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------


20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-   Successful segment starts                                            = 0
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[WARNING]:-Failed segment starts                                                = 3   <<<<<<<<
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-Successfully started 0 of 3 segment instances <<<<<<<<
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[WARNING]:-Segment instance startup failures reported
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[WARNING]:-Failed start 3 of 3 segment instances <<<<<<<<
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[WARNING]:-Review /home/gpadmin/gpAdminLogs/gpstart_20181018.log
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------
20181018:01:09:33:043309 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
. 
20181018:01:09:34:043309 gpstart:mdw:gpadmin-[ERROR]:-gpstart error: Do not have enough valid segments to start the array. 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: