Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: tidb-lightning 导入报错context deadline exceeded
[TiDB Usage Environment] Testing
[TiDB Version] v7.5.0
[Reproduction Path]
[Encountered Issue: Problem Phenomenon and Impact]
Successfully exported MySQL data using tiup dumpling, with a data volume of 900G. However, encountered an error when importing into TiDB using tidb-lightning.
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]
I saw in other posts that this error might be caused by a timeout due to too many tables.
You can also refer to this:
It seems that the timeout was caused by an excessively long operation time. Is there a setting in the server configuration to close the connection after being idle for too long?
It seems that the referenced post didn’t get resolved in the end.
There is no setting, where can I set it?
I looked at other posts again, it might be the timeout caused by having too many tables. Approximately how many tables?
It’s TiDB that’s not working. Post the TiDB architecture; it is very likely an architecture issue.
The image is not visible. Please provide the text you need translated.
Yes, I don’t have much disk space, so I just want to set up one TiKV.
Are you using logical import or physical import?
So that’s physical import. Does it meet these necessary conditions and limitations?
No one uses the database, it’s a new environment, and there’s only one instance of Lightning, with no concurrency.
You can refer to MySQL’s handling method
https://blog.51cto.com/u_16213459/9299744
It seems like the disk is not working. TiKV must use SSD, specifically local SSDs, and cannot use cloud disks. You might have purchased from Alibaba Cloud or Tencent Cloud.
If on the cloud, be sure to pay attention to disk performance. Cloud SSDs do not meet the requirements.
I am using v3700 centralized storage, not solid-state. Can’t it be used if it’s not solid-state?
I’ll give this a try. I’ll increase the timeout settings and see how it goes.