| Bug #34654 | RESET SLAVE and START SLAVE does not clear Last_IO_Errno | ||
|---|---|---|---|
| Submitted: | 19 Feb 6:04 | Modified: | 7 Jun 11:39 |
| Reporter: | Johan Andersson | ||
| Status: | Patch queued | ||
| Category: | Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | Andrei Elkin | Target Version: | 5.1+ |
| Tags: | replication, start slave, stop slave, RESET SLAVE, show slave status | ||
| Triage: | D2 (Serious) | ||
[20 Feb 20:29]
Sveta Smirnova
Thank you for the report. With STOP SLAVE this is not a bug: last error since slave started displayed. RESET SLAVE clears error number and message. So I close the report as "Can't repeat"
[20 Feb 20:45]
Johan Andersson
Interesting.. what version exactly did you use? br johan
[20 Feb 21:40]
Sveta Smirnova
Latest 5.0, 5.1 and 6.0 BK sources.
[6 Mar 15:44]
Andrei Elkin
Susanne, it looks similar to Bug #34492 RESET SLAVE does not reset last_error.
[14 Mar 15:40]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/44005 ChangeSet@1.2579, 2008-03-14 15:42:27+01:00, msvensson@pilot.mysql.com +2 -0 Mask columns 35 and 36 since Last_IO_errno is not reset du to bug#34654
[14 Mar 21:02]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/44040 ChangeSet@1.2582, 2008-03-14 21:02:52+01:00, msvensson@pilot.mysql.com +3 -0 Bug #34654 RESET SLAVE and STOP SLAVE/START SLAVE does not clear Last_XYZ_Errno
[14 Mar 21:05]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/44042 ChangeSet@1.2583, 2008-03-14 21:06:01+01:00, msvensson@pilot.mysql.com +2 -0 Bug#34654 RESET SLAVE and STOP SLAVE/START SLAVE does not clear Last_XYZ_Errno
[1 May 13:33]
Andrei Elkin
Making this one as the parent bugs for others because here has been already some work done.
[1 May 13:35]
Andrei Elkin
know childs: Bug #31393, Bug #34492.
[1 May 15:27]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/46260 ChangeSet@1.2646, 2008-05-01 16:26:05+03:00, aelkin@mysql1000.dsl.inet.fi +5 -0 Bug #34654 RESET SLAVE and START SLAVE does not clear Last_IO_Errno There were no resetting of the io thread's error status at reset_slave() and at the beginning of handle_slave_io() that corresponds to start slave. Fixed with deploying clean-up at necessary places of the code.
[8 May 19:06]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/46525 ChangeSet@1.2646, 2008-05-08 20:05:25+03:00, aelkin@mysql1000.dsl.inet.fi +5 -0 Bug #34654 RESET SLAVE and START SLAVE does not clear Last_IO_Errno There were no resetting of the io thread's error status at reset_slave() and at the beginning of handle_slave_io() that corresponds to start slave. Fixed with deploying clean-up at necessary places of the code.
[7 Jun 11:39]
Andrei Elkin
Pushed to the bzr 6.0-rpl.
Description: RESET SLAVE; and STOP SLAVE; does not clear Last_IO_Errno and Last_IO_Error (the same also applies for Last_SQL_Errno and Last_SQL_Error): Slave_IO_State: Waiting for master to send event Last_Errno: 0 Last_Error: Skip_Counter: 0 Seconds_Behind_Master: 0 ... Last_IO_Errno: 2013 Last_IO_Error: error reconnecting to master 'rep@r2mys-front41:3306' - retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: stop slave; start slave; show slave status \G; Slave_IO_State: Waiting for master to send event -.. Slave_IO_Running: Yes Slave_SQL_Running: Yes ... Seconds_Behind_Master: 0 Last_IO_Errno: 2013 Last_IO_Error: error reconnecting to master 'rep@r2mys-front41:3306' - retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: How to repeat: see above: Have by replication running. kill master restart master show slave status\G stop slave; start slave; show slave status\G Suggested fix: clear errors if it is no longer a problem