tidb查询数据报错 region not found for key

[Billdi表弟]

【 TiDB 使用环境】Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题：问题现象及影响】
【资源配置】
【附件：截图/日志/监控】

[2023/02/28 23:27:09.335 +08:00] [WARN] [backoff.go:158] [“pdRPC backoffer.maxSleep 10000ms is exceeded, errors:\nregion not found for key "74800000000000010F5F69800000000000000801616D617A6F6E2E63FF6F6D000000000000F901423037324B314C4EFF4E59000000000000F90419AF3B76B9000001" at 2023-02-28T23:27:01.850892429+08:00\nregion not found for key "74800000000000010F5F69800000000000000801616D617A6F6E2E63FF6F6D000000000000F901423037324B314C4EFF4E59000000000000F90419AF3B76B9000001" at 2023-02-28T23:27:04.062178169+08:00\nregion not found for key "74800000000000010F5F69800000000000000801616D617A6F6E2E63FF6F6D000000000000F901423037324B314C4EFF4E59000000000000F90419AF3B76B9000001" at 2023-02-28T23:27:06.44840141+08:00\nlongest sleep type: pdRPC, time: 11832ms”]

[tidb狂热爱好者]

region 丢失了 查找region丢失的处理方案

[Billdi表弟]

我用pd-ctl region key 找到了region_id 168937，怎么删除尼？

[wzf0072]

https://docs.pingcap.com/zh/tidb/dev/online-unsafe-recovery

[h5n1]

试试 清理PD的region cache，可能有风险

curl -X DELETE http://${HostIP}:2379/pd/api/v1/admin/cache/region/{region_id}

[tidb菜鸟一只 (小菜一颗)]

你的tikv节点挂了吗？挂了几个？

[Billdi表弟]

挂了一个

[Billdi表弟]

大佬的帖子，解决问了，索引最后进行了重建