Re: binlog truncated in the middle of event

[matt ryan]

Update on this, I found that when the slave stops, all I have to do is 
start the slave and it's good again

Here's what the log shows.. the only thing I did was "start slave" and 
it picked right back up

040728  9:25:13  Error reading packet from server: binlog truncated in 
the middle of event (server_errno=1236)
040728  9:25:13  Got fatal error 1236: 'binlog truncated in the middle 
of event' from master when reading data from binary log
040728  9:25:13  Slave I/O thread exiting, read up to log 
'FINANCE-bin.186', position 171309530
040728  9:29:40  Slave I/O thread: connected to master 
'[EMAIL PROTECTED]:3306',  replication started in log 'FINANCE-bin.186' 
at position 171309530
repeats removed
040728  9:29:56  Error reading packet from server: Lost connection to 
MySQL server during query (server_errno=2013)
040728  9:29:56  Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'FINANCE-bin.186' position 171309530
040728  9:29:58  Error reading packet from server: Lost connection to 
MySQL server during query (server_errno=2013)
040728  9:29:58  Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'FINANCE-bin.186' position 171309530
040728  9:30:26  Slave: load data infile on table 'e47wk_in' at log 
position 979433898 in log 'FINANCE-bin.185' produced 601027 warning(s). 
Default database: 'finance'

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]