gaussdb安装部署时遇到的坑

web端重启服务器集群报错

[2019-12-12 17:02]Start roleInstance for MPPDBServer#192.168.9.246@host0.
[2019-12-12 17:02]RoleInstance prepare to start complete for MPPDBServer#192.168.9.246@host0.
[2019-12-12 17:02]RoleInstance start failure [{ScriptExecutionResult=ScriptExecutionResult [exitCode=1, output=, errMsg=]}] for MPPDBServer#192.168.9.246@host0.
[2019-12-12 17:02]Role start failure for Service[name: MPPDB, displayName: MPPDB, cluster: CVICSE].
[2019-12-12 17:02]RESID_OM_STEPCOMMON_0006 failure, because Failed to start the entity.

报错原因

在安装部署文档中配置服务端远程连接时有一条指令：gs_guc set -I all -Z coordinator -c “listen_addresses=‘localhost,192.168.0.100,10.11.12.13’”，这后边的ip填的是服务器的ip，我当时以为这是在为远程访问添加白名单，就把本地ip加进去了。

报错解决

把指令中的ip改成服务器ip重新执行一下并重启集群即可
gs_guc set -I all -Z coordinator -c “listen_addresses=‘localhost,192.168.9.246’”
重启集群：gs_om -t stop && gs_om -t start