MySQL Bugs: #25: Replcation crashes on load data infile

Bug #25	Replcation crashes on load data infile
Submitted:	6 Jan 2003 12:05	Modified:	7 Jan 2003 1:28
Reporter:	Peter Zaitsev (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.7	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
Replication seems to crash in some case with LOAD DATA INFILE replicated.

How to repeat:
1) Get mbcd5-bin.001.gz file from secure area.
2) Create database  "mbc" and the following table:
The create statement for the table in question is:
   CREATE TABLE `user_action` (
      `user_action_id` int(10) unsigned NOT NULL auto_increment,
      `server_id` tinyint(3) unsigned default NULL,
      `time` datetime default NULL,
      `user_id` int(10) unsigned default NULL,
      `type` enum('click','open') default NULL,
      `ref_id` int(10) unsigned default NULL,
      PRIMARY KEY  (`user_action_id`)
   ) TYPE=MyISAM;

2) Start replication using this logfile and position 4761
this is done by running "change master to master_host=<master>,master_user=<user>,master_log_file="mbcd5-bin.001",master_log_pos=4761;"
"slave start"

Slave will crash instantly.

Suggested fix:
Unknown

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Fixed in 4.0.9 by Guilhem