Bug #31793 log event corruption causes crash
Submitted: 23 Oct 2007 19:26 Modified: 28 Nov 2007 13:40
Reporter: Matthew Lord
Status: Closed
Category:Server: Replication Severity:S1 (Critical)
Version:5.0.46,5.1.23bk OS:Any (64 bit)
Assigned to: Mats Kindahl Target Version:5.1.23
Tags: bfsm_2007_10_25, replication, relay log, binary log, corruption, crash

[23 Oct 2007 19:26] Matthew Lord 
Description:
You can see the routines not handle the corruption well and crash on any x86_64
machine with greater than 4GB of RAM using the attached relay log:
mysqlbinlog relay-bin.000624 > /tmp/relay.out

How to repeat:
grab attached relay log file and run the following command on an x86_64 machine
with > 4GB of RAM:

mysqlbinlog relay-bin.000624 > /tmp/relay.out

Suggested fix:
We should handle this situation more gracefully.  Anytime we crash it is dangerous for
myisam tables.
[23 Oct 2007 19:39] Shane Bester 
stack trace, debug info, etc.   mysqld crashes in same place (according to customer).

Attachment: bug31793_stack_debug.txt (text/plain), 3.04 KiB.
[12 Nov 2007 22: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/37611

ChangeSet@1.2551, 2007-11-12 22:02:12+01:00, mats@kindahl-laptop.dnsalias.net +1 -0
  BUG#31793 (log event corruption causes crash):
  
  Corrections to get_str_len_and_pointer().
[27 Nov 2007 11:49] Bugs System 
Pushed into 5.0.54
[27 Nov 2007 11:50] Bugs System 
Pushed into 5.1.23-rc
[27 Nov 2007 11:52] Bugs System 
Pushed into 6.0.4-alpha
[28 Nov 2007 13:40] Jon Stephens 
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.0.54, 5.1.23, and 6.0.4 changelogs as follows:

        Corruption of log events caused the server to crash on 64-bit
        Linux systems having 4 GB of memory or more.