It won't hurt anything to change the mac_allowed_packet size so I will increase it (it is
set to 80MB, I will double it and see what happens it the future.)
Does anyone know if there are issues replicating blobs (I read yesterday that these
sometimes cause problems)? I am just trying to see if I am setting myself up for future
problems.
Thanks,
Carl
----- Original Message -----
From: Johan De Meersman
To: Carl
Cc: mysql@stripped
Sent: Wednesday, February 16, 2011 6:55 AM
Subject: Re: Replication, log info
On Wed, Feb 16, 2011 at 12:23 PM, Carl <carl@stripped> wrote:
110216 5:15:20 [ERROR] Error reading packet from server: log event entry exceeded
max_allowed_packet; Increase
max_allowed_packet on master ( server_errno=1236)
This seems to be the major player, here. I would make sure to increase the setting
identically on both sides, though.
I'm not entirely sure how this would happen - maybe due to making a borderline-sized
query deterministic?
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
