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 |
+---------------------------------+------------+
