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@lists.mysql.com
Sent: Wednesday, February 16, 2011 6:55 AM
Subject: Re: Replication, log info
On Wed, Feb 16, 2011 at 12:23 PM, Carl <c...@etrak-plus.com> 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
