Slave I/O thread won't attempt to automatically reconnect to the master / error-code 1593
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Vlad Lesin | ||
5.1 |
Won't Fix
|
Undecided
|
Vlad Lesin | ||
5.5 |
Fix Released
|
Medium
|
Vlad Lesin | ||
5.6 |
Invalid
|
Undecided
|
Vlad Lesin |
Bug Description
140111 17:02:01 [ERROR] Slave I/O: The slave I/O thread stops because SET @master_
140111 17:02:01 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.015318', position 887067847
The error in question is:
$ perror 1593
MySQL error code 1593 (ER_SLAVE_
Percona Server 5.5.29-29.4 is running on the affected slave. Looking at the source code for that release, the problematic code path appears to be:
1536 if (mysql_
1537 && !check_
1538 {
1539 errmsg= "The slave I/O thread stops because SET @master_
1540 "on master failed.";
1541 err_code= ER_SLAVE_
1542 sprintf(err_buff, "%s Error: %s", errmsg, mysql_error(
1543 mysql_free_
1544 goto err;
1545 }
1546 mysql_free_
I believe this exhibits a bug. Instead of just assuming the error is fatal, it should do "is_network_
Additionally, since there is already an error code from mysql_real_query, should it be later overwritten with ER_SLAVE_
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 204 lines (+141/-11)4 files modifiedmysql-test/suite/rpl/r/rpl_percona_gmvac_net_err.result (+30/-0)
mysql-test/suite/rpl/t/rpl_percona_gmvac_net_err.test (+67/-0)
sql-common/client.c (+6/-0)
sql/slave.cc (+38/-11)
- Laurynas Biveinis (community): Approve
-
Diff: 180 lines (+126/-2)4 files modifiedmysql-test/suite/rpl/r/rpl_percona_gmvac_net_err.result (+33/-0)
mysql-test/suite/rpl/t/rpl_percona_gmvac_net_err.test (+67/-0)
sql-common/client.c (+6/-0)
sql/rpl_slave.cc (+20/-2)
tags: | added: upstream |
Upstream 5.6 fixed by
5.6$ bzr log -r 2661.723.1 ------- ------- ------- ------- ------- ------- ------- ---- checksum
-------
revno: 2661.723.1
committer: Andrei Elkin <email address hidden>
branch nick: rep2-wl2540-
timestamp: Fri 2010-05-28 12:47:19 +0300
message:
wl#2540 replication checksum
intermediate changeset implements the task w/o relying on FD (to be refined by the following patch) as well as with per-event (A) (should be removed from all but FD). The 3rd todo will be correct affected tests because of FD is going to be extended by (A) size of 1 bytte. Finally, merging with fixes for bug#49741 shall complete the show