zl程序教程

您现在的位置是:首页 >  其他

当前栏目

GreenPlum的那些事《二》——GreenPlun启动报错

2023-02-26 10:20:11 时间

在配置好GreenPlum过程中,需要注意一下几点:

  1. 找好安装包
  2. 安装依赖,Gun版本需要注意
  3. 详细安装步骤参考Greenplum安装介绍

自己是电脑虚拟机安装的中间出现很多报错,度娘加经验解决。最后启动还是报错,发现是资源不足,所以关闭了mirror,减少了segment。然后启动还是报错:

(福利推荐:阿里云、腾讯云、华为云服务器最新限时优惠活动,云服务器1核2G仅88元/年、2核4G仅698元/3年,点击这里立即抢购>>>

>     > 20190122:20:23:14:003437 gpstart:mpp01:gpadmin-[INFO]:-Commencing parallel segment instance > startup, please wait... >     ...  >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Process results... >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-   Successful segment starts                                            = > 3 >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-   Failed segment starts                                                = 0 >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0 >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Successfully started 3 of 3 segment > instances  >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- >     20190122:20:23:17:003437 gpstart:mpp01:gpadmin-[INFO]:-Starting Master instance mpp01 directory /opt/greenplum/data/master/gpseg-1  >     20190122:20:23:18:003437 gpstart:mpp01:gpadmin-[INFO]:-Command pg_ctl reports Master mpp01 instance active >     20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[WARNING]:-FATAL:  DTM initialization: failure during startup recovery, retry failed, > check segment status (cdbtm.c:1517) >     20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[INFO]:-No standby master configured.  skipping... >     20190122:20:23:19:003437 gpstart:mpp01:gpadmin-[INFO]:-Check status of database with gpstate utility 

查看日志没有找到什么原因,后台度娘发现了,原来是防火墙没有关闭。那么就来关闭防火墙:

/etc/init.d/iptables stop [[email protected] ~]# /etc/init.d/iptables stop   iptables: Setting chains to policy ACCEPT: filter          [  OK  ] iptables: Flushing firewall rules:                         [  OK  ] iptables: Unloading modules:                               [  OK  ]  

在3台机器上都关闭防火墙操作,然后启动

gpstart      20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Process results... 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-   Successful segment starts                                            = 3 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-   Failed segment starts                                                = 0 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances  20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:----------------------------------------------------- 20190122:20:28:01:004200 gpstart:mpp01:gpadmin-[INFO]:-Starting Master instance mpp01 directory /opt/greenplum/data/master/gpseg-1  20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-Command pg_ctl reports Master mpp01 instance active 20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-No standby master configured.  skipping... 20190122:20:28:02:004200 gpstart:mpp01:gpadmin-[INFO]:-Database successfully started 

启动成功!

psql [[email protected] ~]$ psql psql (8.3.23) Type "help" for help.  gp_sydb=# 

启动成功了,开始下面的学习吧

GreenPlum的那些事《二》——GreenPlun启动报错


本站部分内容转载自网络,版权属于原作者所有,如有异议请联系QQ153890879修改或删除,谢谢!
转载请注明原文链接:GreenPlum的那些事《二》——GreenPlun启动报错

你还在原价购买阿里云、腾讯云、华为云、天翼云产品?那就亏大啦!现在申请成为四大品牌云厂商VIP用户,可以3折优惠价购买云服务器等云产品,并且可享四大云服务商产品终身VIP优惠价,还等什么?赶紧点击下面对应链接免费申请VIP客户吧:

1、点击这里立即申请成为腾讯云VIP客户

2、点击这里立即注册成为天翼云VIP客户

3、点击这里立即申请成为华为云VIP客户

4、点击这里立享阿里云产品终身VIP优惠价

喜欢 (0)
[[email protected]]
分享 (0)