Error During Lightning Import

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: lightning导入报错

| username: 胡杨树旁

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]
When using Lightning to import data, an error was found in the query log. However, since the individual file being restored is relatively large, about 50GB, the specific error information is as follows:

| username: tidb菜鸟一只 | Original post link

Check if there is an issue with the corresponding file location or data?

| username: ohammer | Original post link

It looks like there is a syntax error. What version is the export database? It is recommended to export and import the insurance_order table separately.

| username: 胡杨树旁 | Original post link

The file is about 50G. I don’t know how to find the indicated error. Can I filter for EOF?

| username: 胡杨树旁 | Original post link

The version of the exported database is 4.0.8, and several files were exported at the same time. The other files did not report any errors when imported with Lightning, only this file did. It doesn’t seem to be a version issue.

| username: xingzhenxiang | Original post link

Is there any issue with the disk on the server where lighting is located, or is it full? I have encountered a situation before where the file was too large, and there wasn’t enough space after parsing.

| username: 胡杨树旁 | Original post link

Disk space is normal.

| username: xingzhenxiang | Original post link

I only encountered this problem in practice, sorry about that.

| username: ohammer | Original post link

How about exporting this table separately and then importing it?

| username: ffeenn | Original post link

The image is not visible. Please provide the text you need translated.

| username: 胡杨树旁 | Original post link

I saw this error message, but I don’t know how to find the specific location :joy:

| username: ffeenn | Original post link

Execute the command :goto with the offset position in vim.

| username: 胡杨树旁 | Original post link

Okay, I’ll give it a try.

| username: Lucien-卢西恩 | Original post link

How is the progress now? Are there any issues?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.