为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
– 单独拉出sql查询报错如下
select cast(3 as INT), partition_id, any_value(row_count)
FROM column_statistics WHERE table_id = 12266 GROUP BY partition_id
;
1064 - get_applied_rowsets(version 219) failed tablet:10086 #version:1 [239.1 239.1@0 239.1] #pending:0 backend:
– 按群友范式修复，依然报错
ADMIN SET REPLICA STATUS PROPERTIES(“tablet_id” = “10090”, “backend_id” = “10009”, “status” = “bad”);
ADMIN SET REPLICA STATUS PROPERTIES(“tablet_id” = “10090”, “backend_id” = “10009”, “status” = “ok”);
ADMIN SET REPLICA STATUS PROPERTIES(“tablet_id” = “10094”, “backend_id” = “10009”, “status” = “ok”);
ADMIN SET REPLICA STATUS PROPERTIES(“tablet_id” = “10090”, “backend_id” = “10009”, “status” = “ok”);
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】3.0.4
【集群规模】例如：3fe+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：64C/256G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
日志打印：
Caused by: com.starrocks.sql.analyzer.SemanticException: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [d34c5049-5365-11ee-aab4-0242d1ec9aa8] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 2452983 GROUP BY partition_id]
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:290)
at com.starrocks.statistic.StatisticExecutor.executeStatisticDQL(StatisticExecutor.java:273)
at com.starrocks.statistic.StatisticExecutor.queryTableStats(StatisticExecutor.java:182)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.queryStatisticsData(TableStatsCacheLoader.java:92)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.lambda$asyncLoadAll$1(TableStatsCacheLoader.java:68)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
… 3 more
Sep 15, 2023 9:18:50 AM com.github.benmanes.caffeine.cache.LocalAsyncCache$AsyncBulkCompleter accept
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [d380a6cd-5365-11ee-aab4-0242d1ec9aa8] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 19929 GROUP BY partition_id]
at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1592)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.starrocks.sql.analyzer.SemanticException: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [d380a6cd-5365-11ee-aab4-0242d1ec9aa8] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 19929 GROUP BY partition_id]
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:290)
at com.starrocks.statistic.StatisticExecutor.executeStatisticDQL(StatisticExecutor.java:273)
at com.starrocks.statistic.StatisticExecutor.queryTableStats(StatisticExecutor.java:182)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.queryStatisticsData(TableStatsCacheLoader.java:92)
at com.starrocks.sql.optimizer.statistics.TableStatsCacheLoader.lambda$asyncLoadAll$1(TableStatsCacheLoader.java:68)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
… 3 more
Sep 15, 2023 9:18:50 AM com.github.benmanes.caffeine.cache.LocalAsyncCache$AsyncBulkCompleter accept
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: Statistics query fail | Error Message [INTERNAL_ERROR] | QueryId [d3e1156f-5365-11ee-aab4-0242d1ec9aa8] | SQL [select cast(3 as INT), partition_id, any_value(row_count) FROM column_statistics WHERE table_id = 12266 GROUP BY partition_id]
at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1592)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)fe.out (9.5 MB)