开发者社区> 问答> 正文

greepplum "Interconnect encountered a network error, please check your network (seg1 slice1 机器名:端口 pid=7488)","Failed to send packet (seq 1) to IP:端口 (pid 5582 cid 3) after 3581 retries in 3600 seconds"

1.环境:ETL机器 windows机,网段10.171.64 Greenplum机器 3台linux,网段10.25.143, 2台10.174.13,均是阿里云机器,greenplum版本4.3.9.0
2.执行批量copy或insert操作时,容易出现该错误
3.关于这个问题,提示是网络原因导致,如果是网络不稳定导致抖动,报错提示有重试了多少次,即使不稳定,不断重试应该也是可以执行成功。
4.具体错误:
2017-02-17 01:26:59.357701 CST,"user","db",p7453,th-1987737824,"IP","53545",2017-02-17 00:26:54 CST,52975354,con998,cmd9,seg-1,,dx4673326,x52975354,sx1,"ERROR","58M01","Interconnect encountered a network error, please check your network (seg1 slice1机器名:40001 pid=7488)","Failed to send packet (seq 1) to IP:4789 (pid 5582 cid 3) after 3581 retries in 3600 seconds",,,,,"insert into ...."
求解答~ 感谢~

展开
收起
木莲00987 2017-11-22 16:57:54 10229 0
2 条回答
写回答
取消 提交回答
  • GP Bug,主从复制超时导致误报

    2019-07-17 21:44:50
    赞同 展开评论 打赏
  • 你这个端口号是多少,在安全组里面有打开吧.

    2019-07-17 21:44:50
    赞同 展开评论 打赏
问答分类:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
KR^X- Comprehensive- Kernel-Protection-Against-Just-In-Time-Code-Reuse 立即下载
A Perfect Solution for Live Migration with Pass-through Devices 立即下载
AliHB Real Time Cold data Backup 立即下载