Bug #31582 5.1-telco-6.1 -> 5.1.22. Slave crashes when reading UPDATE for VARCHAR
Submitted: 13 Oct 2007 16:17 Modified: 5 Dec 2007 20:07
Reporter: Serge Kozlov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.1.22 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: replication, telco, upgrade, version

[13 Oct 2007 16:17] Serge Kozlov
Description:
There are master 5.1-telco-6.1 and slave 5.1.22 with row-based
replication. Slave crashes during reading the event contains UPDATE for VARCHAR column.

How to repeat:
1. Install mysql 5.1.22 
2. Install mysql 5.1-telco-6.1
3. Copy m4r.pl (patched mtr) into 5.1.22/mysql-test 
4. Copy attached test case into 5.1.22/mysql-test/suite/bug/t/
5. Set current dir 5.1.22/mysql-test 
6. Try to create result file for test case:
./m4r22.pl --master-basedir=/path/to/5.1-telco-6.1 --suite=bugs
--record
--mysqld=--binlog-format=row <test case>
[13 Oct 2007 16:17] Serge Kozlov
testcase

Attachment: bug31582.tgz (application/x-compressed, text), 35.04 KiB.

[29 Oct 2007 7:16] Serge Kozlov
trace file:

#0  0x002cd402 in __kernel_vsyscall ()
#1  0x0046164f in ?? ()
#2  0x0000000b in ?? ()
#3  0x00000004 in ?? ()
#4  0xb73c0f48 in ?? ()
#5  0x0835ee7b in init_relay_log_info (rli=0xb73c1bb0,
    info_fname=0xb <Address 0xb out of bounds>) at rpl_rli.cc:287
#6  0x0835ee7b in init_relay_log_info (rli=0xb,
    info_fname=0x1 <Address 0x1 out of bounds>) at rpl_rli.cc:287
#7  0x08221250 in __static_initialization_and_destruction_0 (__initialize_p=Vari
able "__initialize_p" is not available.
)
    at set_var.h:54
#8  <signal handler called>
#9  0x082e9eea in filesort (thd=0xa119298, table=0xa172c98, sortorder=0x1,
    s_length=169294888, select=0xa154f08, max_rows=18318413474562068,
    sort_positions=64, examined_rows=0xa172d18) at filesort.cc:549
#10 0x082e8a50 in merge_buffers (param=0xa11fbe0, from_file=0xa15e5b8,
    to_file=0xa119298, sort_buffer=0xa172c98 "H3\027\n\030;\027\n",
    lastbuff=0xa154f08, Fb=0xb73c136c, Tb=0x1, flag=33) at filesort.cc:1041
#11 0x082e8cc4 in merge_buffers (param=0xa11fc80, from_file=0xa11fbe0,
    to_file=0xa119298,
    sort_buffer=0x472587ef <Address 0x472587ef out of bounds>,
    lastbuff=0x95a5d, Fb=0xa119fdc, Tb=0xb73c1458, flag=137677533)
    at filesort.cc:1036
#12 0x082e9a91 in filesort (thd=0xa11fbe0, table=0xa119298,
    sortorder=0xa11f840, s_length=168927716, select=0xb73c1414,
    max_rows=18446466442728571087, sort_positions=184, examined_rows=0xa11a11c)
    at filesort.cc:936
#13 0x0834cadd in field_real::avg (this=0xa118088, s=0xa119fdc, rows=3)
    at sql_analyse.h:207
#14 0x0045ebd4 in ?? ()
#15 0x0a118088 in ?? ()
#16 0xb73c1490 in ?? ()
#17 0xb73c1490 in ?? ()
#18 0xb73c1490 in ?? ()
#19 0xb73c1490 in ?? ()
#20 0x00000000 in ?? ()
[5 Dec 2007 19:50] 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/39348

ChangeSet@1.2652, 2007-12-05 20:49:50+01:00, mats@kindahl-laptop.dnsalias.net +3 -0
  BUG#31582 (5.1-telco-6.1 -> 5.1.22. Slave crashes when reading UPDATE for VARCHAR):
  
  Just adding testcase. This bug was fixed by patch for BUG#31583.
[5 Dec 2007 20:07] Mats Kindahl
Bug is duplicate of BUG#31583.
[5 Feb 2008 13:03] Bugs System
Pushed into 5.1.24-rc
[5 Feb 2008 13:08] Bugs System
Pushed into 6.0.5-alpha