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

简介: 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=# 

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

目录
相关文章
|
SQL 存储 Oracle
kettle从oracle到mysql数据迁移
kettle从oracle到mysql数据迁移
1199 0
|
存储 关系型数据库 MySQL
|
存储 运维 Kubernetes
【OushuDB】Oushu Database和Apache HAWQ的不同
全新执行引擎,充分利用硬件的所有特性,比Apache HAWQ性能高出5-10倍支持Update和Delete,以及索引C++可插拔外部存储替换JAVA PXF,性能高数倍,无需安装部署PXF额外组件,极大简化了用户安装部署和运维原生支持CSV/TEXT外部存储可以用于不同集群之间共享数据,比如数据仓库和集市之间共享及传输数据可以用于高速数据加载和数据导出可以实现高速备份和恢复可以实现可插拔文件系统:比如S3, Ceph等可以实现可插拔文件格式:比如ORC,Parquet等支持ORC/TEXT/CSV作为内部表格式,支持ORC作为外部表格式 (通过C++可插拔外部存储)对PaaS/CaaS云平
256 0
【OushuDB】Oushu Database和Apache HAWQ的不同
|
Web App开发 关系型数据库 数据库
PostgreSQL recovery.conf 配置文件整合到 postgresql.conf
标签 PostgreSQL , recovery.conf , postgresql.conf 背景 PostgreSQL 12版本以前,配置PostgreSQL数据库恢复、流复制STANDBY,都需要配置recovery.conf,如果要修改配置,需要重启数据库。
2992 0
|
关系型数据库 Linux 网络安全
|
关系型数据库 PostgreSQL 网络架构
|
关系型数据库 PostgreSQL C语言
|
关系型数据库 MySQL 数据库
|
关系型数据库 MySQL 数据库
|
Web App开发 关系型数据库 MySQL