GreenPlum的那些事《二》——GreenPlun啟動報錯

在配置好GreenPlum過程中，需要注意一下幾點：

1. 找好安裝包
2. 安裝依賴，Gun版本需要注意
3. 詳細安裝步驟參考 Greenplum安裝介紹

自己是電腦虛拟機安裝的中間出現很多報錯，度娘加經驗解決。最後啟動還是報錯，發現是資源不足，是以關閉了mirror，減少了segment。然後啟動還是報錯：

>     > 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
[root@mpp03 ~]# /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
[gpadmin@mpp01 ~]$ psql
psql (8.3.23)
Type "help" for help.

gp_sydb=#            

啟動成功了，開始下面的學習吧