doris 3.0.3 创建动态表时一直超时,the report queue size exceeds the limit: 100. current: 101

Viewed 13
2025-04-14 14:13:58,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.checkTimeout():1019] kill query timeout, remote: 127.0.0.1:43550, query timeout: 900000, query id: TUniqueId(hi:-8012880994519660225, lo:-5695146602746461302)
2025-04-14 14:13:58,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.killByTimeout():980] kill time out query, remote: 127.0.0.1:43550, at the same time kill connection is false, connection type: MYSQL, connectionId: 1356
2025-04-14 14:13:59,906 WARN (thrift-server-pool-1|207) [ReportHandler.putToQueue():235] the report queue size exceeds the limit: 100. current: 101
2025-04-14 14:13:59,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.checkTimeout():1019] kill query timeout, remote: 127.0.0.1:43550, query timeout: 900000, query id: TUniqueId(hi:-8012880994519660225, lo:-5695146602746461302)
2025-04-14 14:13:59,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.killByTimeout():980] kill time out query, remote: 127.0.0.1:43550, at the same time kill connection is false, connection type: MYSQL, connectionId: 1356
2025-04-14 14:14:00,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.checkTimeout():1019] kill query timeout, remote: 127.0.0.1:43550, query timeout: 900000, query id: TUniqueId(hi:-8012880994519660225, lo:-5695146602746461302)
2025-04-14 14:14:00,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.killByTimeout():980] kill time out query, remote: 127.0.0.1:43550, at the same time kill connection is false, connection type: MYSQL, connectionId: 1356
2025-04-14 14:14:01,205 INFO (InsertOverwriteDropDirtyPartitions|207) [InsertOverwriteManager.runAfterCatalogReady():368] start clean insert overwrite temp partitions
2025-04-14 14:14:01,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.checkTimeout():1019] kill query timeout, remote: 127.0.0.1:43550, query timeout: 900000, query id: TUniqueId(hi:-8012880994519660225, lo:-5695146602746461302)
2025-04-14 14:14:01,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.killByTimeout():980] kill time out query, remote: 127.0.0.1:43550, at the same time kill connection is false, connection type: MYSQL, connectionId: 1356
2025-04-14 14:14:02,132 WARN (thrift-server-pool-6|207) [ReportHandler.putToQueue():235] the report queue size exceeds the limit: 100. current: 101
2025-04-14 14:14:02,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.checkTimeout():1019] kill query timeout, remote: 127.0.0.1:43550, query timeout: 900000, query id: TUniqueId(hi:-8012880994519660225, lo:-5695146602746461302)
2025-04-14 14:14:02,911 WARN (connect-scheduler-check-timer-0|207) [ConnectContext.killByTimeout():980] kill time out query, remote: 127.0.0.1:43550, at the same time kill connection is false, connection type: MYSQL, connectionId: 1356

一直报这个错误,创建动态表时,版本3.0.3 @haijun @hhj_0530

表结构

-- 创建 dws_user_register_agg_day 表 (配置动态分区)
CREATE TABLE `dws_user_register_agg_day` (
  `dt` date NOT NULL COMMENT '注册日期',
  `user_type` tinyint NULL COMMENT '用户类型: 1个人 2企业',
  `register_province` varchar(255) NULL COMMENT '注册省份',
  `register_city` varchar(255) NULL COMMENT '注册城市',
  `new_register_user_count` bigint SUM DEFAULT "0" COMMENT '每日新增注册用户数'
) ENGINE=OLAP
AGGREGATE KEY(`dt`, `user_type`, `register_province`, `register_city`) -- 定义聚合键,用于后续的聚合操作优化
PARTITION BY RANGE (`dt`) ( -- 按照注册日期进行范围分区
    PARTITION p20250413 VALUES [('2025-04-13'), ('2025-04-14')), -- 定义一个初始分区,Doris会基于此进行动态管理
    PARTITION p20250414 VALUES [('2025-04-14'), ('2025-04-15'))  -- 定义另一个初始分区
)
DISTRIBUTED BY HASH(`dt`, `user_type`, `register_province`, `register_city`) BUCKETS 1 -- 定义分桶策略,提高查询并行度
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.start" = "-90", -- 保留最近 90 天的分区
"dynamic_partition.end" = "7",  -- 预创建未来 7 天的分区
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1"
);
1 Answers

集群有在做其他操作吗,是否经常出现,集群是存算一体还是存算分离版本呢?可以微信(hhj_0530)沟通一下。