Doris启动后，FE一直提示关于DynamicPartitionScheduler的ERROR和WARN

Question

Doris集群可以正常使用，当时一直WARNNING，有办法解决么？

报错内容：

2025-02-26 10:27:55,762 ERROR (InternalSchemaInitializer|199) [SystemInfoService.selectBackendIdsForReplicaCreation():538] failed backend(s) for policy: computeNode=false | query=false | load=false | schedule=true | tags={"location" : "default"} | medium=HDD real medium HDD
2025-02-26 10:27:55,762 WARN (InternalSchemaInitializer|199) [DynamicPartitionScheduler.executeDynamicPartition():616] has error
org.apache.doris.common.DdlException: errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends.
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: HDD
        at org.apache.doris.system.SystemInfoService.selectBackendIdsForReplicaCreation(SystemInfoService.java:551) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createTablets(InternalCatalog.java:3156) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createPartitionWithIndices(InternalCatalog.java:1995) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.addPartition(InternalCatalog.java:1675) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.Env.addPartition(Env.java:3166) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.clone.DynamicPartitionScheduler.executeDynamicPartition(DynamicPartitionScheduler.java:612) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.clone.DynamicPartitionScheduler.executeDynamicPartitionFirstTime(DynamicPartitionScheduler.java:107) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createOlapTable(InternalCatalog.java:2951) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createTable(InternalCatalog.java:1173) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.InternalSchemaInitializer.createTbl(InternalSchemaInitializer.java:163) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.InternalSchemaInitializer.run(InternalSchemaInitializer.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
2025-02-26 10:27:55,763 WARN (InternalSchemaInitializer|199) [InternalCatalog.createOlapTable():2964] create table failed [] - errCode = 2, detailMessage = errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends.
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: HDD
2025-02-26 10:27:55,763 WARN (InternalSchemaInitializer|199) [InternalSchemaInitializer.run():82] Statistics storage initiated failed, will try again later
org.apache.doris.common.DdlException: errCode = 2, detailMessage = errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends.
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: HDD
        at org.apache.doris.clone.DynamicPartitionScheduler.executeDynamicPartition(DynamicPartitionScheduler.java:618) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.clone.DynamicPartitionScheduler.executeDynamicPartitionFirstTime(DynamicPartitionScheduler.java:107) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createOlapTable(InternalCatalog.java:2951) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.datasource.InternalCatalog.createTable(InternalCatalog.java:1173) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.InternalSchemaInitializer.createTbl(InternalSchemaInitializer.java:163) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.InternalSchemaInitializer.run(InternalSchemaInitializer.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]

部署情况：
1FE 2BE。均只配置了SSD地址，没有配置HDD地址。

经检查，所有自建表的Properties均指定了存储在SSD。

通过SHOW-DYNAMIC-PARTITION检查所有库表，没有动态分区的表。

其它信息：
Doris版本：2.1.6

黄海军@SelectDB · Answer

麻烦提供下表结构和be.conf storage_root_path配置

____ · Answer

表结构：

CREATE TABLE tb_xxx (xxx)
DUPLICATE KEY (`yyy`)
COMMENT "XXX字段数据"
AUTO PARTITION BY RANGE (date_trunc(beg_time, 'day')) (
)
DISTRIBUTED BY RANDOM BUCKETS AUTO
properties(
    "replication_allocation" = "tag.location.default: 1",
    "storage_medium" = "ssd"
);

be.conf：

storage_root_path=/mnt/xxx1/doris-data,medium:SSD;/mnt/xxx2/doris-data,medium:SSD

Doris启动后，FE一直提示关于DynamicPartitionScheduler的ERROR和WARN

2 Answers