最后我将将整个库的每个表都建立一个任务同步，发现其他的表都可以同步。但是有一个表无法同步。报错如上。我怎么感觉数据都过来了，但是6.1.0的版本没有将数据写入库中。我手动将数据拿出来，REPLACE INTO也是可以进入的。很奇怪。2边的表结构都是一致的。我都是源库备份出来的。
[2022/08/28 13:38:24.207 +08:00] [ERROR] [session.go:721] [“assertion failed”] [conn=633048217743695731] [message="[tikv:8141]assertion failed: key: 7480000000000008605f698000000000000001010e2d0e290e290e2aff0f640e8b10510ec1ff0e330f5b0e8b0eb9ff0e4a1002105e0e30ff0e2b0e290e290e32ff0e310e2c0e2d0e2eff0e320e2b0e2a0e2eff0e2d0e2d0e2d0e29ff0e31000000000000f9, assertion: Exist, start_ts: 435595536483483650, existing start ts: 0, existing commit ts: 0"] [“mvcc history”="{“key”:“7480000000000008605F698000000000000001010E2D0E290E290E2AFF0F640E8B10510EC1FF0E330F5B0E8B0EB9FF0E4A1002105E0E30FF0E2B0E290E290E32FF0E310E2C0E2D0E2EFF0E320E2B0E2A0E2EFF0E2D0E2D0E2D0E29FF0E31000000000000F9”,“mvcc”:{“info”:{“writes”:[{“type”:3,“start_ts”:435595533141147649,“commit_ts”:435595533141147649}]}},“regionID”:662985}"] [2022/08/28 13:38:24.207 +08:00] [WARN] [session.go:881] [“can not retry txn”] [conn=633048217743695731] [label=general] [error="[tikv:8141]assertion failed: key: 7480000000000008605f698000000000000001010e2d0e290e290e2aff0f640e8b10510ec1ff0e330f5b0e8b0eb9ff0e4a1002105e0e30ff0e2b0e290e290e32ff0e310e2c0e2d0e2eff0e320e2b0e2a0e2eff0e2d0e2d0e2d0e29ff0e31000000000000f9, assertion: Exist, start_ts: 435595536483483650, existing start ts: 0, existing commit ts: 0"] [IsBatchInsert=false] [IsPessimistic=false] [InRestrictedSQL=false] [tidb_retry_limit=10] [tidb_disable_txn_auto_retry=true] [2022/08/28 13:38:24.207 +08:00] [WARN] [session.go:897] [“commit failed”] [conn=633048217743695731] [“finished txn”=“Txn{state=invalid}”] [error="[tikv:8141]assertion failed: key: 7480000000000008605f698000000000000001010e2d0e290e290e2aff0f640e8b10510ec1ff0e330f5b0e8b0eb9ff0e4a1002105e0e30ff0e2b0e290e290e32ff0e310e2c0e2d0e2eff0e320e2b0e2a0e2eff0e2d0e2d0e2d0e29ff0e31000000000000f9, assertion: Exist, start_ts: 435595536483483650, existing start ts: 0, existing commit ts: 0"] [2022/08/28 13:38:24.207 +08:00] [WARN] [session.go:1941] [“run statement failed”] [conn=633048217743695731] [schemaVersion=903] [error=“previous statement: REPLACE INTO activity_flow_clean.newgamefbty(id,md5,site_id,member_id,venue_id,venue_bill_no,bet_amount,net_amount,valid_bet_amount,bet_time,settle_time,flag,created_at,updated_at) VALUES (4230125943377014874,_binary’4001newgamefbty720322031375090287’,4001,82066823,44,_binary’720322031375090287’,‘99.0000’,’-22.8700’,‘22.8700’,_binary’2022-08-28T13:28:41+08:00’,_binary’2022-08-28T13:32:49+08:00’,1,‘2022-08-28 13:32:34’,‘2022-08-28 13:36:34’),(4230129965713240077,_binary’4001newgamefbty720324875650074229’,4001,1897470,44,_binary’720324875650074229’,‘500.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:34:12+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129965881012277,_binary’4001newgamefbty720322723603023529’,4001,4181247,44,_binary’720322723603023529’,‘98.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:01+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966049439752,_binary’4001newgamefbty720324187448676366’,4001,80020122,44,_binary’720324187448676366’,‘11.3900’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:32:52+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966216556590,_binary’4001newgamefbty720323333488379413’,4001,3011750,44,_binary’720323333488379413’,‘280.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:31:12+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966385639482,_binary’4001newgamefbty720323015660798614’,4001,82425985,44,_binary’720323015660798614’,‘17.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:35+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966720528408,_binary’4001newgamefbty720323886800967224’,4001,4081859,44,_binary’720323886800967224’,‘10.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:32:17+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966726426649,_binary’4001newgamefbty720322994454402865’,4001,82314115,44,_binary’720322994454402865’,‘40.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:33+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’): [tikv:8141]assertion failed: key: 7480000000000008605f698000000000000001010e2d0e290e290e2aff0f640e8b10510ec1ff0e330f5b0e8b0eb9ff0e4a1002105e0e30ff0e2b0e290e290e32ff0e310e2c0e2d0e2eff0e320e2b0e2a0e2eff0e2d0e2d0e2d0e29ff0e31000000000000f9, assertion: Exist, start_ts: 435595536483483650, existing start ts: 0, existing commit ts: 0”] [session="{\
“currDBName”: “”,\
“id”: 633048217743695731,\
“status”: 2,\
“strictMode”: true,\
“user”: {\
“Username”: “dba_tools”,\
“Hostname”: “10.10.11.108”,\
“CurrentUser”: false,\
“AuthUsername”: “dba_tools”,\
“AuthHostname”: “10.%”\
}\
}"] [2022/08/28 13:38:24.207 +08:00] [INFO] [conn.go:1149] [“command dispatched failed”] [conn=633048217743695731] [connInfo=“id:633048217743695731, addr:10.10.11.108:46833 status:10, collation:utf8mb4_general_ci, user:dba_tools”] [command=Query] [status=“inTxn:0, autocommit:1”] [sql=COMMIT] [txn_mode=OPTIMISTIC] [timestamp=435595536483483650] [err="[tikv:8141]assertion failed: key: 7480000000000008605f698000000000000001010e2d0e290e290e2aff0f640e8b10510ec1ff0e330f5b0e8b0eb9ff0e4a1002105e0e30ff0e2b0e290e290e32ff0e310e2c0e2d0e2eff0e320e2b0e2a0e2eff0e2d0e2d0e2d0e29ff0e31000000000000f9, assertion: Exist, start_ts: 435595536483483650, existing start ts: 0, existing commit ts: 0\ngithub.com/pingcap/errors.AddStack\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174\
github.com/pingcap/errors.(*Error).GenWithStackByArgs\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/normalize.go:164\ngithub.com/pingcap/tidb/session.(*session).handleAssertionFailure\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:679\ngithub.com/pingcap/tidb/session.(*session).doCommit\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:622\ngithub.com/pingcap/tidb/session.(*session).doCommitWithRetry\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:861\ngithub.com/pingcap/tidb/session.(*session).CommitTxn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:927\ngithub.com/pingcap/tidb/session.autoCommitAfterStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/tidb.go:280\
github.com/pingcap/tidb/session.finishStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/tidb.go:246\
github.com/pingcap/tidb/session.runStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2080\
github.com/pingcap/tidb/session.(*session).ExecuteStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1938\ngithub.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:230\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2022\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1876\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1371\ngithub.com/pingcap/tidb/server.(*clientConn).Run\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1121\ngithub.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:559\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1571\
previous statement: REPLACE INTO activity_flow_clean.newgamefbty(id,md5,site_id,member_id,venue_id,venue_bill_no,bet_amount,net_amount,valid_bet_amount,bet_time,settle_time,flag,created_at,updated_at) VALUES (4230125943377014874,_binary’4001newgamefbty720322031375090287’,4001,82066823,44,_binary’720322031375090287’,‘99.0000’,’-22.8700’,‘22.8700’,_binary’2022-08-28T13:28:41+08:00’,_binary’2022-08-28T13:32:49+08:00’,1,‘2022-08-28 13:32:34’,‘2022-08-28 13:36:34’),(4230129965713240077,_binary’4001newgamefbty720324875650074229’,4001,1897470,44,_binary’720324875650074229’,‘500.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:34:12+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129965881012277,_binary’4001newgamefbty720322723603023529’,4001,4181247,44,_binary’720322723603023529’,‘98.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:01+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966049439752,_binary’4001newgamefbty720324187448676366’,4001,80020122,44,_binary’720324187448676366’,‘11.3900’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:32:52+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966216556590,_binary’4001newgamefbty720323333488379413’,4001,3011750,44,_binary’720323333488379413’,‘280.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:31:12+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966385639482,_binary’4001newgamefbty720323015660798614’,4001,82425985,44,_binary’720323015660798614’,‘17.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:35+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966720528408,_binary’4001newgamefbty720323886800967224’,4001,4081859,44,_binary’720323886800967224’,‘10.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:32:17+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’),(4230129966726426649,_binary’4001newgamefbty720322994454402865’,4001,82314115,44,_binary’720322994454402865’,‘40.0000’,‘0.0000’,‘0.0000’,_binary’2022-08-28T13:30:33+08:00’,_binary’1900-01-01T00:00:00+08:00’,0,‘2022-08-28 13:36:34’,‘2022-08-28 13:36:34’)"]