Doris建立表報錯Failed to find enough host with storage medium問題解決
Doris create table報錯:
mysql> CREATE TABLE `test` (
-> `id` bigint(11) NOT NULL,
-> `name` varchar(255) DEFAULT NULL,
-> `score` bigint(11) DEFAULT NULL
-> ) ENGINE=olap
-> DISTRIBUTED BY HASH (id) BUCKETS 1
-> PROPERTIES (
-> "storage_medium" = "SSD",
-> "replication_allocation" = "tag.location.default: 1"
-> );
ERROR 1064 (HY000): errCode = 2, detailMessage = Failed to find enough host with storage medium and tag(SSD/{"location" : "default"}) in all backends. need: 1
錯誤原因:根據錯誤提示,是因為be配置檔案裡沒有找到足夠多的 storage medium導致的。
解決方法:
修改be.conf,然後配置多個storage_root_path:
storage_root_path = /data/doris/doris.HDD,50;/root/doris/doris.SSD,1;/root/doris-2
如果目錄不存在,需要手動建立
# mkdir -p /data/doris/doris.HDD
# mkdir -p /root/doris/doris.SSD
# mkdir -p /root/doris-2
重啟be後問題得到解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15498/viewspace-2920904/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PHP報錯getimagesize(): SSL operation failed with code 1問題解決方案PHPAI
- mongodb find報錯怎麼解決MongoDB
- android APK INSTALL_FAILED_INSUFFICIENT_STORAGE 問題AndroidAPKAI
- 解決 Inkscape 報錯 Duplicate 問題
- Mac SSH 連線出現 Host key verification failed. 錯誤解決MacAI
- Doris failed to initialize storage reader. tablet=106408, res=[NOT_IMPLEMENTED_ERROR]to be implementedAIError
- 解決eslint空格報錯等問題EsLint
- 解決Tomcat啟動報錯問題:Failed to destroy end point associated with ProtocolHandler["ajp-nio-8009"]TomcatAIProtocol
- command 'gcc' failed with exit status 1錯誤問題的解決辦法GCAI
- 關於Failed to resolve的問題解決AI
- 安裝vue/cli報錯問題解決Vue
- matplotlib中文報錯問題及解決方案
- "ScrollView can host only one direct child"問題解決View
- 問題解決:TNS-12543: TNS:destination host unreachable
- vscode中Git: host key verification failed的解決辦法VSCodeGitAI
- ssh連線遠端伺服器出現Host key verification failed. lost connection問題的解決伺服器AI
- 使用API28報錯問題及解決API
- 呼叫https介面時報錯:PKIX path building failed 的問題HTTPUIAI
- jquery-weui微信支付報錯問題解決jQueryUI
- 解決vue使用Sass時候的報錯問題Vue
- Delta Magisk root後解決adb的報錯問題
- 解決MMM啟動監控報錯的問題
- 解決element---el-dialog--關閉報錯問題
- 解決MySql報錯:1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server的方法MySqlServer
- IDEA啟動時報Failed to create JVM錯誤的解決IdeaAIJVM
- 解決Spring Boot測試方法Failed to load ApplicationContext問題Spring BootAIAPPContext
- vue-專案中less報錯 Module build failed: TypeError: loaderContext.getResolve is not a function問題解決以及安裝lessVueUIAIErrorContextFunction
- Jenkins報錯'Gradle build daemon disappeared unexpectedly'的問題解決JenkinsGradleUIAPP
- 解決fastjson反序列化時報錯的問題ASTJSON
- 記錄解決HttpServletResponse在引數報錯的問題HTTPServlet
- Uncaught Error: Bootstrap‘s JavaScript requires jQuery報錯問題解決ErrorbootJavaScriptUIjQuery
- imagick使用readImage報錯 Failed to read the file 或者沒有報錯內容的解決方法AI
- SVN報錯“Failed to run the WC DB work queue associated with”解決辦法AI
- NetworkError: Failed to execute 'send' on 'XMLHttpRequest': Failed to load xxxx錯誤解決方法ErrorAIXMLHTTP
- Mac OSX系統homebrew update Fetching failed問題解決方案MacAI
- win7_iis報500.19和500.21錯誤問題解決Win7
- 關於Xcode10中libstdc報錯問題的解決XCode
- 若依框架匯入阿里OSS報錯問題解決方案框架阿里