【详述】refresh external table failed，3个fe节点，其中一个fe节点通信失败。
fe.log
2022-07-07 10:44:02,841 WARN (starrocks-mysql-nio-pool-268|938) [StmtExecutor.handleDdlStmt():934] DDL statement(refresh external table sl_dwv_trade_order_item_fct) process failed.
com.starrocks.common.DdlException: refresh external table failed: refresh fe xxx.xxx.xxx.xxx failed: java.net.SocketException: Broken pipe (Write failed);
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:75) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.refreshExternalTable(Catalog.java:6811) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DdlExecutor.execute(DdlExecutor.java:235) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:926) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:445) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:290) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:439) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:675) ~[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_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
fe.warn.log
2022-07-07 10:43:43,835 WARN (Thread-80|974) [Catalog.lambda$refreshOtherFesTable$4():6833] call fe TNetworkAddress(hostname:xxx.xxx.xxx.xxx, port:9020) refreshTable rpc method failed
org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
at org.apache.thrift.transport.TIOStreamTransport.flush(TIOStreamTransport.java:159) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:73) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:62) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.thrift.FrontendService$Client.send_refreshTable(FrontendService.java:614) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Client.refreshTable(FrontendService.java:606) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog$6.invoke(Catalog.java:6828) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog$6.invoke(Catalog.java:6825) ~[starrocks-fe.jar:?]
at com.starrocks.rpc.FrontendServiceProxy.call(FrontendServiceProxy.java:18) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.lambda$refreshOtherFesTable$4(Catalog.java:6824) ~[starrocks-fe.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_202]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: java.net.SocketException: Broken pipe (Write failed)
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_202]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) ~[?:1.8.0_202]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_202]
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_202]
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[?:1.8.0_202]
at org.apache.thrift.transport.TIOStreamTransport.flush(TIOStreamTransport.java:157) ~[libthrift-0.13.0.jar:0.13.0]
... 10 more
【背景】
执行sql语句：refresh external table sl_dwv_trade_order_item_fct;
【业务影响】导致hive外表的查询打到有问题的节点，会导致查询很慢。
【StarRocks版本】例如：2.2.0
【集群规模】例如：3fe（1 follower+2observer）+5be
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【附件】