List:General Discussion« Previous MessageNext Message »
From:matt ryan Date:September 2 2004 3:19pm
Subject:Re: Slave I/O thread dies, fatal error 1236
View as plain text  
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



Thread
Slave I/O thread dies, fatal error 1236matt ryan2 Sep
  • Re: Slave I/O thread dies, fatal error 1236gerald_clark2 Sep
    • Re: Slave I/O thread dies, fatal error 1236matt ryan2 Sep
      • Re: Slave I/O thread dies, fatal error 1236matt ryan7 Sep
        • Re: Slave I/O thread dies, fatal error 1236Tobias Asplund7 Sep
          • Re: Slave I/O thread dies, fatal error 1236matt ryan7 Sep
            • Re: Slave I/O thread dies, fatal error 1236Remigiusz Sokołowski8 Sep
              • Re: Slave I/O thread dies, fatal error 1236matt ryan8 Sep
  • In search of a good MySQL GUI clientJose Miguel Pérez8 Sep
    • Re: In search of a good MySQL GUI clientKaram Chand9 Sep
      • Re: In search of a good MySQL GUI clientJose Miguel Pérez9 Sep
        • Re: In search of a good MySQL GUI clientKaram Chand9 Sep
          • Re: In search of a good MySQL GUI clientJose Miguel Pérez9 Sep
  • Re: In search of a good MySQL GUI clientMartijn Tonies8 Sep