doris查询汇总和load消费任务时,总是报错副本不存在?

Viewed 10

doris版本为2.1.15,
具体描述:doris集群1个fe节点,4个be节点,stream、offline、online、online02白标签,在stream标签下的机器同时承担routine load作业和实时汇总任务,但是该机器cpu配置为112核,512G,21T SSD,总的cpu使用率不高不到10%。具体报错如下:
2025-09-02 22:14:11,514 WARN (mysql-nio-pool-54136|134138) [StmtExecutor.executeByNereids():806] Nereids plan query failed:

            SELECT
            max(update_time) AS max_time, min(update_time) as min_time
            FROM MES_PROCESS_DATA where mes_inst_name = ? and project_code = ? and create_time >= ? and  update_time >= ?

java.lang.RuntimeException: errCode = 2, detailMessage = tablet 58606961 has no queryable replicas. err: Replica on backend 13103 with tag {"location" : "group_online0
2"}, which is not in user's resource tags: [{"location" : "group_stream"}], Replica on backend 13105 with tag {"location" : "group_offline"}, which is not in user's re
source tags: [{"location" : "group_stream"}], Replica on backend 13102 with tag {"location" : "group_online"}, which is not in user's resource tags: [{"location" : "gr
oup_stream"}]。应该如何解决

0 Answers