GreenPlum 创建数据库时报错 reason为空 不知道什么原因啊

[gpadmin@vm2 master_database]$ gpinitsystem -c /home/gpadmin/gp_init_config
。。。。。。。。。。。。。。
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Array host connect type    = Single hostname per node
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Master IP address [1]      = ::1
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Master IP address [2]      = 172.16.7.26
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Master IP address [3]      = fe80::acff:fe10:71a
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Standby Master             = Not Configured
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Primary segment #          = 1
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Total Database segments    = 2
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Trusted shell              = ssh
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Number segment hosts       = 2
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Mirroring config           = OFF
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:----------------------------------------
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Greenplum Primary Segment Configuration
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:----------------------------------------
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-vm3   /usr/local/dnt/svm/gpseg0       40000   2       0
20130105:09:23:37:031805 gpinitsystem:vm2:gpadmin-[INFO]:-vm4   /usr/local/dnt/svm/gpseg1       40000   3       1
Continue with Greenplum creation Yy/Nn>
y
20130105:09:23:41:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Building the Master instance database, please wait...
20130105:09:24:44:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Starting the Master in admin mode
20130105:09:25:05:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Commencing parallel build of primary segment instances
20130105:09:25:05:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...
..
20130105:09:25:05:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...
.....................................................................................................................................................
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:------------------------------------------------
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Parallel process exit status
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:------------------------------------------------
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Total processes marked as completed           = 2
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Total processes marked as killed              = 0
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Total processes marked as failed              = 0
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:------------------------------------------------
20130105:09:27:35:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Deleting distributed backout files
20130105:09:27:36:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Removing back out file
20130105:09:27:36:031805 gpinitsystem:vm2:gpadmin-[INFO]:-No errors generated from parallel processes
20130105:09:27:36:031805 gpinitsystem:vm2:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Starting gpstop with args: -a -i -m -d /usr/local/dnt/svm/master_database/gpseg-1
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Gathering information and validating the environment...
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Obtaining Segment details from master...
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.2.1.0 build 3 Community Edition'
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-There are 0 connections to the database
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Master host=vm2
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20130105:09:27:36:010461 gpstop:vm2:gpadmin-[INFO]:-Master segment instance directory=/usr/local/dnt/svm/master_database/gpseg-1
20130105:09:27:37:010544 gpstart:vm2:gpadmin-[INFO]:-Starting gpstart with args: -a -d /usr/local/dnt/svm/master_database/gpseg-1
20130105:09:27:37:010544 gpstart:vm2:gpadmin-[INFO]:-Gathering information and validating the environment...
20130105:09:27:37:010544 gpstart:vm2:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.2.1.0 build 3 Community Edition'
20130105:09:27:37:010544 gpstart:vm2:gpadmin-[INFO]:-Greenplum Catalog Version: '201109210'
20130105:09:27:37:010544 gpstart:vm2:gpadmin-[INFO]:-Starting Master instance in admin mode
20130105:09:27:38:010544 gpstart:vm2:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20130105:09:27:38:010544 gpstart:vm2:gpadmin-[INFO]:-Obtaining Segment details from master...
20130105:09:27:39:010544 gpstart:vm2:gpadmin-[INFO]:-Setting new master era
20130105:09:27:39:010544 gpstart:vm2:gpadmin-[INFO]:-Master Started...
20130105:09:27:39:010544 gpstart:vm2:gpadmin-[INFO]:-Shutting down master
20130105:09:27:40:010544 gpstart:vm2:gpadmin-[INFO]:-No standby master configured.  skipping...
20130105:09:27:40:010544 gpstart:vm2:gpadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
. 
20130105:09:27:41:010544 gpstart:vm2:gpadmin-[INFO]:-Process results...
20130105:09:27:41:010544 gpstart:vm2:gpadmin-[CRITICAL]: -gpstart failed. (Reason='') exiting...
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:-Failed to start Greenplum instance; review gpstart output to
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:- determine why gpstart failed and reinitialize cluster after resolving
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:- issues.  Not all initialization tasks have completed so the cluster
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:- should not be used.
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster
20130105:09:27:41:031805 gpinitsystem:vm2:gpadmin-[WARN]:
20130105:09:27:41:010761 gpstop:vm2:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /usr/local/dnt/svm/master_database/gpseg-1
20130105:09:27:41:010761 gpstop:vm2:gpadmin-[INFO]:-Gathering information and validating the environment...
20130105:09:27:41:010761 gpstop:vm2:gpadmin-[ERROR]:-gpstop error: postmaster.pid file does not exist.  is Greenplum instance already stopped?
20130105:09:27:41:gpinitsystem:vm2:gpadmin-[WARN]:-Failed to stop new Greenplum instance Script Exiting!

2 个解决方案

#1

gpstop  -a -i -d /usr/local/dnt/svm/master_database/gpseg-1

不管是否出错
然后再 gpstart -a 

#2

这个是由于数据库segment节点在启动时失败，具体失败原因应该到具体的segment的日志文件中去看。在创建的时候的错误，大部分应该跟系统配置相关。