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