使用dumpling导出MySQL指定表指定分区的数据后,使用tidb-lightning导入时,一直卡住。请问是什么原因导致的?具体日志如下:
[2021/08/17 12:16:18.366 +08:00] [INFO] [restore.go:1409] [“import and cleanup engine start”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1]
[2021/08/17 12:16:18.366 +08:00] [INFO] [backend.go:327] [“import start”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1] [retryCnt=0]
[2021/08/17 12:17:30.353 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=7.567673228192433] [state=post-processing] []
[2021/08/17 12:17:50.411 +08:00] [INFO] [backend.go:330] [“import completed”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1] [retryCnt=0] [takeTime=1m32.044166027s] []
[2021/08/17 12:17:50.411 +08:00] [INFO] [backend.go:342] [“cleanup start”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1]
[2021/08/17 12:17:50.776 +08:00] [INFO] [backend.go:344] [“cleanup completed”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1] [takeTime=365.14612ms] []
[2021/08/17 12:17:50.776 +08:00] [INFO] [restore.go:1416] [“import and cleanup engine completed”] [engineTag=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
:-1] [engineUUID=3175871d-3f52-5389-8d33-42c7b87ce0c1] [takeTime=1m32.409655916s] []
[2021/08/17 12:17:50.776 +08:00] [INFO] [tidb.go:273] [“alter table auto_increment start”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
] [auto_increment=341567952]
[2021/08/17 12:17:54.203 +08:00] [INFO] [tidb.go:275] [“alter table auto_increment completed”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
] [auto_increment=341567952] [takeTime=3.4270573s] []
[2021/08/17 12:17:54.204 +08:00] [INFO] [restore.go:1109] [“local checksum”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
] [checksum="{cksum=7289430076257367577,size=14574107703,kvs=152476964}"]
[2021/08/17 12:17:54.359 +08:00] [INFO] [restore.go:1483] [“remote checksum start”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
]
[2021/08/17 12:18:10.730 +08:00] [INFO] [restore.go:1497] [“remote checksum completed”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
] [takeTime=16.370584186s] []
[2021/08/17 12:18:32.221 +08:00] [INFO] [restore.go:1446] [“checksum pass”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
] [local="{cksum=7289430076257367577,size=14574107703,kvs=152476964}"]
[2021/08/17 12:18:32.222 +08:00] [INFO] [restore.go:1451] [“analyze start”] [table=lqcv_analysis
.lqcv_distribute_speed_rpm_interval
]
[2021/08/17 12:22:30.359 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=5.675731591520226] [state=post-processing] []
[2021/08/17 12:27:30.352 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=4.540612777774897] [state=post-processing] []
[2021/08/17 12:32:30.364 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=3.7838200135634175] [state=post-processing] []
[2021/08/17 12:37:30.355 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=3.243291278598113] [state=post-processing] []
[2021/08/17 12:42:30.354 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=2.8378809956098703] [state=post-processing] []
[2021/08/17 12:47:30.362 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=2.522553551647636] [state=post-processing] []
[2021/08/17 12:52:30.355 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=2.2703044344160492] [state=post-processing] []
[2021/08/17 12:57:30.361 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=2.0639096991516532] [state=post-processing] []
[2021/08/17 13:02:30.400 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.8918971830285196] [state=post-processing] []
[2021/08/17 13:07:30.354 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.7463892278329525] [state=post-processing] []
[2021/08/17 13:12:30.353 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.6216478064396633] [state=post-processing] []
[2021/08/17 13:17:30.351 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.5135383613189966] [state=post-processing] []
[2021/08/17 13:22:30.353 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.418941717402689] [state=post-processing] []
[2021/08/17 13:27:30.354 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.335474395955742] [state=post-processing] []
[2021/08/17 13:32:30.356 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.2612809606678184] [state=post-processing] []
[2021/08/17 13:37:30.470 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.194873790149806] [state=post-processing] []
[2021/08/17 13:42:30.354 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.1351533580336057] [state=post-processing] []
[2021/08/17 13:47:30.354 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.0810984840998163] [state=post-processing] []
[2021/08/17 13:52:30.353 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=1.0319577400862627] [state=post-processing] []
[2021/08/17 13:57:30.353 +08:00] [INFO] [restore.go:508] [progress] [files=“21/21 (100.0%)”] [tables=“0/14 (0.0%)”] [speed(MiB/s)=0.9870900320004632] [state=post-processing]