xingyingone opened a new issue, #28271: URL: https://github.com/apache/doris/issues/28271
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.3 ### What's Wrong? error occuers when create tableļ¼ MySQL [test]> CREATE TABLE `dorismonitor1` ( -> `id` largeint(40) NOT NULL, UNIQUE KEY(`id`) -> `register_time` datetime NULL DEFAULT CURRENT_TIMESTAMP -> ) ENGINE=OLAP -> UNIQUE KEY(`id`) -> COMMENT 'OLAP' -> DISTRIBUTED BY HASH(`id`) BUCKETS 1 -> PROPERTIES ( -> "replication_allocation" = "tag.location.default: 1" -> ); ERROR 1105 (HY000): errCode = 2, detailMessage = The number of BEs that match the policy is insufficient 1. select is ok 2. all be alive , and storage is enough 3. ever use s3 to cooldown storage, but not use the storage policy now MySQL [test]> show storage policy; +-------------+-------+---------+---------+-----------------+------------------+-------------+ | PolicyName | Id | Version | Type | StorageResource | CooldownDatetime | CooldownTtl | +-------------+-------+---------+---------+-----------------+------------------+-------------+ | test_policy | 12025 | 1 | STORAGE | remote_s3 | -1 | 86400 | +-------------+-------+---------+---------+-----------------+------------------+-------------+ 1 row in set (0.00 sec) 4. be.conf be_port = 9060 webserver_port = 8040 heartbeat_service_port = 9050 brpc_port = 8060 storage_root_path = /data/ssd/1/ne-doris-dev/doris/storage,medium:SSD;/data/ssd/2/ne-doris-dev/doris/storage,medium:SSD;/data/ssd/3/ne-doris-dev/doris/storage,medium:SSD priority_networks = 10.198.41.0/24 JAVA_HOME = /data/ssd/1/ne-doris-dev/doris/java8 write_buffer_size=1073741824 max_tablet_version_num=20000 max_cumu_compaction_threads=24 enable_write_index_searcher_cache=false disable_storage_page_cache=true 5. be error log  ### What You Expected? ok to create table ### How to Reproduce? I don"t known ### Anything Else? maybe something unexpected which lead to no suitable tablet?  ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
