【详述】failed to get tablet. tablet_id=10160, with schema_hash=1612420876, reason=tablet does not exist backend:10.3.xx.xx
【背景】创建hive(textfile) resource外部表后，查询卡住，导致FE节点宕机，并且一直启动不成功
【业务影响】
【StarRocks版本】 2.5.3
【集群规模】：混部：3FE+3BE
【机器信息】64C/256G/万兆
【联系方式】社区微信群13-唐老鸭
FE.log
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/bigdata/apps/StarRocks-2.5.3/fe/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/bigdata/apps/StarRocks-2.5.3/fe/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/bigdata/apps/StarRocks-2.5.3/fe/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Reload4jLoggerFactory]
[2023-05-12 16:35:14] notify new FE type transfer: UNKNOWN
[2023-05-12 16:35:14] notify new FE type transfer: FOLLOWER
log4j:WARN No appenders could be found for logger (velocity).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
May 12, 2023 4:35:21 PM com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy proxy
INFO: Use global share channel pool to create protobuf RPC proxy with interface interface com.starrocks.rpc.PBackendService
May 12, 2023 4:35:23 PM com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy proxy
INFO: Use global share channel pool to create protobuf RPC proxy with interface interface com.starrocks.rpc.PBackendService
May 12, 2023 4:35:23 PM com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy proxy
INFO: Use global share channel pool to create protobuf RPC proxy with interface interface com.starrocks.rpc.PBackendService
May 12, 2023 4:35:24 PM com.github.benmanes.caffeine.cache.LocalAsyncCache$AsyncBulkCompleter accept
WARNING: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: failed to get tablet. tablet_id=10160, with schema_hash=1612420876, reason=tablet does not exist backend:10.3.138.62
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.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1582)
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
Caused by: com.starrocks.sql.analyzer.SemanticException: failed to get tablet. tablet_id=10160, with schema_hash=1612420876, reason=tablet does not exist backend:10.3.138.62
at com.starrocks.statistic.StatisticExecutor.executeDQL(StatisticExecutor.java:243)
at com.starrocks.statistic.StatisticExecutor.queryStatisticSync(StatisticExecutor.java:83)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.queryStatisticsData(ColumnBasicStatsCacheLoader.java:111)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.lambda$asyncLoadAll$1(ColumnBasicStatsCacheLoader.java:77)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
… 5 more
这个你用catalog方式创建外表吧？别用resource的模式？
通过resource创建的呢
这个我们后面就放弃了，不再支持了
java.util.concurrent.CompletionException: com.starrocks.sql.analyzer.SemanticException: failed to get tablet. tablet_id=10160, with schema_hash=1612420876, reason=tablet does not exist backend:10.3.138.62
以上报错日志情况，是不是表明数据在BE上已经不存在，但是FE元数据还有记录，有什么方式可以将该tablet进行删除，我使用"ADMIN SET REPLICA STATUS PROPERTIES" 方式删除不了该tablet
请问解决了吗，我也遇到了
请问hive catalog如何创建外表呢，hive catalog文档只有create table没有create external table
SR 3.3.1