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:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.7 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[6 Jan 2003 12:05] Peter Zaitsev
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`)

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:
[7 Jan 2003 1:28] MySQL Developer
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 

Fixed in 4.0.9 by Guilhem