Women in Technology

Hear us Roar



Subject:   Replication Problems
Date:   2007-03-23 05:46:26
From:   Apix
Response to: Replication Problems

070320 8:28:26 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070320 8:28:26 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\server_web1_relay_bin.000001' position: 4
070320 8:28:26 [Note] Slave I/O thread: connected to master 'repl@ulfs01:3306', replication started in log 'FIRST' at position 4
070320 9:18:47 [Warning] Warning: Enabling keys got errno 137, retrying
070320 9:41:01 [Warning] Warning: Enabling keys got errno 137, retrying
070320 10:34:36 [Warning] Warning: Enabling keys got errno 137, retrying
070320 10:41:53 [Warning] Warning: Enabling keys got errno 137, retrying
070320 10:55:50 [Warning] Warning: Enabling keys got errno 137, retrying
070320 10:57:07 [Warning] Warning: Enabling keys got errno 137, retrying
070320 11:59:38 [Warning] Warning: Enabling keys got errno 137, retrying
070320 15:30:09 [Warning] Warning: Enabling keys got errno 137, retrying
070320 18:23:18 [Warning] Warning: Enabling keys got errno 137, retrying
070320 18:25:05 [Warning] Warning: Enabling keys got errno 137, retrying
070320 19:45:55 [Warning] Warning: Enabling keys got errno 137, retrying
070320 22:00:28 [Warning] Warning: Enabling keys got errno 137, retrying
070320 23:19:49 [Warning] Warning: Enabling keys got errno 137, retrying
070321 2:29:43 [Warning] Warning: Enabling keys got errno 137, retrying
070321 5:56:14 [Warning] Warning: Enabling keys got errno 137, retrying
070321 8:10:33 [Warning] Warning: Enabling keys got errno 137, retrying
070321 8:12:44 [Warning] Warning: Enabling keys got errno 137, retrying
070321 9:22:39 [ERROR] Error reading packet from server: error reading log entry ( server_errno=1236)
070321 9:22:39 [ERROR] Got fatal error 1236: 'error reading log entry' from master when reading data from binary log
070321 9:22:39 [Note] Slave I/O thread exiting, read up to log 'ULFS01_LOGbv2.000001', position 30549740
070321 10:06:16 [Warning] Warning: Enabling keys got errno 137, retrying
070321 10:42:33 [Warning] Warning: Enabling keys got errno 137, retrying
070321 11:59:32 [Warning] Warning: Enabling keys got errno 137, retrying
070321 12:17:02 [Warning] Warning: Enabling keys got errno 137, retrying


Stuck on this. Read a lot of things about. But you cant restart master and slave when the replication breaks every day.


Any advice?