【 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.ttttCHARACTER 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.
请大神协助指引一下,是什么问题引起的,在做同步的时候需要注意什么细节?
