com.starrocks.common.AnalysisException: index[perf-lun_20250307-000100_1m] 's properties not found for the ES
详细错误日志如下:
2025-03-07 10:57:47.467+08:00 INFO (colocate group clone checker|219) [ColocateTableBalancer.matchGroups():939] finished to match colocate group. cost: 0 ms, in lock time: 0 ms 2025-03-07 10:57:54.337+08:00 INFO (starrocks-mysql-nio-pool-19|95245) [MetadataMgr$QueryMetadatas.getConnectorMetadata():109] Succeed to register query level connector metadata [catalog:es_default, queryId: f73d2a22-faff-11ef-afdf-da6b0a8e6ed2] 2025-03-07 10:57:54.454+08:00 ERROR (starrocks-mysql-nio-pool-19|95245) [ElasticsearchMetadata.toEsTable():94] transform to EsTable Error com.starrocks.common.AnalysisException: index[perf-lun_20250307-000100_1m] 's properties not found for the ES at com.starrocks.connector.elasticsearch.EsUtil.parseProperties(EsUtil.java:200) ~[starrocks-fe.jar:?] at com.starrocks.connector.elasticsearch.EsUtil.convertColumnSchema(EsUtil.java:114) ~[starrocks-fe.jar:?] at com.starrocks.connector.elasticsearch.ElasticsearchMetadata.toEsTable(ElasticsearchMetadata.java:83) ~[starrocks-fe.jar:?] at com.starrocks.connector.elasticsearch.ElasticsearchMetadata.getTable(ElasticsearchMetadata.java:76) ~[starrocks-fe.jar:?] at com.starrocks.connector.CatalogConnectorMetadata.getTable(CatalogConnectorMetadata.java:135) ~[starrocks-fe.jar:?] at com.starrocks.server.MetadataMgr.lambda$getTable$5(MetadataMgr.java:497) ~[starrocks-fe.jar:?] at java.util.Optional.map(Optional.java:265) ~[?:?] at com.starrocks.server.MetadataMgr.getTable(MetadataMgr.java:497) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer.resolveTable(QueryAnalyzer.java:1391) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.resolveTableRef(QueryAnalyzer.java:482) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.visitSelect(QueryAnalyzer.java:363) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.visitSelect(QueryAnalyzer.java:283) ~[starrocks-fe.jar:?] at com.starrocks.sql.ast.SelectRelation.accept(SelectRelation.java:232) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.process(QueryAnalyzer.java:288) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.visitQueryRelation(QueryAnalyzer.java:303) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.visitQueryStatement(QueryAnalyzer.java:293) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.visitQueryStatement(QueryAnalyzer.java:283) ~[starrocks-fe.jar:?] at com.starrocks.sql.ast.QueryStatement.accept(QueryStatement.java:70) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer$Visitor.process(QueryAnalyzer.java:288) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.QueryAnalyzer.analyze(QueryAnalyzer.java:121) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.Analyzer$AnalyzerVisitor.visitQueryStatement(Analyzer.java:445) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.Analyzer$AnalyzerVisitor.visitQueryStatement(Analyzer.java:175) ~[starrocks-fe.jar:?] at com.starrocks.sql.ast.QueryStatement.accept(QueryStatement.java:70) ~[starrocks-fe.jar:?] at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79) ~[starrocks-fe.jar:?] at com.starrocks.sql.analyzer.Analyzer.analyze(Analyzer.java:172) ~[starrocks-fe.jar:?] at com.starrocks.sql.StatementPlanner.analyzeStatement(StatementPlanner.java:191) ~[starrocks-fe.jar:?] at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:113) ~[starrocks-fe.jar:?] at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:92) ~[starrocks-fe.jar:?] at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:553) ~[starrocks-fe.jar:?] at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:366) ~[starrocks-fe.jar:?] at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:565) ~[starrocks-fe.jar:?] at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:903) ~[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:1128) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?] at java.lang.Thread.run(Thread.java:829) ~[?:?] 2025-03-07 10:57:54.456+08:00 INFO (starrocks-mysql-nio-pool-19|95245) [MetadataMgr.removeQueryMetadata():200] Succeed to deregister query level connector metadata on query id: Optional[f73d2a22-faff-11ef-afdf-da6b0a8e6ed2] 2025-03-07 10:57:54.456+08:00 INFO (starrocks-mysql-nio-pool-19|95245) [StmtExecutor.execute():749] execute Exception, sql: /* ApplicationName=DBeaver 25.0.0 - SQLEditor <Script-33.sql> */ select * fromperf-lun_20250307-000100_1m`
LIMIT 0, 200, error: Getting analyzing error. Detail message: Unknown table ‘default_db.perf-lun_20250307-000100_1m’.
^C
`