【 TiDB 使用环境】线上
【 TiDB 版本】6.1
【遇到的问题】在做mariadbDB10.4.18
【复现路径】做过哪些操作出现的问题
【问题现象及影响】
在做pt-archiver数据同步的时候,一共数据有1.9亿,同步到了1.4亿多的时候,出现了以下报错
DBD::mysql::st execute failed: Error: KV error safe to retry Error(Txn(Error(Mvcc(Error(TxnLockNotFound { start_ts: TimeStamp(434848378955497480), commit_ts: TimeStamp(434848395365449748), key: [116, 128, 0, 0, 0, 0, 0, 1, 1, 95, 105, 128, 0, 0, 0, 0, 0, 0, 1, 1, 14, 96, 14, 44, 14, 109, 14, 41, 255, 14, 47, 14, 51, 14, 51, 14, 139, 255, 2, 33, 14, 139, 14, 74, 14, 185, 255, 14, 74, 2, 33, 14, 42, 14, 42, 255, 14, 139, 14, 96, 2, 33, 14, 49, 255, 14, 139, 14, 45, 14, 48, 2, 33, 255, 14, 74, 14, 45, 14, 41, 14, 46, 255, 14, 46, 14, 109, [for Statement “LOAD DATA LOCAL INFILE ? INTO TABLE dddd
.tttt
CHARACTER SET utf8(id
,amount_code
,group_code
,group_name
,customer_code
,customer_name
,sales_center_code
,sales_center_name
,account_code
,amount
,is_amount_control
,is_discount_control
,tenant_code
,create_time
,created_by
,update_time
,updated_by
,version
,delete_flag
,remark
,freeze_date
,freeze_time
)” with ParamValues: 0=’/tmp/VA7wb2D5FMpt-archiver’] at ./pt-archiver line 6212.
请大神协助指引一下,是什么问题引起的,在做同步的时候需要注意什么细节?