Path:/zh-CN/docs/2.0/faq/data-faq
doris version 3.0.3
今天上班时开始创建一个动态分区表时，出现一直等待创建中，一直卡着，所有的创建表操作都不可以，把这写query id kill了，也是不可以；最后重启doris服务才可以的。
【
When I started to create a dynamic partition table at work today, it kept waiting for creation and was stuck. All table creation operations were unavailable. Killing the query ID also failed. Finally, I had to restart the doris service to get it to work.
】
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
创建 dws_user_register_agg_day 表 (配置动态分区) CREATE TABLE dws_user_register_agg_day(dtdate NOT NULL COMMENT '注册日期',user_typetinyint NULL COMMENT '用户类型: 1个人 2企业',register_provincevarchar(255) NULL COMMENT '注册省份',register_cityvarchar(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" );
Path:/zh-CN/docs/2.0/faq/data-faq
doris version 3.0.3
今天上班时开始创建一个动态分区表时，出现一直等待创建中，一直卡着，所有的创建表操作都不可以，把这写query id kill了，也是不可以；最后重启doris服务才可以的。
【
When I started to create a dynamic partition table at work today, it kept waiting for creation and was stuck. All table creation operations were unavailable. Killing the query ID also failed. Finally, I had to restart the doris service to get it to work.
】
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创建 dws_user_register_agg_day 表 (配置动态分区) CREATE TABLEdws_user_register_agg_day(dtdate NOT NULL COMMENT '注册日期',user_typetinyint NULL COMMENT '用户类型: 1个人 2企业',register_provincevarchar(255) NULL COMMENT '注册省份',register_cityvarchar(255) NULL COMMENT '注册城市',new_register_user_countbigint 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" );