Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: lightning导入数据不一致
When importing with Lightning, one table had one more row than the original table. Deleting this table in the target database and re-importing it resolved the issue, and the data became consistent. Why is this happening? There were no errors reported in the logs.
Was the second import done using the same file as the first import?
What import mode was used?
The import mode is logical import.
Are you sure there are no other writes during the import?
Is it a reproducible operation? There’s no way to troubleshoot like this.
Is there any specific information, or can this kind of operation be reproduced?
Cannot reproduce it anymore.
It can no longer be reproduced.
Was the table a temporal table when you imported it for the first time?
What is the extra data after the first import, and is it the same as the data in the original table when compared?
Are the system language environment variables consistent when importing?
Did you check if the target table had data before importing? This situation can occur when using logical import.
You can try verifying it a few more times. If there is indeed no more data, it is likely that the data was written incorrectly.