Hi, This error indicates that fe failed to send rpc to be. The fe config `remote_fragment_exec_timeout_ms` is 30000, witch is already big enough. So, you can - check if be has exited, - check if there are any network failures occurring, - deduce the query concurrency - or increase the number of be
best regards 450196...@163.com <450196...@163.com> 于2024年2月29日周四 10:44写道： > 您好： > 1、问题描述 > navicat连接doris查询任务在执行过程中偶发报错如下： > 1105 - RpcException, msg: timeout when waiting for send fragments RPc, > Wait(sec): 30 > 2、后续处置 > 修改fe的query_timeout为1800s，修改be节点参数tablet_rowset_stale_sweep_time_sec为600s > 仍然偶发出现1105报错。 > 3、建表语句 > CREATE TABLE `DWA_T_CUS_CK_RESULT_B` ( > `phone_no` varchar(132) NULL COMMENT '模型检出电话号码', > `risklevel_create_time` varchar(135) NULL COMMENT '风险等级标签生成时间', > `modelCode` varchar(120) NULL COMMENT '模型编码', > `model_dtime` varchar(135) NULL COMMENT '模型检出时间', > `source` varchar(110) NULL COMMENT '来源', > `initial_class` varchar(110) NULL COMMENT '初始风险等级', > `initial_score` bigint(20) NULL COMMENT '初始分数', > `aoc_result` varchar(112) NULL COMMENT '外呼结果', > `aoc_score` bigint(20) NULL COMMENT '外呼分数', > `aoc_time` varchar(315) NULL COMMENT '外呼时间', > `final_score` bigint(20) NULL COMMENT '最终分数', > `final_class` varchar(110) NULL COMMENT '最终风险等级', > `is_push` varchar(151) NULL COMMENT '是否推送' > ) ENGINE=OLAP > UNIQUE KEY(`phone_no`, `risklevel_create_time`, `modelCode`, `model_dtime`) > COMMENT 'OLAP' > DISTRIBUTED BY HASH(`phone_no`) BUCKETS 30 > PROPERTIES ( > "replication_allocation" = "tag.location.group_af_center: 3", > "is_being_synced" = "false", > "storage_format" = "V2", > "enable_unique_key_merge_on_write" = "true", > "light_schema_change" = "true", > "disable_auto_compaction" = "false", > "enable_single_replica_compaction" = "false" > ); > 4、查询SQL > select * from > (select "实时计算结果条数" a,count(*) num from ( SELECT *, > ROW_NUMBER() OVER(PARTITION BY phone_no, modelCode, model_dtime > ORDER BY phone_no) AS rn > FROM ( > SELECT * FROM af_dwa.DWA_T_CUS_CK_RESULT_B where model_dtime like > "2024-02-29 08%" > UNION ALL > SELECT * FROM af_dwa.DWA_T_CUS_CK_RESULT_A where model_dtime like > "2024-02-29 08%" > ) ds ) t where rn=1 > union all > select "原始数据条数" a, count(*) num from (select *,ROW_NUMBER() > OVER(PARTITION BY phone_no, modelCode, model_dtime ORDER BY phone_no) AS rn > from af_esd.ESD_T_CUS_MOD_FILTER ) vv where model_dtime like "2024-02-29 > 08%" and rn=1 ) t > 5、版本信息 > Doris:2.0.2 > 6、集群规模 > 5个fe节点、1个observer节点、20个be节点 > > > > 450196...@163.com >
