收录日期:2020/07/12 20:22:39 时间: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的日志文件中去看。在创建的时候的错误,大部分应该跟系统配置相关。

servlet里可以链接某目录下的文件吗? 问一个关于内存和CPU搭配问题!谢谢晚上上完课回来给分 datagrid的分页数怎么得出来? 为什么Delphi7中没有NMUDP,怎样可以安装NMUDP. 进来看看你的显示器是否真的通过了TCO99! 8848.com 高薪诚聘VC/MFC程序员 请问如何调试自己的组件 treeview的节点连线颜色问题, 高分! 刚才的例子未能完全反映实际问题,再提50分问!! 怎么动态的添加textbox控件,?它的事件怎么办? 菜鸟的问题,请高手帮我!先谢。 请问哪有V studio.net编程环境的下载? 请问dllhost.exe是干什么用的? jsp页面存储特殊字符的问题???? 急需语音判断这些资料? 谁能告诉我这是怎么回事,实际我根本就不缺少\"end\",哎,头疼哦. ************关于Excel库打包问题************ 希望自己能从这段痛苦中走出来!散分 想学习网络技术、网络安全、MBA教程、财会教程、法制教程、程序设计与数据库、计算机专业等课程么? windows 2000终端服务的连接数问题 各位大虾,高手请帮忙!急! 找不到可安装的ISAM Session的超时问题 8848.com 高薪诚聘VC/MFC程序员 ************关于Excel库打包问题************ 关于javax.swing.event.DocumentListener的问题 8848.com 高薪诚聘.Net程序员 怎样自定义鼠标的现实形状而不用其自带的13种形状(急,再线等) 帮忙看看这段代码?狂急! 网络高手Come in!