Hi list,
This night my slave stopped replicating the master (I am using 4.1.11 to replicate 4.1.9). Whenever I say "start slave", The error log of the slave says:
050430 10:27:12 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'www-bin.000003' at position 429178917
050430 10:27:12 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
050430 10:27:12 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
050430 10:27:12 [ERROR] Slave I/O thread exiting, read up to log 'www-bin.000003', position 429178917
The interesting thing is that for the master: -rw-rw---- 1 mysql mysql 1073741913 Apr 26 21:52 www-bin.000001 -rw-rw---- 1 mysql mysql 1073742497 Apr 29 01:37 www-bin.000002 -rw-rw---- 1 mysql mysql 429153165 Apr 29 20:20 www-bin.000003 -rw-rw---- 1 mysql mysql 169507064 Apr 30 11:01 www-bin.000004
Looks like the master really has no "position 429178917" as the length of www-bin.000003 is smaller, 429153165 (if I understand this correctly).
Is there a way to restart replication other than copying everything from the slave to the master again??
Thanks, - Csongor
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]