Hi,
I'm using MySQL 4.0.13 for both master and slave servers.
However I have problem starting slave server. Error log says:
030804 14:06:10 Slave I/O thread: connected to master
'r***@202.xxx.xxx.xxx:3306', replication started in log
'backend2-bin.228' at position 43583528
030804 14:11:48 Slave I/O thread exiting, read up to log
'backend2-bin.228', position 64018330
030804 14:11:58 Error in Log_event::read_log_event(): 'Event too big',
data_len=540488761,event_type=52
030804 14:11:58 Error reading relay log event: slave SQL thread aborted
because of I/O error
030804 14:11:58 Could not parse log event entry, check the master for
binlog corruption
This may also be a network problem, or just a bug in the master or slave code.
030804 14:11:58 Error running query, slave SQL thread aborted. Fix the
problem, and restart the slave SQL thread with
"SLAVE START". We stopped at log 'backend2-bin.195' position 141630238
I checked binlog with mysqlbinnlog: mysqlbinlog -j 141630238
/var/db/mysql/backend2-bin.195 | head
It showed 2 queries and both seems ok, because I tried manually insert
those queries into slave db.
How can I fix this issue?
thanks in advance,
Ganbold
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
