List:General Discussion« Previous MessageNext Message »
From:matt ryan Date:July 28 2004 12:57pm
Subject:binlog truncated in the middle of event
View as plain text  
One of my slaves has decided to stop replicating

every time I reset it, I get this

040728  8:46:46  Error reading packet from server: binlog truncated in 
the middle of event (server_errno=1236)
040728  8:46:46  Got fatal error 1236: 'binlog truncated in the middle 
of event' from master when reading data from binary log
040728  8:46:46  Slave I/O thread exiting, read up to log 
'FINANCE-bin.185', position 419216838


All slaves share the same config, but this one refuses to work, the 
master server has plenty of drive space, I have made changes to the 
buffer sizes, I thought one of those could play into it

anyone have a sugestion for a fix?

both a 4.017 (found bugs in current version) master is on windows 2000, 
slave is on server 2003

 From the main server..
+---------------------------------+------------+
| Variable_name                   | Value      |
+---------------------------------+------------+
| binlog_cache_size               | 32768      |
| bulk_insert_buffer_size         | 536870912  |
| delayed_queue_size              | 1000       |
| innodb_additional_mem_pool_size | 1048576    |
| innodb_buffer_pool_size         | 8388608    |
| innodb_log_buffer_size          | 1048576    |
| innodb_log_file_size            | 5242880    |
| join_buffer_size                | 536866816  |
| key_buffer_size                 | 1572864000 |
| max_binlog_cache_size           | 4294967295 |
| max_binlog_size                 | 1073741824 |
| max_heap_table_size             | 16777216   |
| max_join_size                   | 4294967295 |
| max_relay_log_size              | 0          |
| myisam_max_extra_sort_file_size | 268435456  |
| myisam_max_sort_file_size       | 2147483647 |
| myisam_sort_buffer_size         | 268435456  |
| query_alloc_block_size          | 8192       |
| query_cache_size                | 0          |
| query_prealloc_size             | 8192       |
| range_alloc_block_size          | 2048       |
| read_buffer_size                | 268431360  |
| read_rnd_buffer_size            | 262144     |
| sort_buffer_size                | 268435448  |
| thread_cache_size               | 8          |
| tmp_table_size                  | 419430400  |
| transaction_alloc_block_size    | 8192       |
| transaction_prealloc_size       | 4096       |
+---------------------------------+------------+

 From the slave server..
+---------------------------------+------------+
| Variable_name                   | Value      |
+---------------------------------+------------+
| binlog_cache_size               | 32768      |
| bulk_insert_buffer_size         | 8388608    |
| delayed_queue_size              | 1000       |
| innodb_additional_mem_pool_size | 1048576    |
| innodb_buffer_pool_size         | 8388608    |
| innodb_log_buffer_size          | 1048576    |
| innodb_log_file_size            | 5242880    |
| join_buffer_size                | 536866816  |
| key_buffer_size                 | 1572864000 |
| max_binlog_cache_size           | 4294967295 |
| max_binlog_size                 | 1073741824 |
| max_heap_table_size             | 16777216   |
| max_join_size                   | 4294967295 |
| max_relay_log_size              | 0          |
| myisam_max_extra_sort_file_size | 268435456  |
| myisam_max_sort_file_size       | 2147483647 |
| myisam_sort_buffer_size         | 268435456  |
| query_alloc_block_size          | 8192       |
| query_cache_size                | 0          |
| query_prealloc_size             | 8192       |
| range_alloc_block_size          | 2048       |
| read_buffer_size                | 314568704  |
| read_rnd_buffer_size            | 262144     |
| sort_buffer_size                | 268435448  |
| thread_cache_size               | 8          |
| tmp_table_size                  | 33554432   |
| transaction_alloc_block_size    | 8192       |
| transaction_prealloc_size       | 4096       |
+---------------------------------+------------+
Thread
binlog truncated in the middle of eventmatt ryan28 Jul
  • Re: binlog truncated in the middle of eventmatt ryan28 Jul
    • Re: binlog truncated in the middle of eventmatt ryan5 Aug