You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by "450196086@163.com" <45...@163.com> on 2024/02/29 02:43:40 UTC
查询任务报1105 timeout 问题
您好:
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节点
450196086@163.com
Re: 查询任务报1105 timeout 问题
Posted by Lijia Liu <li...@gmail.com>.
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
450196086@163.com <45...@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节点
>
>
>
> 450196086@163.com
>