Hello.
If the value of Read_Master_Log_Pos has a normal value, and slave asked weird position, this could be some internal bug. Now I see only a single way, but it could be difficult: if you have --log-slave-updates, use slave binary logs to find the last executed statement and it's position in master logs, and CHANGE MASTER to that position. Fagyal Csongor <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
