为了更快的定位您的问题，请提供以下信息，谢谢
【详述】配置完成fe.conf与cn.conf
【背景】统计
【业务影响】
【是否存算分离】是
【StarRocks版本】例如：3.0.8
【集群规模】例如：1fe +1cn（fe与cn单独部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log 2024-01-16 00:06:37,465 INFO (statistics meta manager|21) [StatisticsMetaManager.createSampleStatisticsTable():133] create sample statistics table start
2024-01-16 00:06:37,465 WARN (statistics meta manager|21) [StatisticsMetaManager.refreshStatisticsTable():298] create statistics table table_statistic_v1 failed
2024-01-16 00:06:47,466 INFO (statistics meta manager|21) [StatisticsMetaManager.createSampleStatisticsTable():133] create sample statistics table start
2024-01-16 00:06:47,466 WARN (statistics meta manager|21) [StatisticsMetaManager.refreshStatisticsTable():298] create statistics table table_statistic_v1 failed
2024-01-16 00:06:56,181 INFO (tablet checker|30) [TabletChecker.runAfterCatalogReady():209] TStat :
TStat num of tablet check round: 1191 (+1)
TStat cost of tablet check(ms): 6 (+0)
TStat num of tablet checked in tablet checker: 0 (+0)
2024-01-16 10:00:51,338 INFO (tablet scheduler|29) [TabletScheduler.updateClusterLoadStatistic():480] update cluster load statistic:
2024-01-16 10:00:51,434 INFO (statistics meta manager|21) [StatisticsMetaManager.createSampleStatisticsTable():133] create sample statistics table start
2024-01-16 10:00:51,434 WARN (statistics meta manager|21) [StatisticsMetaManager.refreshStatisticsTable():298] create statistics table table_statistic_v1 failed
id BIGINT COMMENT “range [-2^63 + 1 ~ 2^63 - 1]”,^M
password LARGEINT COMMENT “range [-2^127 + 1 ~ 2^127 - 1]”,^M
name CHAR(20) NOT NULL COMMENT "range char(m),m in (1-255) ",^M
profile VARCHAR(500) NOT NULL COMMENT “upper limit value 65533 bytes”,^M
ispass BOOLEAN COMMENT “true/false”^M
)^M
DUPLICATE KEY(recruit_date, region_num)^M
DISTRIBUTED BY HASH(recruit_date, region_num)^M
PROPERTIES (^M
“enable_storage_cache” = “true”,^M
“storage_cache_ttl” = “2592000”,^M
“enable_async_write_back” = “false”^M
)
process failed.
com.starrocks.common.DdlException: Cluster has no available capacity
at com.starrocks.system.SystemInfoService.checkClusterCapacity(SystemInfoService.java:1055) ~[starrocks-fe.jar:?]
at com.starrocks.server.LocalMetastore.createTable(LocalMetastore.java:823) ~[starrocks-fe.jar:?]
at com.starrocks.server.GlobalStateMgr.createTable(GlobalStateMgr.java:2304) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitCreateTableStatement$4(DDLStmtExecutor.java:236) ~[starrocks-fe.jar:?]
at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:112) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:235) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitCreateTableStatement(DDLStmtExecutor.java:148) ~[starrocks-fe.jar:?]
at com.starrocks.sql.ast.CreateTableStmt.accept(CreateTableStmt.java:272) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:134) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1275) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:581) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:351) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:465) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:741) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_391]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_391]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_391]
2024-01-16 10:00:57,015 INFO (colocate group clone checker|105) [ColocateTableBalancer.matchGroups():901] finished to match colocate group. cost: 0 ms, in lock time: 0 ms
fe.conf配置
http_port = 8030
rpc_port = 9020
query_port = 9030
edit_log_port = 9010
mysql_service_nio_enabled = true
Enable jaeger tracing by setting jaeger_grpc_endpoint
jaeger_grpc_endpoint = http://localhost:14250
Choose one if there are more than one ip except loopback address.
Note that there should at most one ip match this list.
If no ip match this rule, will choose one randomly.
use CIDR format, e.g. 10.10.10.0/24
Default value is empty.
priority_networks = 0.0.0.0/24;
Advanced configurations
log_roll_size_mb = 1024
sys_log_dir = ${STARROCKS_HOME}/log
sys_log_roll_num = 10
sys_log_verbose_modules =
audit_log_dir = ${STARROCKS_HOME}/log
audit_log_modules = slow_query, query
audit_log_roll_num = 10
meta_delay_toleration_second = 10
qe_max_connection = 1024
max_conn_per_user = 100
qe_query_timeout_second = 300
qe_slow_log_ms = 5000
run_mode = shared_data
cloud_native_meta_port = 6090
cloud_native_storage_type = HDFS
cloud_native_hdfs_url = hdfs://hadoop1:8020/starrocks
cn.conf配置
sys_log_level = INFO,WARNING,ERROR
ports for admin, web, heartbeat service
thrift_port = 9060
be_http_port = 8040
heartbeat_service_port = 9050
brpc_port = 8060
Choose one if there are more than one ip except loopback address.
Note that there should at most one ip match this list.
If no ip match this rule, will choose one randomly.
use CIDR format, e.g. 10.10.10.0/24
Default value is empty.
priority_networks = 0.0.0.0/24
storage_root_path = /usr/starrocks/StarRocks-3.0.8/be/storage
starlet_port = 9070