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

["Nicholas Adrian Suppiah" <Nicholas@xxxxxxxxxxxx>]

Try to restart and reset slave only after doing the following. 
Reduce the table_cache var
Delete the temp files too (found in tmpdir).
What type of tables are you using? BDB and InnoDB may have problems that need specific settings.
I do not think it matter in this case if you increase the max_allowed_packets.

Hope it works.

-----Original Message-----
From: owner-ossig@mncc.com.my [mailto:owner-ossig@mncc.com.my]On Behalf
Of Christopher DeMarco
Sent: 29 July 2004 11:36
To: ossig@mncc.com.my; myoss@my-opensource.org
Subject: [ossig] MySQL slave not replicating, invalid pointer...


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





---
CONFIDENTIALITY NOTICE & DISCLAIMER         
  
This email and any attachment may contain confidential, privileged content and/or copyrighted information of APIIT SDN BHD ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person) any use, disclosure, retransmission or dissemination of this Message or any part thereof is strictly prohibited. If you have received this in error, please notify the sender immediately by return e-mail and delete this Message from your computer. Take note that any privilege or confidentiality attached to this Message is not waived, lost or destroyed due to this disclosure. Whilst all care has been taken, APIIT SDN BHD's management disclaims all liability for loss or damage to person or property arising from this Message being infected by computer virus or other contamination. Opinions, conclusions and other information in this Message that do not relate to the official business of APIIT SDN BHD shall be understood as neither g!
iven nor endorsed by APIIT SDN BHD.
---



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