Bug #15650 DELETE with LEFT JOIN crashes server with innodb_locks_unsafe_for_binlog
Submitted: 10 Dec 2005 9:11 Modified: 11 Apr 2006 5:09
Reporter: Corin Langosch
Status: Closed
Category:Server: InnoDB Severity:S1 (Critical)
Version:5.0.16, 5.0.18, 5.0.19 OS:Linux (debian linux amd64)
Assigned to: Target Version:
Tags: innodb_locks_unsafe_for_binlog, crash

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-15650.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[10 Dec 2005 9:11] Corin Langosch 
creates 2 tables with some data

Attachment: mysql_bug_testcase.sql (text/x-sql), 15.36 KiB.
[10 Dec 2005 19:32] Corin Langosch 
errrlog from i686

Attachment: mysql_bug.txt (text/plain), 4.11 KiB.
[13 Dec 2005 8:44] Jan Lindström 
More outputs from gdb before MySQL calls unlock_row which causes a assert crash.

Attachment: gdb2.txt (text/plain), 14.72 KiB.