On Wed, Jul 18, 2007 at 06:13:10PM -0400, I wrote: > This afternoon, both slaves stopped at the same place, with the same error:
> 070718 17:28:00 [ERROR] Error reading packet from server: error reading log > entry ( server_errno=1236) > 070718 17:28:00 [ERROR] Got fatal error 1236: 'error reading log entry' from > master when reading data from binary log > 070718 17:28:00 [Note] Slave I/O thread exiting, read up to log > 'hlgbinlog-oil.000015', position 139702230 It turns out that this is due to a large query and max_allowed_packet being too small for that query, on the *master*. If max_allowed_packet on the slave is too small, you'll get an error message that directly tells you max_allowed_packet is too small; but if it's too small on the master, you'll get this cryptic message in the slave's error log, and nothing at all on the master's error log. -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
