You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/04/06 08:44:24 UTC
[GitHub] [incubator-doris] compasses opened a new issue #5602: Cannot create table, error info: Failed to find enough host in all backends. need: 1
compasses opened a new issue #5602:
URL: https://github.com/apache/incubator-doris/issues/5602
Hi,
I have one fe and one be, but cannot create table, error is:
ERROR 1064 (HY000): errCode = 2, detailMessage = Failed to find enough host in all backends. need: 1
```
MySQL [test]> CREATE TABLE IF NOT EXISTS `lineorder` ( `lo_orderkey` int(11) NOT NULL COMMENT "", `lo_linenumber` int(11) NOT NULL COMMENT "", `lo_custkey` int(11) NOT NULL COMMENT "", `lo_partkey` int(11) NOT NULL COMMENT "", `lo_suppkey` int(11) NOT NULL COMMENT "", `lo_orderdate` int(11) NOT NULL COMMENT "", `lo_orderpriority` varchar(16) NOT NULL COMMENT "", `lo_shippriority` int(11) NOT NULL COMMENT "", `lo_quantity` int(11) NOT NULL COMMENT "", `lo_extendedprice` int(11) NOT NULL COMMENT "", `lo_ordtotalprice` int(11) NOT NULL COMMENT "", `lo_discount` int(11) NOT NULL COMMENT "", `lo_revenue` int(11) NOT NULL COMMENT "", `lo_supplycost` int(11) NOT NULL COMMENT "", `lo_tax` int(11) NOT NULL COMMENT "", `lo_commitdate` int(11) NOT NULL COMMENT "", `lo_shipmode` varchar(11) NOT NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`lo_orderkey`) COMMENT "OLAP" DISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 192 PROPERTIES ( "replication_num" = "1", "colocat
e_with" = "groupa1", "in_memory" = "false", "storage_format" = "DEFAULT" );
ERROR 1064 (HY000): errCode = 2, detailMessage = Failed to find enough host in all backends. need: 1
MySQL [test]> SHOW PROC '/backends'\G
*************************** 1. row ***************************
BackendId: 10002
Cluster: default_cluster
IP: XXXXXX
HostName: XXXXX
HeartbeatPort: 9050
BePort: 9060
HttpPort: 8040
BrpcPort: 8060
LastStartTime: 2021-04-06 16:32:17
LastHeartbeat: 2021-04-06 16:39:55
Alive: true
SystemDecommissioned: false
ClusterDecommissioned: false
TabletNum: 0
DataUsedCapacity: .000
AvailCapacity: 1.000 B
TotalCapacity: .000
UsedPct: 0.00 %
MaxDiskUsedPct: 0.00 %
ErrMsg:
Version: trunk-a2800c8
Status: {"lastSuccessReportTabletsTime":"N/A"}
1 row in set (0.00 sec)
```
thanks
--
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.
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
[GitHub] [incubator-doris] compasses commented on issue #5602: Cannot create table, error info: Failed to find enough host in all backends. need: 1
Posted by GitBox <gi...@apache.org>.
compasses commented on issue #5602:
URL: https://github.com/apache/incubator-doris/issues/5602#issuecomment-817535751
forget it.
--
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.
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