【详述】问题详细描述
1）select查询
2）应用侧经常报Cause: java.sql.SQLSyntaxErrorException: Cannot open null host错误
3）StarRocks FE 日志经常出现org.apache.thrift.transport.TTransportException: Cannot open null host警告,详细日志如下：
2023-03-10 13:26:34,758 WARN (starrocks-mysql-nio-pool-6419|18467) [StmtExecutor.execute():491] execute Exception, sql select duration,extDuration,lesson_id lessonId,user_code userCode,first_in firstIn,last_out lastOut,total_playback_time playbackTime from t_xxx where lesson_id in (3046457320) and user_code in ( ‘NTB43270’)
org.apache.thrift.transport.TTransportException: Cannot open null host.
at org.apache.thrift.transport.TSocket.open(TSocket.java:210) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.GenericPool$ThriftClientFactory.create(GenericPool.java:131) ~[starrocks-fe.jar:?]
at com.starrocks.common.GenericPool$ThriftClientFactory.create(GenericPool.java:116) ~[starrocks-fe.jar:?]
at org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:62) ~[commons-pool2-2.3.jar:2.3]
at org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1036) ~[commons-pool2-2.3.jar:2.3]
at org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:356) ~[commons-pool2-2.3.jar:2.3]
at org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:278) ~[commons-pool2-2.3.jar:2.3]
at com.starrocks.common.GenericPool.borrowObject(GenericPool.java:92) ~[starrocks-fe.jar:?]
at com.starrocks.rpc.FrontendServiceProxy.call(FrontendServiceProxy.java:20) ~[starrocks-fe.jar:?]
at com.starrocks.qe.MasterOpExecutor.forward(MasterOpExecutor.java:140) ~[starrocks-fe.jar:?]
at com.starrocks.qe.MasterOpExecutor.execute(MasterOpExecutor.java:78) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.forwardToMaster(StmtExecutor.java:583) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:382) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:322) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:440) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:684) ~[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_242]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_242]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242]
【业务影响】
查询失败
【StarRocks版本】
mysql> select current_version();
±------------------+
| current_version() |
±------------------+
| 2.3.8 4739a1e |
±------------------+
1 row in set (0.01 sec)
【集群规模】例如：3fe（1 follower+2observer）+6be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：64C/256G/万兆
