You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "xingyingone (via GitHub)" <gi...@apache.org> on 2023/12/12 06:00:09 UTC
[I] [Bug] ddl error: The number of BEs that match the policy is insufficient [doris]
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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] ddl error: The number of BEs that match the policy is insufficient [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #28271:
URL: https://github.com/apache/doris/issues/28271#issuecomment-3287228831
We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] ddl error: The number of BEs that match the policy is insufficient [doris]
Posted by "yuanyuan8983 (via GitHub)" <gi...@apache.org>.
yuanyuan8983 commented on issue #28271:
URL: https://github.com/apache/doris/issues/28271#issuecomment-1851423075
The problem has been solved, because all the be specified SSD tag, the default storage medium is still HDD, so this will cause this problem, add "storage_medium" = "ssd" in the properties of the table construction sentence
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] ddl error: The number of BEs that match the policy is insufficient [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #28271: [Bug] ddl error: The number of BEs that match the policy is insufficient
URL: https://github.com/apache/doris/issues/28271
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org