[ossig] MySQL slave not replicating, invalid pointer...

[Christopher DeMarco <cdemarco@xxxxxxxxxxx>]

Hi  everybody!   Boy   have these   lists  been   dead the  past   few
weeks... maybe this will initiate some traffic:

I have  a mysql slave which is  supposed to replicate, but it doesn't.
I've  verified  that the  communications  channel  is  open  and  that
authentication works.  <slave>.err complains thusly: (long lines)

040729 11:26:58  Slave: reconnected to master 'repl@172.30.10.6:3307',replication resumed in log 'alpha-bin.014' at position 24661
040729 11:26:58  Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (server_errno=65535)

So I jack the max_allowed_packet variable on  the master waaaay up and
restart everything.  I verify that said variable  is indeed set in the
running mysqld instance, but that doesn't fix the problem.

Clever me notices that  the position at  which the errorlog  says it's
stuck does not exist in the binary log.  Anybody know (a) how this got
bollocksed-up, and/or (b) how to move the pointer on the slave so that
it stops looking for stuff what ain't there?   Perhaps a swift kick to
the hdd bay?


-- 
~ You are in a maze of twisty passages, all alike.

  Christopher DeMarco
  cdemarco@fastmail.fm
  +6013 389 5658


---------------------------------------------------------
To unsubscribe: send mail to ossig-request@mncc.com.my
with "unsubscribe ossig" in the body of the message