Bug #110651 mysqldump: Error 2013: Lost connection to MySQL server during query when dumping

• Submitted: 10 Apr 2023 20:46
• Modified: 11 Apr 2023 11:56
• Reporter: Bharat Kumar Kilaru
• Status: Unsupported
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.5.62
• OS: Red Hat
• CPU Architecture: Any

[10 Apr 2023 20:46] Bharat Kumar Kilaru

Description:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping
-------------------------------------------------------------------------------

While doing backup we are getting above error.

mysqldump rwsbelk  --skip-extended-insert --compress --quick --lock-tables=false > /var/lib/mysql/dbbackup/reflexis.sql -u root -p

we tried multiple things to increase timeouts/innodb recovery to 1 etc...

But still we are getting same error.

How to repeat:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping
-------------------------------------------------------------------------------

While doing backup we are getting above error.

mysqldump rwsbelk  --skip-extended-insert --compress --quick --lock-tables=false > /var/lib/mysql/dbbackup/reflexis.sql -u root -p

we tried multiple things to increase timeouts/innodb recovery to 1 etc...

But still we are getting same error.

[11 Apr 2023 11:56] MySQL Verification Team

Hi Mr. Kilaru,

Thank you for your bug report.

However, you are using version 5.5, which is not maintained nor supported for the last 10 (ten) years.

If your server is running fine, you should try changing options, like omitting compression, increasing long query time etc .....

In any case that is not a proper bug report, since we can not repeat it with latest version.

Unsupported.