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]



Reply via email to