为了更快的定位您的问题，请提供以下信息，谢谢
【详述】安装部署FE节点，启动失败
【背景】
【业务影响】
【是否存算分离】否
【StarRocks版本】例如：3.3.6
【集群规模】一台机器
【机器信息】CPU虚拟核/内存/网卡，例如：8C/4G/万兆
【联系方式】
【附件】
2024-12-10 11:03:38.870+08:00 WARN (Thread-42|87) [TemporaryTableCleaner.runAfterCatalogReady():88] listSessions return error from 172.29.14.112:9020, skip clean temporary tables
org.apache.thrift.TException: java.net.ConnectException: Connection refused
at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:60) ~[starrocks-fe.jar:?]
at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:33) ~[starrocks-fe.jar:?]
at com.starrocks.server.TemporaryTableCleaner.runAfterCatalogReady(TemporaryTableCleaner.java:70) ~[starrocks-fe.jar:?]
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72) ~[starrocks-fe.jar:?]
at com.starrocks.common.util.Daemon.run(Daemon.java:107) ~[starrocks-fe.jar:?]
去172.29.14.112节点确认以下信息：
1、be.conf配置的storage_root_path是什么？
2、启动be进程的用户是什么？
3、storage_root_path目录的用户权限是什么？
这个是be.conf 的配置文件
storage_root_path =/home/mouble/StarRocks/StarRocks/storage
priority_networks=172.29.14.112
JAVA_HOME=/home/mouble/JDK/jdk-23.0.1
启动be的服务是root 用户
赋予storage_root_path 这个权限是 chmod 777 的权限
日志发全点 fe.out fe.log fe.warning
大佬，日志贴出来了，帮我看看，非常感谢
看你指定的是jdk23，必须用jdk11，我也遇到了这个坑，改为jdk11就解决了（或者改用3.2.3版本，就不存在这个问题）
你这个日志显示已经起来了
是连不进去吗
[root@LZQTEST log]# cat fe.log | grep thrift
org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)
2024-12-12 10:13:26.691+08:00 INFO (UNKNOWN 172.29.14.112_9010_1733913637222(-1)|1) [FrontendThriftServer.start():65] thrift server started with port 9020.
没有fe的进程
你能把启动失败的FE的日志都发出来吗
我改成了jdk11 了 还是不行 大哭呀
2024-12-12 10:33:57.635+08:00 WARN (MASTER 172.29.14.112_9010_1733970837153(1)|1) [BDBEnvironment.setupEnvironment():298] failed to setup environment because of UnknownMasterException for the first time, ignore it.
2024-12-12 10:34:02.719+08:00 WARN (UNKNOWN 172.29.14.112_9010_1733970837153(-1)|1) [StateChangeExecutor.notifyNewFETypeTransfer():62] notify new FE type transfer: UNKNOWN
2024-12-12 10:34:02.747+08:00 WARN (RepNode 172.29.14.112_9010_1733970837153(-1)|97) [StateChangeExecutor.notifyNewFETypeTransfer():62] notify new FE type transfer: LEADER
2024-12-12 10:34:03.941+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:34:03.942+08:00 WARN (TableKeeper|111) [TableKeeper.run():67] database not exists: statistics
2024-12-12 10:34:03.942+08:00 WARN (TableKeeper|111) [TableKeeper.run():67] database not exists: statistics
2024-12-12 10:34:03.949+08:00 WARN (PipeScheduler|59) [PipeScheduler.process():67] Successfully recover all pipes
2024-12-12 10:34:03.976+08:00 WARN (Thread-42|65) [TemporaryTableCleaner.runAfterCatalogReady():88] listSessions return error from 172.29.14.112:9020, skip clean temporary tables
org.apache.thrift.TException: java.net.ConnectException: Connection refused (Connection refused)
at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:60)
at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:33)
at com.starrocks.server.TemporaryTableCleaner.runAfterCatalogReady(TemporaryTableCleaner.java:70)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:34:13.941+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:34:23.942+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:34:33.942+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:34:33.943+08:00 WARN (TableKeeper|111) [TableKeeper.run():67] database not exists: statistics
2024-12-12 10:34:33.943+08:00 WARN (TableKeeper|111) [TableKeeper.run():67] database not exists: statistics
2024-12-12 10:34:43.943+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:34:53.943+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:03.944+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:03.956+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.createSampleStatisticsTable():121] Failed to create sample statistics,
com.starrocks.common.NoAliveBackendException: No alive backend
at com.starrocks.common.util.AutoInferUtil.calDefaultReplicationNum(AutoInferUtil.java:31)
at com.starrocks.statistic.StatisticsMetaManager.createSampleStatisticsTable(StatisticsMetaManager.java:104)
at com.starrocks.statistic.StatisticsMetaManager.createTable(StatisticsMetaManager.java:293)
at com.starrocks.statistic.StatisticsMetaManager.refreshStatisticsTable(StatisticsMetaManager.java:310)
at com.starrocks.statistic.StatisticsMetaManager.runAfterCatalogReady(StatisticsMetaManager.java:332)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:03.957+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.refreshStatisticsTable():313] create statistics table table_statistic_v1 failed
2024-12-12 10:35:04.244+08:00 ERROR (TableKeeper|111) [RepoExecutor.executeDDL():125] execute DDL error: CREATE TABLE IF NOT EXISTS statistics.task_run_history (task_id bigint NOT NULL, task_run_id string NOT NULL, create_time datetime NOT NULL, task_name string NOT NULL, task_state STRING NOT NULL, finish_time datetime NOT NULL, expire_time datetime NOT NULL, history_content_json JSON NOT NULL)PRIMARY KEY (task_id, task_run_id, create_time) PARTITION BY date_trunc(‘DAY’, create_time) DISTRIBUTED BY HASH(task_id) BUCKETS 8 PROPERTIES( ‘replication_num’ = ‘1’, ‘partition_live_number’ = ‘7’)
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:04.246+08:00 ERROR (TableKeeper|111) [TableKeeper.run():81] error happens in Keeper: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
java.lang.RuntimeException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:126)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
… 5 more
2024-12-12 10:35:04.258+08:00 ERROR (TableKeeper|111) [RepoExecutor.executeDDL():125] execute DDL error: CREATE TABLE IF NOT EXISTS loads_history (id bigint, label varchar(2048), profile_id varchar(2048), db_name varchar(2048), table_name varchar(2048), user varchar(2048), warehouse varchar(2048), state varchar(2048), progress varchar(2048), type varchar(2048), priority varchar(2048), scan_rows bigint, scan_bytes bigint, filtered_rows bigint, unselected_rows bigint, sink_rows bigint, runtime_details json, create_time datetime, load_start_time datetime, load_commit_time datetime, load_finish_time datetime not null, properties json, error_msg varchar(2048), tracking_sql varchar(2048), rejected_record_path varchar(2048), job_id bigint ) PARTITION BY date_trunc(‘DAY’, load_finish_time) DISTRIBUTED BY HASH(label) BUCKETS 3 PROPERTIES( ‘replication_num’ = ‘1’, ‘partition_live_number’ = ‘30’)
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:04.259+08:00 ERROR (TableKeeper|111) [TableKeeper.run():81] error happens in Keeper: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
java.lang.RuntimeException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:126)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
… 5 more
2024-12-12 10:35:04.270+08:00 ERROR (Load history syncer|47) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
at com.starrocks.sql.common.MetaUtils.getSessionAwareTable(MetaUtils.java:177)
at com.starrocks.sql.StatementPlanner.beginTransaction(StatementPlanner.java:442)
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:101)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDML(RepoExecutor.java:68)
at com.starrocks.load.loadv2.LoadsHistorySyncer.syncData(LoadsHistorySyncer.java:99)
at com.starrocks.load.loadv2.LoadsHistorySyncer.runAfterCatalogReady(LoadsHistorySyncer.java:113)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:04.271+08:00 ERROR (Load history syncer|47) [LoadsHistorySyncer.syncData():101] Failed to sync loads history
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDML(RepoExecutor.java:77)
at com.starrocks.load.loadv2.LoadsHistorySyncer.syncData(LoadsHistorySyncer.java:99)
at com.starrocks.load.loadv2.LoadsHistorySyncer.runAfterCatalogReady(LoadsHistorySyncer.java:113)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
at com.starrocks.sql.common.MetaUtils.getSessionAwareTable(MetaUtils.java:177)
at com.starrocks.sql.StatementPlanner.beginTransaction(StatementPlanner.java:442)
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:101)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDML(RepoExecutor.java:68)
… 4 more
2024-12-12 10:35:13.944+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:13.958+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.createSampleStatisticsTable():121] Failed to create sample statistics,
com.starrocks.common.NoAliveBackendException: No alive backend
at com.starrocks.common.util.AutoInferUtil.calDefaultReplicationNum(AutoInferUtil.java:31)
at com.starrocks.statistic.StatisticsMetaManager.createSampleStatisticsTable(StatisticsMetaManager.java:104)
at com.starrocks.statistic.StatisticsMetaManager.createTable(StatisticsMetaManager.java:293)
at com.starrocks.statistic.StatisticsMetaManager.refreshStatisticsTable(StatisticsMetaManager.java:310)
at com.starrocks.statistic.StatisticsMetaManager.runAfterCatalogReady(StatisticsMetaManager.java:332)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:13.958+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.refreshStatisticsTable():313] create statistics table table_statistic_v1 failed
2024-12-12 10:35:23.945+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:23.959+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.createSampleStatisticsTable():121] Failed to create sample statistics,
com.starrocks.common.NoAliveBackendException: No alive backend
at com.starrocks.common.util.AutoInferUtil.calDefaultReplicationNum(AutoInferUtil.java:31)
at com.starrocks.statistic.StatisticsMetaManager.createSampleStatisticsTable(StatisticsMetaManager.java:104)
at com.starrocks.statistic.StatisticsMetaManager.createTable(StatisticsMetaManager.java:293)
at com.starrocks.statistic.StatisticsMetaManager.refreshStatisticsTable(StatisticsMetaManager.java:310)
at com.starrocks.statistic.StatisticsMetaManager.runAfterCatalogReady(StatisticsMetaManager.java:332)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:23.959+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.refreshStatisticsTable():313] create statistics table table_statistic_v1 failed
2024-12-12 10:35:33.946+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:33.960+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.createSampleStatisticsTable():121] Failed to create sample statistics,
com.starrocks.common.NoAliveBackendException: No alive backend
at com.starrocks.common.util.AutoInferUtil.calDefaultReplicationNum(AutoInferUtil.java:31)
at com.starrocks.statistic.StatisticsMetaManager.createSampleStatisticsTable(StatisticsMetaManager.java:104)
at com.starrocks.statistic.StatisticsMetaManager.createTable(StatisticsMetaManager.java:293)
at com.starrocks.statistic.StatisticsMetaManager.refreshStatisticsTable(StatisticsMetaManager.java:310)
at com.starrocks.statistic.StatisticsMetaManager.runAfterCatalogReady(StatisticsMetaManager.java:332)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:33.961+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.refreshStatisticsTable():313] create statistics table table_statistic_v1 failed
2024-12-12 10:35:34.262+08:00 ERROR (TableKeeper|111) [RepoExecutor.executeDDL():125] execute DDL error: CREATE TABLE IF NOT EXISTS statistics.task_run_history (task_id bigint NOT NULL, task_run_id string NOT NULL, create_time datetime NOT NULL, task_name string NOT NULL, task_state STRING NOT NULL, finish_time datetime NOT NULL, expire_time datetime NOT NULL, history_content_json JSON NOT NULL)PRIMARY KEY (task_id, task_run_id, create_time) PARTITION BY date_trunc(‘DAY’, create_time) DISTRIBUTED BY HASH(task_id) BUCKETS 8 PROPERTIES( ‘replication_num’ = ‘1’, ‘partition_live_number’ = ‘7’)
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:34.263+08:00 ERROR (TableKeeper|111) [TableKeeper.run():81] error happens in Keeper: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
java.lang.RuntimeException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:126)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
… 5 more
2024-12-12 10:35:34.266+08:00 ERROR (TableKeeper|111) [RepoExecutor.executeDDL():125] execute DDL error: CREATE TABLE IF NOT EXISTS loads_history (id bigint, label varchar(2048), profile_id varchar(2048), db_name varchar(2048), table_name varchar(2048), user varchar(2048), warehouse varchar(2048), state varchar(2048), progress varchar(2048), type varchar(2048), priority varchar(2048), scan_rows bigint, scan_bytes bigint, filtered_rows bigint, unselected_rows bigint, sink_rows bigint, runtime_details json, create_time datetime, load_start_time datetime, load_commit_time datetime, load_finish_time datetime not null, properties json, error_msg varchar(2048), tracking_sql varchar(2048), rejected_record_path varchar(2048), job_id bigint ) PARTITION BY date_trunc(‘DAY’, load_finish_time) DISTRIBUTED BY HASH(label) BUCKETS 3 PROPERTIES( ‘replication_num’ = ‘1’, ‘partition_live_number’ = ‘30’)
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:34.267+08:00 ERROR (TableKeeper|111) [TableKeeper.run():81] error happens in Keeper: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
java.lang.RuntimeException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:126)
at com.starrocks.scheduler.history.TableKeeper.createTable(TableKeeper.java:97)
at com.starrocks.scheduler.history.TableKeeper.run(TableKeeper.java:72)
at com.starrocks.scheduler.history.TableKeeper$TableKeeperDaemon.runAfterCatalogReady(TableKeeper.java:233)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Cluster has no available capacity.
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1166)
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:834)
at com.starrocks.server.MetadataMgr.createTable(MetadataMgr.java:304)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:279)
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:118)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:278)
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:187)
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:345)
at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79)
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:173)
at com.starrocks.load.pipe.filelist.RepoExecutor.executeDDL(RepoExecutor.java:121)
… 5 more
2024-12-12 10:35:43.946+08:00 WARN (Routine load task scheduler|52) [RoutineLoadTaskScheduler.process():117] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 16
2024-12-12 10:35:43.961+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.createSampleStatisticsTable():121] Failed to create sample statistics,
com.starrocks.common.NoAliveBackendException: No alive backend
at com.starrocks.common.util.AutoInferUtil.calDefaultReplicationNum(AutoInferUtil.java:31)
at com.starrocks.statistic.StatisticsMetaManager.createSampleStatisticsTable(StatisticsMetaManager.java:104)
at com.starrocks.statistic.StatisticsMetaManager.createTable(StatisticsMetaManager.java:293)
at com.starrocks.statistic.StatisticsMetaManager.refreshStatisticsTable(StatisticsMetaManager.java:310)
at com.starrocks.statistic.StatisticsMetaManager.runAfterCatalogReady(StatisticsMetaManager.java:332)
at com.starrocks.common.util.FrontendDaemon.runOneCycle(FrontendDaemon.java:72)
at com.starrocks.common.util.Daemon.run(Daemon.java:107)
2024-12-12 10:35:43.962+08:00 WARN (statistics meta manager|34) [StatisticsMetaManager.refreshStatisticsTable():313] create statistics table table_statistic_v1 failed
大神 帮我看下发出来了
文件能发吗 fe.log
你是BE没起来还是FE没起来？
be起来了 有进程 成功了 fe起不来
能发下FE的日志文件吗？fe.log