ODBC连接MySQL，查询外表会报错（偶现问题）

[wangjie000111]

问题描述：
ODBC连接MySQL，查询外表会报错（RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason），
并且会导致be节点挂掉(挂掉时be.out没有日志，dmsg-T也没有日志)
问题复现的case：

Doris版本：
doris-1.1.0-rc05
Doris集群基本信息：
fe 1台 16c64g
be 10台 16c64g
fe异常信息：
2022-08-11 10:24:30,723 WARN (doris-mysql-nio-pool-21564|159343) [StmtExecutor.execute():464] execute Exception. stmt[579917, 3460a146f08b4d5b-8a2ca1441c9b02
org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:863) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:951) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:929) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:392) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:306) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:212) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:349) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:538) ~[doris-fe.jar:1.0-SNAPSHOT]
at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[doris-fe.jar:1.0-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_241]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_241]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_241]

[hf200012]

看着像是网络问题，你可以监控一下网络看看

[wangjie000111]

目前看不像是网络问题，查询只会导致固定一台be挂掉，
如果把这台be停掉，查询也不会报错了
看着像是这台be的问题

[dataalive]

在dmesg -T中可以看到网络相关的异常日志不

[wangjie000111]

那一台be节点的dmesg -T没有任何相关的日志

[wangjie000111]

问题已解决，odbc的版本问题，该台be节点上5.1X版本的odbc连接Doris，执行sql会导致be崩溃（且无日志），目前已升级odbc版本修复。

以下是执行sql导致be自动关闭的日志：

I0822 17:47:10.651582 7474 odbc_connector.cpp:112] connect success:Driver=MySQL ODBC driver;Server=pc-k2jlz0f68vut235ia.rwlb.zhangbei.rds.aliyuncs.com;Port=3306;DataBase=middle_platform;Uid=prod;
I0822 17:47:10.793314 7643 tablets_channel.cpp:60] open tablets channel: (id=69449d0acdbbdab4-0970009986ea9abf,index_id=11255931), tablets num: 171, timeout(s): 600
I0822 17:47:10.795621 7630 tablets_channel.cpp:163] close tablets channel: (id=69449d0acdbbdab4-0970009986ea9abf,index_id=11255931), sender id: 0, backend id: 10007
I0822 17:47:10.795738 7630 load_channel.cpp:40] load channel removed. mem peak usage=0, info=limit: 2147483648; consumption: 0; label: LoadChannel:69449d0acdbbdab4-0970009986ea9abf; all tracker size: 3; limit trackers size: 2; parent is null: false; , load_id=69449d0acdbbdab4-0970009986ea9abf, is high priority=0, sender_ip=172.16.0.112
I0822 17:47:13.278090 9222 daemon.cpp:240] version 1.1.0-rc05 RELEASE (build file:///root/doris@Unknown)
Built on Sun, 10 Jul 2022 13:39:22 UTC by root@1264bad10c91