收录日期:2019/12/16 12:51:42 时间:2016/08/27 23:17:10 标签:PostgreSQL
greenplum [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!
gpstop  -a -i -d /usr/local/dnt/svm/master_database/gpseg-1

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

请教一个关于记录数量的问题 请问:我现在用jTable1 = new JTable(tableModel);来显示从数据库中查出的数据,怎么能做到删除选择的行呢? 愿意用所有的分数来求这个题的答案,关于登陆问题。 虚线打印问题 遇到怪事搞不定啦~~好心人来看看~ 愿意用所有的分数来求这个题的答案,关于登陆问题。 用什么软件把硬盘上的文件转换成*.mds镜像格式的文件? 数据库导入导出问题。。。 VB操作注册表问题 特急问题,关于在rad hat下安装mo的问题 解读三种access的连接,分别在什么情况下使用? 特急 新手求助 session问题 C#,Winform中,怎样根据DataGrid的某一列的值的属性设置改行的颜色? 如何实现 加急!!远程的在web服务器上建立虚拟目录并可以对其进行删除等操作!!up有分! 設BEA HOME時registry.xml找不到? 今天win2000服务器全线崩溃!!急救啊!!!! 哪有jb8_encoding_fix.jar,哪位大虾指点 windows xp 怎么会自动重启??? 做一个漂亮的c#安装文件!用什么工具! 服务器上一般安装什么防火墙? 如何设置一个文件的版本号 特急问题,关于在rad hat下安装mo的问题 怎样设置,让apache能list文件列表 急聘!做手机铃声、图片下载网站,jsp程序员请进! win200/xp密码问题 关于汇编的多线程问题 bcb的问题,高手帮忙 如何破解不可打印pdf文档的问题? 怎么装新硬盘???谢谢