为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.9
- 【问题描述】:
tidb-ligthning导入数据成功,查询tidb和源数据库数据一致,但是checksum失败,local checksum cksum=0
错误如下:
[2021/01/13 14:08:24.975 +08:00] [INFO] [restore.go:1228] [“local checksum”] [table=itask
.task_type
] [checksum="{cksum=0,size=4440,kvs=84}"]
[2021/01/13 14:08:24.975 +08:00] [INFO] [checksum.go:152] [“remote checksum start”] [table=task_type]
[2021/01/13 14:08:24.980 +08:00] [INFO] [checksum.go:155] [“remote checksum completed”] [table=task_type] [takeTime=5.245483ms] []
[2021/01/13 14:08:24.980 +08:00] [ERROR] [restore.go:714] [“restore table failed”] [table=itask
.task_type
] [takeTime=2.117613356s] [error=“restore tableitask
.task_type
failed: checksum mismatched remote vs local => (checksum: 16509697670523592261 vs 0) (total_kvs: 42 vs 84) (total_bytes:2220 vs 4440)”]
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。