Bug #100829 Mysql losts connection querying specific table and records
Submitted: 14 Sep 2020 1:27 Modified: 15 Oct 2020 13:40
Reporter: Alexander Ceballos Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.6.44 OS:Debian (Debian VM Virtual Box)
Assigned to: CPU Architecture:Any

[14 Sep 2020 1:27] Alexander Ceballos
Description:
My problem is the following, I have a database (1.8GB more or less), the version is 5.6.44 running on debian 9, but is a virtual machine mounted with virtual box installed in windows server, some days ago the backups are generating incomplete, then checking the problem I see that is a specific table, that table does not allow to execute queries with specific records and this one interrupts the execution of mysqldump command,this is the message:

ERROR 2013 (HY000): Lost connection to mysql during query.

How to repeat:
mysqldump -u root -p mydb>mydb.sql
result:
mysqldump ERROR 2013: Lost connection to mysql during query when dumping table <my_table> at row: 62563

select * from <my_table> where id_signo_cli=63113 limit 1;
result:
ERROR 2013 (HY000): Lost connection to mysql during query.
[14 Sep 2020 18:21] Justin Swanhart
Check your error log.  Chances are you have a corrupted table and InnoDB is causing the server to crash because the checksum on the page does not match.
[15 Sep 2020 13:40] MySQL Verification Team
Thank you for the bug report. You are using an older 5.6.44 version, try current released version 5.6.49. Your how to repeat instructions are not a repeatable test case, please provide a repeatable test case.
[16 Oct 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".