Bug #68242 LOAD DATA LOCAL INFILE '/tmp/SQL_LOAD_MB-3-2' INTOTABLE

• Submitted: 1 Feb 2013 9:38
• Modified: 2 Feb 2013 9:06
• Reporter: Anil Alpati
• Status: Duplicate
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.44
• OS: Linux (suse)
• CPU Architecture: Any

[1 Feb 2013 9:38] Anil Alpati

Description:
replication breaks due to master load data passing incorrect parameters - 
here is binary log information -

# at 349
#130201  1:23:20 server id 1  end_log_pos 46
#Begin_load_query: file_id: 3  block_len: 23
# at 395
#130201  1:23:20 server id 1  end_log_pos 224   Execute_load_query      thread_id=13    exec_time=0     error_code=0
SET TIMESTAMP=1359710600/*!*/;
SET @@session.sql_mode=1575223311/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
LOAD DATA  LOCAL INFILE '/tmp/SQL_LOAD_MB-3-3' INTOTABLE ztest FIELDS TERMINATED BY ',' (submission_key)/*!*/;
# file_id: 3
# at 573
#130201  1:23:20 server id 1  end_log_pos 600   Xid = 116
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

How to repeat:
# at 349
#130201  1:23:20 server id 1  end_log_pos 46
#Begin_load_query: file_id: 3  block_len: 23
# at 395
#130201  1:23:20 server id 1  end_log_pos 224   Execute_load_query      thread_id=13    exec_time=0     error_code=0
SET TIMESTAMP=1359710600/*!*/;
SET @@session.sql_mode=1575223311/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
LOAD DATA  LOCAL INFILE '/tmp/SQL_LOAD_MB-3-3' INTOTABLE ztest FIELDS TERMINATED BY ',' (submission_key)/*!*/;
# file_id: 3
# at 573
#130201  1:23:20 server id 1  end_log_pos 600   Xid = 116
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

[2 Feb 2013 9:06] MySQL Verification Team

Hi Anil,

This bug has been fixed for years already.  Please check your sql_mode(s) on master/slave, and consider upgrading.  5.0.44 is very very old.

References:
http://bugs.mysql.com/bug.php?id=43746
http://bugs.mysql.com/bug.php?id=22504