Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.36, 10.0.10
-
None
-
Debian Wheezy AMD64
Description
To reproduce the bug, launch a mysqldump with the --dump-slave option on a server it cannot connect or execute a "SHOW SLAVE STATUS" :
# mysqldump -hunknownhost --dump-slave nulldb
|
mysqldump: Got error: 2005: "Unknown MySQL server host 'unknownhost' (0)" when trying to connect
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
[...]
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
|
Segmentation fault
|
Expected result: It shouldnt try to execute the "SHOW SLAVE STATUS" query as it cannot connect to the server and definitely not go on a loop and segfault.
–
Note: The bug might have appeared since MDEV-5624 has been fixed, i don't recall seeing that issue before 5.5.36 but I might be wrong about that.
The error is the typo:
err:
/* if --dump-slave , start the slave sql thread */
if (opt_slave_data && do_start_slave_sql(mysql))
goto err;
But I don't know what was meant to be done under if, so I'll leave it to serg to fix as initially intended.