Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in

  FAQ | Search | Memberlist | Usergroups | Statistics | Profile | Log in to check your private messages | Log in | Register

mysql error please help
 View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
mythandra
n00b
n00b


Joined: 15 Sep 2006
Posts: 35
PostPosted: Thu Aug 09, 2007 6:33 am    Post subject: mysql error please help Reply with quote
Hello Everyone,

I am trying to setup master slave replication with both of my gentoo machines running mysql 4.1.21.

The problem i ham experiencing is when on the slave i type "start slave" i get the following error within the log files.

Code:
070809  6:24:07 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236)
070809  6:24:07 [ERROR] Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log
070809  6:24:07 [ERROR] Slave I/O thread exiting, read up to log 'mysql-bin.000002', position 40998710


i have set bot the max_allowed_packet within the master and slave to 1024M and restart both the master and slave but this has done nothing to resolve the issue.

I am a little stuck at the moment. can anyone suggtest anything?

Thanks Mythandra
Back to top
View user's profile Send private message
elgato319
Guru
Guru


Joined: 15 Sep 2005
Posts: 546
PostPosted: Thu Aug 09, 2007 8:58 am    Post subject: Reply with quote
I found something interesting:

http://bugs.mysql.com/bug.php?id=1818
http://bugs.mysql.com/bug.php?id=9822

Maybe it's not caused bei mysql at all.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



 Links: forums.gentoo.org | www.gentoo.org | bugs.gentoo.org | wiki.gentoo.org | forum-mods@gentoo.org

Copyright 2001-2024 Gentoo Foundation, Inc. Designed by Kyle Manna © 2003; Style derived from original subSilver theme. | Hosting by Gossamer Threads Inc. © | Powered by phpBB 2.0.23-gentoo-p11 © 2001, 2002 phpBB Group
Privacy Policy