原 GreenPlum中查询用户表卡住 Interconnect encountered a network error, please check your network
环境简介
环境: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配置过大