执行sql失败

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【 TiDB 使用环境】
v2.1.8

【概述】 场景 + 问题概述
应用程序调用tidb, 返回错误
“Error 1105: inconsistent extra index rowkey, handle 4330974 not found in table”

查看tidb对应时间点的日志,发现有一些警告信息

[2021/07/17 11:26:32.564 +08:00] [WARN] [conn.go:522] [“dispatch error”] [conn=660485] [connInfo=“id:660485, addr:172.18.116.2:48588 status:2, collation:utf8_general_ci, user:root”] [
sql=“J\u0003\u0000\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0001\ufffd\u0000\ufffd\u0000\ufffd\u0000\u0010nclzrmyy20210209\ufffd8upedloxp6258ryu8c2g_800255/Patient/ZG/511381/800255/
MR/2021/07/17/1.3.12.2.1107.5.2.40.38669.30000021071623535871800000015/index.json\u001416820251681769687496”] [err="[kv:2]inconsistent extra index rowkey, handle 4330956 not found in
table\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ github.com/pingcap/parser/terror.(
*Error).GenWithStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190410113155-72aa33252485/terror/terror.go:226\ngithub.com/pingcap/ti
db/executor.(*PointGetExecutor).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/point_get.go:110\ngithub.com/pingcap/tidb/executor.(*record
Set).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:101\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\ \t/home/jenkins/
workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:353\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/workspace/release_tid
b_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:1047\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.c
om/pingcap/tidb/server/conn.go:1011\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmtExecute\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/serve
r/conn_stmt.go:201\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:671\ngithub.com/
pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:506\ngithub.com/pingcap/tidb/server.(*Server).onConn
\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:384\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1333"]
[2021/07/17 11:26:34.659 +08:00] [WARN] [conn.go:522] [“dispatch error”] [conn=660473] [connInfo=“id:660473, addr:172.18.116.2:46116 status:2, collation:utf8_general_ci, user:root”] [
sql="\ufffd\u0000\u0000\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0001\ufffd\u0000\ufffd\u0000\ufffd\u0000\u0010nclzrmyy20210209\ufffd8upedloxp6258ryu8c2g_800255/Patient/ZG/511381/80
0255/MR/2021/07/17/1.3.12.2.1107.5.2.40.38669.30000021071623535871800000015/index.json\u001416820251686014541645"] [err="[kv:2]inconsistent extra index rowkey, handle 3354476 not foun
d in table\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ github.com/pingcap/parser/ter
ror.(*Error).GenWithStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190410113155-72aa33252485/terror/terror.go:226\ngithub.com/pingc
ap/tidb/executor.(*PointGetExecutor).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/point_get.go:110\ngithub.com/pingcap/tidb/executor.(*r
ecordSet).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:101\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\ \t/home/jen
kins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:353\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/workspace/releas
e_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:1047\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/git
hub.com/pingcap/tidb/server/conn.go:1011\ github.com/pingcap/tidb/server.(*clientConn).handleStmtExecute\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/
server/conn_stmt.go:201\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:671\ github
.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:506\ngithub.com/pingcap/tidb/server.(*Server).o
nConn\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:384\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1333"]
[2021/07/17 11:26:37.779 +08:00] [WARN] [conn.go:522] [“dispatch error”] [conn=660485] [connInfo=“id:660485, addr:172.18.116.2:48588 status:2, collation:utf8_general_ci, user:root”] [
sql="\ufffd\u0003\u0000\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0001\ufffd\u0000\ufffd\u0000\ufffd\u0000\u0010nclzrmyy20210209\ufffd8upedloxp6258ryu8c2g_800255/Patient/ZG/511381/80
0255/MR/2021/07/17/1.3.12.2.1107.5.2.40.38669.30000021071623535871800000015/index.json\u001416820251676836262364"] [err="[kv:2]inconsistent extra index rowkey, handle 4330974 not foun
d in table\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ github.com/pingcap/parser/ter
ror.(*Error).GenWithStack\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/pkg/mod/github.com/pingcap/parser@v0.0.0-20190410113155-72aa33252485/terror/terror.go:226\ngithub.com/pingc
ap/tidb/executor.(*PointGetExecutor).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/point_get.go:110\ngithub.com/pingcap/tidb/executor.(*r
ecordSet).Next\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/adapter.go:101\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\ \t/home/jen
kins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/driver_tidb.go:353\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\ \t/home/jenkins/workspace/releas
e_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:1047\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultset\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/git
hub.com/pingcap/tidb/server/conn.go:1011\ github.com/pingcap/tidb/server.(*clientConn).handleStmtExecute\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/
server/conn_stmt.go:201\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:671\ github
.com/pingcap/tidb/server.(*clientConn).Run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/conn.go:506\ngithub.com/pingcap/tidb/server.(*Server).o
nConn\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/server/server.go:384\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1333"]

谁能帮忙看下,是什么问题,怎么解决比较好,谢谢了

【TiDB 版本】
v2.1.8

【附件】 相关日志及监控(https://metricstool.pingcap.com/)


若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

看一下 官网 :admin table recover 和 cleanup 之类的几个命令

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。