Hello.
I'm using replication both master and slave are MySQL 4.0.10.
But, When I insert many record( ten thousands of record) at a once,
I got follow error message.
###
030219 18:03:20 Error reading packet from server: binlog truncated in the
middle of event (server_errno=1236)
030219 18:03:20 Got fatal error 1236: 'binlog truncated in the middle of event'
from master when reading data from binary log
030219 18:03:20 Slave I/O thread exiting, read up to log 'test42-bin.003',
position 5329913
###
what does this mean? and what shoud I do?
somebody help me~
Replication status after error:
mysql> show slave status \G
*************************** 1. row ***************************
Master_Host: 203.231.xx.xx
Master_User: repli
Master_Port: 3306
Connect_retry: 10
Master_Log_File: test42-bin.003
Read_Master_Log_Pos: 5329913
Relay_Log_File: wertyu-relay-bin.002
Relay_Log_Pos: 5329973
Relay_Master_Log_File: test42-bin.003
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db: mysql
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 5299624
Relay_log_space: 5329977
1 row in set (0.00 sec)
mysql> show master status \G
*************************** 1. row ***************************
File: test42-bin.003
Position: 5393075
Binlog_do_db:
Binlog_ignore_db: intranet,mysql,repli_test,sfactive,test,traffic,wertyu
1 row in set (0.00 sec)
####
Thank you for advanced answer!
##########################
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com
Filter : sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
