【详述】创建表时报以上错误
【背景】目前是两台虚拟机 一台部署FE和BE节点，另一台只部署BE节点
【业务影响】
【StarRocks版本】例如：2.2.1
修改过 priority_networks
【附件】
- fe.warn.log错误信息
2022-06-12 21:07:56,771 WARN (starrocks-mysql-nio-pool-0|99) [StmtExecutor.handleDdlStmt():934] DDL statement(CREATE TABLE IF NOT EXISTS detailDemo (
recruit_date DATE NOT NULL COMMENT “YYYY-MM-DD”,
region_num TINYINT COMMENT “range [-128, 127]”,
num_plate SMALLINT COMMENT "range [-32768, 32767] ",
tel INT COMMENT “range [-2147483648, 2147483647]”,
id BIGINT COMMENT “range [-2^63 + 1 ~ 2^63 - 1]”,
password LARGEINT COMMENT “range [-2^127 + 1 ~ 2^127 - 1]”,
name CHAR(20) NOT NULL COMMENT "range char(m),m in (1-255) ",
profile VARCHAR(500) NOT NULL COMMENT “upper limit value 65533 bytes”,
hobby STRING NOT NULL COMMENT “upper limit value 65533 bytes”,
leave_time DATETIME COMMENT “YYYY-MM-DD HH:MM:SS”,
channel FLOAT COMMENT “4 bytes”,
income DOUBLE COMMENT “8 bytes”,
account DECIMAL(12,4) COMMENT “”,
ispass BOOLEAN COMMENT “true/false”
) ENGINE=OLAP
DUPLICATE KEY(recruit_date, region_num)
DISTRIBUTED BY HASH(recruit_date, region_num) BUCKETS 8
PROPERTIES (
“replication_num” = “1”
)) process failed.
com.starrocks.common.DdlException: Failed to find enough host in all backends. need: 1
at com.starrocks.catalog.Catalog.chosenBackendIdBySeq(Catalog.java:4954) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createTablets(Catalog.java:4906) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createPartitionCommon(Catalog.java:3691) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createPartition(Catalog.java:3659) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createOlapTable(Catalog.java:4161) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createTable(Catalog.java:3137) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DdlExecutor.execute(DdlExecutor.java:112) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:926) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:445) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:285) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:432) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:668) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_332]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_332]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_332]
mysql> SHOW PROC ‘/backends’\G 截图
