Postgres-XL使用pgxc_ctl init all时出错-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Postgres-XL使用pgxc_ctl init all时出错

在单个节点上,搭建XL环境,一个GTM节点,一个Coordinator节点,两个Datanode节点。
使用pgxc_ctl配置集群节点,pgxc_ctl.conf主要配置如下:

gtmMasterServer=192.168.30.203
gtmMasterPort=20001
gtmMasterDir=$HOME/pg-xl/nodes/gtm

coordMasterDir=$HOME/pg-xl/nodes/coord
coordSlaveDir=$HOME/pg-xl/nodes/coord_slave
coordArchLogDir=$HOME/pg-xl/nodes/coord_archlog

coordNames=(coord1)             # Master and slave use the same name
coordPorts=(25432)                      # Master ports
poolerPorts=(20010)                     # Master pooler ports
coordPgHbaEntries=(192.168.30.0/24)

coordMasterServers=(192.168.30.203)             # none means this master is not available
coordMasterDirs=($coordMasterDir/coord1)
coordMaxWALsernder=0    # max_wal_senders: needed to configure slave. If zero value is specified,
                                                # it is expected to supply this parameter explicitly by external files
                                                # specified in the following.   If you dont configure slaves, leave this value to zero.
coordMaxWALSenders=($coordMaxWALsernder)
                                                # max_wal_senders configuration for each coordinator.

使用pgxc_ctl init all初始化集群,输出信息中错误如下:

ALTER NODE coord1 WITH (HOST='192.168.30.203', PORT=25432);
ALTER NODE
CREATE NODE datanode1 WITH (TYPE='datanode', HOST='192.168.30.203', PORT=15432, PREFERRED);
CREATE NODE
CREATE NODE datanode2 WITH (TYPE='datanode', HOST='192.168.30.203', PORT=15433, PREFERRED);
CREATE NODE
SELECT pgxc_pool_reload();
 pgxc_pool_reload 
 t
(1 row)

Done.
EXECUTE DIRECT ON (datanode1) 'CREATE NODE coord1 WITH (TYPE=''coordinator'', HOST=''192.168.30.203'', PORT=25432)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode1) 'ALTER NODE datanode1 WITH (TYPE=''datanode'', HOST=''192.168.30.203'', PORT=15432, PREFERRED)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode1) 'CREATE NODE datanode2 WITH (TYPE=''datanode'', HOST=''192.168.30.203'', PORT=15433, PREFERRED)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode1) 'SELECT pgxc_pool_reload()';
ERROR:  Could not begin transaction on data node.
EXECUTE DIRECT ON (datanode2) 'CREATE NODE coord1 WITH (TYPE=''coordinator'', HOST=''192.168.30.203'', PORT=25432)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode2) 'CREATE NODE datanode1 WITH (TYPE=''datanode'', HOST=''192.168.30.203'', PORT=15432, PREFERRED)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode2) 'ALTER NODE datanode2 WITH (TYPE=''datanode'', HOST=''192.168.30.203'', PORT=15433, PREFERRED)';
ERROR:  invalid byte sequence for encoding "UTF8": 0xcb
EXECUTE DIRECT ON (datanode2) 'SELECT pgxc_pool_reload()';
ERROR:  Could not begin transaction on data node.
Done.

最开始,尝试删除XL的安装目录pg-xl,重新安装,解决过问题。但后面再碰到这个问题,重装也无效了。

请教云栖社区的PGer指点一二!谢谢!

展开
收起
ka1gu0 2016-05-23 17:14:00 6289 0
0 条回答
写回答
取消 提交回答
问答排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载