原 GreenPlum数据库不定时报错interconnect error connection closed prematurely、timed out waiting for response from motion receiver during TCP interconnect teardown
Tags： 原创故障处理GreenPlum网络GP网络问题interconnect teardown
👉 本文共约222个字，系统预计阅读时间或需1分钟。
简介
一套GP库，不定时报错：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | timed out waiting for response from motion receiver during TCP interconnect teardown (seg3 slice1 192.168.216.100:6003 pid=3010129) Command could not be dispatch to segment seg0 slice1 192.168.216.100:6000 pid=879869: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Error on receive from seg0 192.168.216.100:6000 pid=1504226: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Interconnect Error: Unexpected Motion Node Id: 1 (size 10). This means a motion node that wasn't setup is requesting interconnect resources. (seg0 slice2 192.168.216.100:6000 pid=2256033) MPP detected 16 segment failures, system is reconnected interconnect error: connection closed prematurely DTX RollbackAndReleaseCurrentSubTransaction dispatch failed |
在数据库中查询：
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
