Greenplum 单机版安装问题及解决记录

安装步骤及资源见连接【Linux部署】Greenplum单机版（CentOS Linux release 7.5）详细步骤+问题解决（含安装包 greenplum-db-6.13.0-rhel7-x86_64.rpm）_シ風箏-CSDN博客

安装中遇见的问题：

1、ssh 22端口拒绝连接

我的问题是虚机更改了ssh 22端口，改为了6233

解决方式：修改gpssh-exkeys，./greenplum-db/lib/python/gppylib/commands/base.py文件

详情见：Greenplum启动时 SSH 22端口连接拒绝，修改默认通信端口 - Aiden郭祥跃 - 博客园

2、gpadmin-[FATAL]:-Unknown host mdw

bash-4.2$ gpinitsystem -c gpinitsystem_config -h seg_hosts_file
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Detected a single host GPDB array build, reducing value of BATCH_DEFAULT from 60 to 4
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
.20220215:08:58:03:042645 gpinitsystem:mdw:gpadmin-[FATAL]:-Unknown host mdw: ping: socket: Operation not permitted
ping: socket: Operation not permitted Script Exiting!

我的问题是非root用户没有ping的权限，如果/etc/hosts 配置不正确也会导致此问题，

解决方式：使用root用户执行chmod u+s /bin/ping命令，再切换至gpadmin 执行 gpinitsystem 操作

3、gpstart error: Do not have enough valid segments to start the array.

开始以为是shared_buffers大小设置的问题，搜了搜，发现这个错误很粗，所以去扒拉日志，发现启动日志出现了6000、6001端口，本虚机中6001端口已经被使用，所以猜测是端口占用导致的启动失败。

解决方式：把初始化的数据文件删除，更改gpinitsystem_config中的PORT_BASE为5500，启动成功。