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
   ![image](https://github.com/apache/doris/assets/16775757/b767581f-abb1-4a7c-9780-918023f7e692)
   
   
   ### 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?
   ![image](https://github.com/apache/doris/assets/16775757/2f5797ef-1c39-4823-ab6f-2d1805a68b08)
   
   
   ### 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