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',
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
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,
This email has been Scanned for Viruses!