Still have not got this fixed, I'm all out of idea's, the slave has been
reloaded again today
gerald_clark wrote:
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated
in the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the
middle of event' from master when reading data from binary log
040901 18:36:21 Slave I/O thread exiting, read up to log
'FINANCE-bin.186', position 7517914
2 slaves on one box
both masters have identical config
one slave will not stay running for more than an hour, it seems that
it will run until it catches up with the master, then it dies.
Any sugestions? All servers have plenty of free drive space
Oops sorry
windows 2000, mysql 4.0.20d
here's the config on the affected server, it is identical to the
server that works fine, except for the port number and base/data dir's
it's interesting to note, that if I wait a few minutes after the
thread dies, and issue "start slave" it'll usually start right up and
run until it's caught up to the master server again.
Matt
skip-locking
set-variable= key_buffer_size=1500M
set-variable=join_buffer_size=512M
set-variable= max_allowed_packet=300M
set-variable= table_cache=512
set-variable=delay_key_write=ALL
set-variable= sort_buffer_size=256M
set-variable= record_buffer=300M
set-variable= thread_cache=8
set-variable=myisam_sort_buffer_size=256M
myisam-recover=BACKUP,FORCE
set-variable=read_buffer_size=300M
set-variable=interactive_timeout=7200
set-variable=wait_timeout=7200
set-variable=thread_concurrency=4
server-id=5
#log-bin
master-host=192.168.1.168
master-port=3306
master-user=repl
master-password=Daredevil22
master-connect-retry=60
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]