[mysql] 2024/03/06 15:44:41 packets.go:122: closing bad idle connection: EOF [mysql] 2024/03/06 15:44:41 connection.go:173: driver: bad connection

Translated
1

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

Original topic: [mysql] 2024/03/06 15:44:41 packets.go:122: closing bad idle connection: EOF [mysql] 2024/03/06 15:44:41 connection.go:173: driver: bad connection

| username: xingzhenxiang

[TiDB Usage Environment] Production Environment
[TiDB Version]
[Reproduction Path]
[mysql] 2024/03/06 15:44:41 packets.go:122: closing bad idle connection: EOF
[mysql] 2024/03/06 15:44:41 connection.go:173: driver: bad connection
tidb lightning exit successfully
[Encountered Problem: Problem Phenomenon and Impact]
[Resource Configuration] Enter TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]
On the 6th, the following error was reported and did not exit. It exited on the 8th. I don’t know if such an error affects data integrity.

[mysql] 2024/03/06 15:44:41 packets.go:122: closing bad idle connection: EOF
[mysql] 2024/03/06 15:44:41 connection.go:173: driver: bad connection
tidb lightning exit successfully

image
image1650×238 20.8 KB

2
| username: WalterWj | Original post link

If “finished” is true, it should mean that the entire import was successful.

3
| username: xingzhenxiang | Original post link

Thank you for your reply.

4
| username: oceanzhang | Original post link

Success, don’t worry about it, this error can be ignored.

5
| username: redgame | Original post link

Success!

6
| username: TiDBer_ok0VXN1s | Original post link

Disconnected after finishing.

7
| username: Jellybean | Original post link

Are you using the backend method for TiDB? If so, there might be situations where idle connections get disconnected. As long as the final task is completed normally, there shouldn’t be any issues.

After the data import is completed, you can manually perform a data consistency check between the upstream and downstream to confirm that the task is correct.

8
| username: system | Original post link

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