apache
ic-proxy: interconnect error: connection closed prematurely
Cloudberry Database version
postgres=# select version(); version
PostgreSQL 14.4 (Cloudberry Database 1.4.0 build commit:e83e3ffc22d538deb2dbceeeae0138ca2de064e6) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Anolis 8.3.1-5.0.1.1) , 64-bit compiled on Sep 17 2023 23:10:22 (with assert checking) (1 row)
What happened
interconnect type set as proxy and received below errors:
master:
2024-01-08 12:18:03.418100 CST,",p493382,th-1664801920,""46890",2024-01-08 10:17:46 CST,0,con159,cmd23,seg-1,,dx6366183,,sx1,"ERROR","58M01","interconnect error: connection closed prematurely (seg19 xxx.xxx.xxx.xxx:6003 pid=39387)","from Remote Connection: contentId=60 at",,,,,"insert into xxxx select starttime ,period
segment:
2024-01-08 13:01:37.711883 CST,,,p45134,th235180928,,,,0,,,seg19,,,,,"WARNING","01000","peer[seg60,dbid62 xxx.xxx.xxx.xxx:16003->xxx.xxx.xxx.xxx:55071]: fail to shutdown: socket is not connected",,,,,,,0,,"ic_proxy_peer.c",446,
2024-01-08 13:01:37.713647 CST,,,p45134,th235180928,,,,0,,,seg19,,,,,"WARNING","01000","client[con64863,cmd3,slice[1->0] seg19:dbid21:p67661->seg48:dbid50:p640943]: fail to receive c2p DATA: connection reset by peer",,,,,,,0,,"ic_proxy_client.c",502,
2024-01-08 13:01:37.713728 CST,,p67661,th235180928,","10265",2024-01-08 13:01:09 CST,1909017,con64863,cmd3,seg19,,dx6366775,x1909018,sx2,"ERROR","58M01","interconnect error: connection closed prematurely","from Remote Connection: contentId=60 at",,,,,"insert into xxxxxx ^M
select a.starttime,^M
gp_interconnect_proxy_addresses port : 16003
What you think should happen instead
No response
How to reproduce
it is reproducing easily.
Operating System
BELinux.
Anything else
No response
Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
Code of Conduct
- [X] I agree to follow this project's Code of Conduct.
we find the similar error at PostgreSQL 14.4 (Cloudberry Database 1.0.0+d0ac915 build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit compiled on Jun 27 2024 16:27:36
1、Use gpfdist to create an external table 2、then use insert into to insert the data from the external table into the business table 3、then delete the external table. In high concurrency situations, this error occurs very frequently. the master error ：2024-08-28 07:54:30.058095 CST,"edw","edw",p494437,th-143910784,"0.0.0.0","56664",2024-08-28 07:53:15 CST,242165,con53784,cmd10,seg-1,,dx285094,x242165,sx1,"ERROR","58M01","failed to acquire resources on one or more segments","connection to server at ""0.0.0.1"", port 6002 failed: server closed the connection unexpectedly
