【详述】执行insert into as select之后，客户端连接断开，但是数据照常写入
【StarRocks版本】2.0.1
【集群规模】1fe+3be
【客户端报错】
[2022-02-21 16:53:10] Communications link failure
[2022-02-21 16:53:10] The last packet successfully received from the server was 60,118 milliseconds ago. The last packet sent successfully to the server was 60,116 milliseconds ago.
【fe报错】
2022-02-21 09:05:28,025 WARN (starrocks-mysql-nio-pool-292|6192) [ReadListener.lambda$handleEvent$0():63] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@62f19d9b).
java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_181]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_181]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_181]
at sun.nio.ch.IOUtil.write(IOUtil.java:65) ~[?:1.8.0_181]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471) ~[?:1.8.0_181]
at org.xnio.nio.NioSocketConduit.write(NioSocketConduit.java:153) ~[xnio-nio-3.7.9.Final.jar:3.7.9.Final]
at org.xnio.conduits.ConduitStreamSinkChannel.write(ConduitStreamSinkChannel.java:150) ~[xnio-api-3.7.9.Final.jar:3.7.9.Final]
at org.xnio.channels.Channels.writeBlocking(Channels.java:97) ~[xnio-api-3.7.9.Final.jar:3.7.9.Final]
at com.starrocks.mysql.nio.NMysqlChannel.realNetSend(NMysqlChannel.java:86) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:209) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:276) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.finalizeCommand(ConnectProcessor.java:478) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:633) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
您好，您的意思是使用mysql客户端执行insert into as select的时候超时60s之后报的这个错？
是的，找到原因了，端口转发的时候超时了
请问这个问题后来如何解决的？
可以开个新帖子描述一下你当前遇到的问题，更方便定位