List:General Discussion« Previous MessageNext Message »
From:Mohammed Abdul Azeem Date:May 10 2006 10:31am
Subject:~Replication errors~
View as plain text  
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
'repl@mysqlprod1: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

========================================
Thread
~Replication errors~Mohammed Abdul Azeem10 May
  • Re: ~Replication errors~sheeri kritzer12 May