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 |
[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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.065 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: rpl_stm_000001 [ pass ] slave not cooperating with mysqladmin, will try manual kill ./mysql-test-run: line 1675: kill: (30444) - No such process slave refused to die. Sending SIGKILL ./mysql-test-run: line 1679: kill: (30444) - No such process Cannot determine thread, fp=0x248f7c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x81d19e3 0xa6a420 0x82df125 0x82dc3be 0x82df125 0x81d5891 0xa25b80 0x97d9ce (gdb) bt #0 0x00a6a402 in __kernel_vsyscall () #1 0x00a2855f in pthread_kill () from /lib/libpthread.so.0 #2 0x082eeb3b in write_core (sig=30444) at stacktrace.c:220 #3 0x081d1a22 in handle_segfault (sig=11) at mysqld.cc:2197 #4 <signal handler called> #5 0x08222e18 in closefrm (table=0x9b80c80, free_share=false) at table.cc:1557 #6 0x0821eebf in close_temporary (table=0x9b80c80, free_share=true, delete_table=false) at sql_base.cc:1460 #7 0x082dc3be in end_relay_log_info (rli=0x9b52bd0) at slave.cc:517 #8 0x082df125 in end_slave () at slave.cc:1414 #9 0x081d5891 in kill_server_thread (arg=0x656444) at mysqld.cc:879 #10 0x00a25b80 in start_thread () from /lib/libpthread.so.0 #11 0x0097d9ce in clone () from /lib/libc.so.6 How to repeat: ./mysql-test-run --force --do-test=rpl