集群查询或导入数据时，异常：could not determine master from helpers

💬 StarRocks 用户问答 日常运维
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】在查询或写入doris时，有时会报错，错误为：could not determine master from helpers[192.168.190.207,192.168.190.209,192.168.190.204,192.168.190.203]
【背景】做过哪些操作？
【业务影响】
【是否存算分离】否
【StarRocks版本】例如：3.1.9
【集群规模】例如：7fe（4 follower+3observer）+11be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/256G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：463971866@qq.com，谢谢
【附件】

show proc ‘/frontends’

Name |IP |EditLogPort|HttpPort|QueryPort|RpcPort|Role |ClusterId |Join |Alive|ReplayedJournalId|LastHeartbeat |IsHelper|ErrMsg|StartTime |Version |
----------------------------------±--------------±----------±-------±--------±------±-------±---------±----±----±----------------±------------------±-------±-----±------------------±------------+
192.168.190.204_9010_1715740781972|192.168.190.204|9010 |8030 |9030 |9020 |FOLLOWER|1278207779|false|true |10393853 |2024-12-31 13:47:49|true | |2024-08-30 17:51:11|3.1.9-e1c6e4e|
192.168.190.213_9010_1716455247393|192.168.190.213|9010 |8030 |9030 |9020 |OBSERVER|1278207779|false|true |10393853 |2024-12-31 13:47:49|false | |2024-05-29 16:43:17|3.1.9-e1c6e4e|
192.168.190.203_9010_1715736994182|192.168.190.203|9010 |8030 |9030 |9020 |FOLLOWER|1278207779|false|true |10393854 |2024-12-31 13:47:49|true | |2024-08-30 17:55:04|3.1.9-e1c6e4e|
192.168.190.209_9010_1715740782013|192.168.190.209|9010 |8030 |9030 |9020 |LEADER |1278207779|false|true |10393853 |2024-12-31 13:47:49|true | |2024-08-30 17:59:37|3.1.9-e1c6e4e|
192.168.190.207_9010_1715740781996|192.168.190.207|9010 |8030 |9030 |9020 |FOLLOWER|1278207779|false|true |10393853 |2024-12-31 13:47:49|true | |2024-08-30 18:05:41|3.1.9-e1c6e4e|
192.168.190.212_9010_1715740782067|192.168.190.212|9010 |8030 |9030 |9020 |OBSERVER|1278207779|false|true |10393853 |2024-12-31 13:47:49|false | |2024-05-29 16:38:30|3.1.9-e1c6e4e|
192.168.190.211_9010_1715740782050|192.168.190.211|9010 |8030 |9030 |9020 |OBSERVER|1278207779|false|true |10393853 |2024-12-31 13:47:49|false | |2024-05-29 16:33:22|3.1.9-e1c6e4e|

7 row(s) fetched.

fe的日志：

#2

报错的具体信息：WARN (starrocks-mysql-nio-pool-150303|31860678) [StmtExecutor.execute():674] execute Exception, sql select t1.intermediary_number as intermediaryNumber,t1.intermediary_type as intermediaryType from bd_dwd_abnormal_intermediate_number_ad_day t1 where (t1.intermediary_number in (‘15520285023’,‘19881809902’,‘15196899317’) and t1.intermediary_type=‘1’ and t1.day_id=‘2025-01-01’) limit 20
com.sleepycat.je.rep.UnknownMasterException: (JE 18.3.16) Could not determine master from helpers at:[/192.168.190.203:9010, /192.168.190.204:9010, /192.168.190.207:9010, /192.168.190.209:9010]
at com.sleepycat.je.rep.elections.Learner.findMaster(Learner.java:443) ~[starrocks-bdb-je-18.3.16.jar:?]
at com.sleepycat.je.rep.util.ReplicationGroupAdmin.getMasterNodeName(ReplicationGroupAdmin.java:208) ~[starrocks-bdb-je-18.3.16.jar:?]
at com.starrocks.ha.BDBHA.getLeaderNodeName(BDBHA.java:148) ~[starrocks-fe.jar:?]
at com.starrocks.server.NodeMgr.getLeaderIpAndRpcPort(NodeMgr.java:1106) ~[starrocks-fe.jar:?]
at com.starrocks.qe.LeaderOpExecutor.forward(LeaderOpExecutor.java:164) ~[starrocks-fe.jar:?]
at com.starrocks.qe.LeaderOpExecutor.execute(LeaderOpExecutor.java:103) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.forwardToLeader(StmtExecutor.java:752) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:511) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:375) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:481) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:767) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]

#3

这里是starrocks，提错了？

#4

没有提错哈，我只是写错了，就是starrocks哈

京ICP备2022026421号-1