2.1版本安装后创建不了表

Viewed 66

apache-doris-2.1.0-bin-x64 版本

WARN (mysql-nio-pool-0|166) [ConnectProcessor.handleQueryException():335] Process one query failed because.
org.apache.doris.common.UserException: errCode = 2, detailMessage = Timeout
at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:1362) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1626) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1556) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:708) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:660) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:493) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:472) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:265) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:183) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:176) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:205) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:258) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_222]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_222]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_222]
2024-03-29 11:18:02,053 INFO (InsertOverwriteDropDirtyPartitions|59) [InsertOverwriteManager.runAfterCatalogReady():171] start clean insert overwrite temp partitions
2024-03-29 11:18:02,879 INFO (Thread-64|120) [InternalCatalog.createDb():426] create database[__internal_schema] which already exists
2024-03-29 11:18:02,881 INFO (Thread-64|120) [Database.checkDataSizeQuota():345] database[__internal_schema] data quota: left bytes: 1024.000 TB / total: 1024.000 TB
2024-03-29 11:18:02,881 INFO (Thread-64|120) [Database.checkReplicaQuota():356] database[__internal_schema] replica quota: left number: 1073741824 / total: 1073741824
2024-03-29 11:18:02,882 ERROR (Thread-64|120) [SystemInfoService.selectBackendIdsForReplicaCreation():537] failed backend(s) for policy:computeNode=false | query=false | load=false | schedule=true | tags={"location" : "default"} | medium=SSD
2024-03-29 11:18:02,882 WARN (Thread-64|120) [InternalSchemaInitializer.run():77] Statistics storage initiated failed, will try again later
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: SSD
at org.apache.doris.system.SystemInfoService.selectBackendIdsForReplicaCreation(SystemInfoService.java:550) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createTablets(InternalCatalog.java:2928) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createPartitionWithIndices(InternalCatalog.java:1880) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createOlapTable(InternalCatalog.java:2569) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createTable(InternalCatalog.java:1116) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.catalog.InternalSchemaInitializer.createTbl(InternalSchemaInitializer.java:155) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.catalog.InternalSchemaInitializer.run(InternalSchemaInitializer.java:75) ~[doris-fe.jar:1.2-SNAPSHOT]

3 Answers

【问题状态】已处理
【问题处理】一个一个be重新添加解决,之前一起添加会出现如上异常

方便提供一下复现步骤吗

2.1版本,开箱安装后,各节点也正常,
fe日志一直报这个错
[InternalSchemaInitializer.run():77] Statistics storage initiated failed, will try again later
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: SSD
at org.apache.doris.system.SystemInfoService.selectBackendIdsForReplicaCreation(SystemInfoService.java:550) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createTablets(InternalCatalog.java:2928) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createPartitionWithIndices(InternalCatalog.java:1880) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createOlapTable(InternalCatalog.java:2569) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.datasource.InternalCatalog.createTable(InternalCatalog.java:1116) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.catalog.InternalSchemaInitializer.createTbl(InternalSchemaInitializer.java:155) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.catalog.InternalSchemaInitializer.run(InternalSchemaInitializer.java:75) ~[doris-fe.jar:1.2-SNAPSHOT]