MySQL's pretty good when it describes an error. (if the error message
is vague you might be screwed, but MySQL is pretty good).
Which means:
1) You didn't properly change the max_allowed_packet on the master.
what does show variables like "max_allowed_packet"; show you?
2) The slave is actually running fine and you're looking at an old
error. What does SHOW SLAVE STATUS; show you on the master?
3) Did you change max_allowed_packet on the slave? I think it would
need to be changed on the slave as well.
-Sheeri
On 5/10/06, Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote:
Hi,
Iam getting the following error on my Mysql Slave server. This happened
when my disk space got full and there was no space left on the device. I
managed to free up some space and then ran
mysql> STOP SLAVE
mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000110',
MASTER_LOG_POS=850202232;
mysql> START SLAVE
I could find that replication started but with the following error. Can
anyone help me out in fixing the issue ? I tried increasing the
max_allowed_packet on master server but with no luck.
060510 0:56:22 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.000110'
at position 850202232
060510 0:56:22 [ERROR] Error reading packet from server: log event
entry exceeded max_allowed_packet; Increase max_allowed_packet on master
( server_errno=1236)
060510 0:56:22 [ERROR] Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master
when readingdata from binary log
060510 0:56:22 [Note] Slave I/O thread exiting, read up to log 'mysql-
bin.000110', position 850202232
Thanks in advance,
Abdul.
________________________________________
This email has been Scanned for Viruses!
www.newbreak.com
========================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
