freehao666 opened a new issue, #2288: URL: https://github.com/apache/doris-website/issues/2288
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` <img width="1350" alt="Image" src="https://github.com/user-attachments/assets/e7fd7648-7ddf-4419-85cc-f4c3eef79dd2"; /> `创建 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" );` <img width="1389" alt="Image" src="https://github.com/user-attachments/assets/d531290a-1f11-4f76-a2ff-ba53e6f61ccc"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
