为了更快的定位您的问题,请提供以下信息,谢谢
【详述】fe.out 日志增加异常, 1分钟上G的增加,最大 400GB,不会自动覆盖异常信息如下:
【背景】无
【业务影响】是
【是否存算分离】否
【StarRocks版本】例如:3.2.3
【集群规模】例如:1FE 1BE 容器部署
【机器信息】CPU虚拟核/内存/网卡,32C/64G/万兆
【附件】
- fe.out日志:
May 14, 2024 2:37:09 PM com.github.benmanes.caffeine.cache.LocalAsyncCache lambda$handleCompletion$7
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a81c4d-11bc-11ef-8c27-0242ac110003] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 255023 and partition_id = 388917 GROUP BY partition_id].
at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1702)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a81c4d-11bc-11ef-8c27-0242ac110003] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 255023 and partition_id = 388917 GROUP BY partition_id].
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:342)
at com.starrocks.statistic.StatisticExecutor.executeStatisticDQL(StatisticExecutor.java:324)
at com.starrocks.statistic.StatisticExecutor.queryTableStats(StatisticExecutor.java:218)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.queryStatisticsData(TableStatsCacheLoader.java:100)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.lambda$asyncLoad$0(TableStatsCacheLoader.java:42)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
… 3 more
May 14, 2024 2:37:09 PM com.github.benmanes.caffeine.cache.LocalAsyncCache lambda$handleCompletion$7
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a8b891-11bc-11ef-8c27-0242ac110003] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 255023 and partition_id = 437795 GROUP BY partition_id].
at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1702)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a8b891-11bc-11ef-8c27-0242ac110003] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 255023 and partition_id = 437795 GROUP BY partition_id].
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:342)
at com.starrocks.statistic.StatisticExecutor.executeStatisticDQL(StatisticExecutor.java:324)
at com.starrocks.statistic.StatisticExecutor.queryTableStats(StatisticExecutor.java:218)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.queryStatisticsData(TableStatsCacheLoader.java:100)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.lambda$asyncLoad$0(TableStatsCacheLoader.java:42)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
… 3 more
May 14, 2024 2:37:09 PM com.github.benmanes.caffeine.cache.LocalAsyncCache$AsyncBulkCompleter accept
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a9f112-11bc-11ef-8c27-0242ac110003] | SQL [SELECT cast(1 as INT), now(), db_id, table_id, column_name, sum(row_count), cast(sum(data_size) as bigint), hll_union_agg(ndv), sum(null_count), cast(max(cast(max as bigint(20))) as string), cast(min(cast(min as bigint(20))) as string) FROM column_statistics WHERE table_id = 255023 and column_name = “id” GROUP BY db_id, table_id, column_name UNION ALL SELECT cast(1 as INT), now(), db_id, table_id, column_name, sum(row_count), cast(sum(data_size) as bigint), hll_union_agg(ndv), sum(null_count), cast(max(cast(max as int(11))) as string), cast(min(cast(min as int(11))) as string) FROM column_statistics WHERE table_id = 255023 and column_name = “time_type” GROUP BY db_id, table_id, column_name].
at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1702)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [63a9f112-11bc-11ef-8c27-0242ac110003] | SQL [SELECT cast(1 as INT), now(), db_id, table_id, column_name, sum(row_count), cast(sum(data_size) as bigint), hll_union_agg(ndv), sum(null_count), cast(max(cast(max as bigint(20))) as string), cast(min(cast(min as bigint(20))) as string) FROM column_statistics WHERE table_id = 255023 and column_name = “id” GROUP BY db_id, table_id, column_name UNION ALL SELECT cast(1 as INT), now(), db_id, table_id, column_name, sum(row_count), cast(sum(data_size) as bigint), hll_union_agg(ndv), sum(null_count), cast(max(cast(max as int(11))) as string), cast(min(cast(min as int(11))) as string) FROM column_statistics WHERE table_id = 255023 and column_name = “time_type” GROUP BY db_id, table_id, column_name].
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:342)
at com.starrocks.statistic.StatisticExecutor.executeStatisticDQL(StatisticExecutor.java:324)
at com.starrocks.statistic.StatisticExecutor.queryStatisticSync(StatisticExecutor.java:117)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.queryStatisticsData(ColumnBasicStatsCacheLoader.java:129)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.lambda$asyncLoadAll$1(ColumnBasicStatsCacheLoader.java:93)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
… 3 more