Bug #17284 | erroneous temp table cleanup on slave | ||
---|---|---|---|
Submitted: | 9 Feb 2006 18:35 | Modified: | 10 Apr 2006 15:25 |
Reporter: | Jonathan Miller | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
Version: | 5.1.7 | OS: | Linux (Linux 32 Bit OS) |
Assigned to: | Andrei Elkin | CPU Architecture: | Any |
[9 Feb 2006 18:35]
Jonathan Miller
[8 Mar 2006 17:46]
Andrei Elkin
Found that the problem is actually in cleaning temp tables in slave sql thread after io thread reconnects to master upon slave_net_timeout elapses. The reason of reconnecting to steady working master is not clear though theater seems to be inside of my_real_read function.
[27 Mar 2006 7:37]
Andrei Elkin
Implementing small extension to slave/master protocol to avoid temp table cleanup by reconnecting slave.
[30 Mar 2006 14:46]
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/4324
[30 Mar 2006 14:54]
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/4325
[30 Mar 2006 15:04]
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/4327
[5 Apr 2006 12:30]
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/4496
[7 Apr 2006 15:19]
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/4650
[7 Apr 2006 17: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/4652
[7 Apr 2006 17:44]
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/4654
[10 Apr 2006 6:30]
Andrei Elkin
Fixed in 5.0.21, 5.1.10-beta.
[10 Apr 2006 15:25]
Paul DuBois
Noted in 5.0.21, 5.1.10 changelogs. Updating a field value when also requesting a lock with <literal>GET_LOCK()</literal> would cause slave servers in a replication environment to terminate. (Bug #17284)
[18 Jul 2008 8:21]
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/50009 2705 Andrei Elkin 2008-07-18 Bug #34647 rpl_temporary discovers more than one dump thread and fails to select Many dump threads can exist due to a way the new version of mtr governs suites. For this immediate problem the test is refined not to use I_S but rather to reconnect explicitly with preserving logics of a an old target bug fixes verification.
[18 Jul 2008 10:06]
Andrei Elkin
changing synopsis to reflect the nature of the bug.