Description:
I have a master running FreeBSD 4.5 and a slave running FreeBSD 4.7. I've upgraded to 4.0.12 (using the prebuilt binaries for FreeBSD) on both master and slave. I have several large files I load using LOAD DATA INFILE. With the default max_allowed_packet settings (ie: 1M), I get the following error:
030322 6:24:24 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236)
030322 6:24:24 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log
When I increase max_allowed_packet to 3M (which is the lowest setting that doesn't cause this error, I get:
030322 10:05:56 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
030322 10:05:56 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'db-1-bin.020' position 4939458
The exact command in my binary log is:
LOAD DATA INFILE '/data/1048328100800-aVaOe0' REPLACE INTO TABLE t1 FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' LINES STARTING BY '' (day,a,b,c,d);
Here is the information on the file:
-rw-r--r-- 1 mysql 1001 28169419 Mar 22 06:18 /data/1048328100800-aVaOe0
How to repeat:
