原 GreenPlum中查询用户表卡住 Interconnect encountered a network error, please check your network
👉 本文共约1069个字，系统预计阅读时间或需5分钟。
环境简介
环境：GreenPlum 6.25.3 ， centos 7.6
现象
查询用户自建的表，会卡住很久，最后报错：
1 2 3 4 5 6 7 8 9 | ERROR: Interconnect encountered a network error, please check your network (seg3 slice1 gp2.ops.bj1:33001 pid=69361) DETAIL: Failed to send packet (seq 1) to 10.0.3.33:56292 (pid 37236 cid 6) after 3580 retries in 3600 seconds gpdb=> select * from test; //The table does not have any data ......... long long long time. ERROR: Interconnect encountered a network error, please check your network (seg0 slice1 10.60.80.29:40000 pid=23670) DETAIL: Failed to send packet (seq 1) to 10.60.80.28:10670 (pid 15645 cid -1) after 3574 retries in 3600 seconds |
但是，查询系统表不报错。
可能的原因
1、防火墙
2、udp修改为tcp
3、网卡的mtu配置过大
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
