为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:3.0.2
- 【问题描述】:程序sql执行报错
Cause: java.sql.SQLException: Error: KV error safe to retry tikv restarts txn: Txn(Mvcc(TxnLockNotFound { start_ts: 412696223608995842, commit_ts: 412696243820298247, key: [116, 128, 0, 0, 0, 0, 4, 254, 32, 95, 105, 128, 0, 0, 0, 0, 0, 0, 1, 3, 128, 0, 0, 0, 93, 214, 16, 112, 3, 128, 0, 0, 0, 0, 0, 12, 214, 3, 128, 0, 0, 0, 0, 0, 1, 25, 3, 128, 0, 0, 0, 0, 16, 216, 50] })) [try again later]
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1105]; Error: KV error safe to retry tikv restarts txn: Txn(Mvcc(TxnLockNotFound { start_ts: 412696223608995842, commit_ts: 412696243820298247, key: [116, 128, 0, 0, 0, 0, 4, 254, 32, 95, 105, 128, 0, 0, 0, 0, 0, 0, 1, 3, 128, 0, 0, 0, 93, 214, 16, 112, 3, 128, 0, 0, 0, 0, 0, 12, 214, 3, 128, 0, 0, 0, 0, 0, 1, 25, 3, 128, 0, 0, 0, 0, 16, 216, 50] })) [try again later]; nested exception is java.sql.SQLException: Error: KV error safe to retry tikv restarts txn: Txn(Mvcc(TxnLockNotFound { start_ts: 412696223608995842, commit_ts: 412696243820298247, key: [116, 128, 0, 0, 0, 0, 4, 254, 32, 95, 105, 128, 0, 0, 0, 0, 0, 0, 1, 3, 128, 0, 0, 0, 93, 214, 16, 112, 3, 128, 0, 0, 0, 0, 0, 12, 214, 3, 128, 0, 0, 0, 0, 0, 1, 25, 3, 128, 0, 0, 0, 0, 16, 216, 50] })) [try again later] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy79.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at com.sun.proxy.$Proxy80.insertMinClickTmp(Unknown Source)
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。