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

[nj_shufe]

[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!

[jyd30]

gpstop -a -i -d /usr/local/dnt/svm/master_database/gpseg-1 不管是否出错 然后再 gpstart -a

[windtalkerwy]

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