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:
None 
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
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
[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.