MySQL Forums
Forum List  »  Replication

Master attempts to send entries it has already sent.
Posted by: Stefan Chavdarov
Date: August 24, 2005 06:19AM

Here is the problem that I cant get arround.

Upon starting the slave I receive a duplicate key error. An database entry with duplicate key already exists on slave and is the same as on master. In short, apparently master attempts to send entries it has already sent.
And then it fails to converge. Same error goes over and over.

Please help

Here is the .err
050810 3:50:17 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './evoucher2-relay-bin.000001' position: 4
050810 3:50:17 [ERROR] Slave I/O thread: error connecting to master 'repl@192.168.42.62:3306': Error: 'Can't connect to MySQL server on '192.168.42.62' (115)' errno: 2003 retry-time: 60 retries: 86400
050810 3:50:18 [ERROR] Slave I/O thread killed while connecting to master
050810 3:50:18 [ERROR] Slave I/O thread exiting, read up to log 'FIRST', position 4
050810 3:50:18 [ERROR] Error reading relay log event: slave SQL thread was killed
050810 3:50:19 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './evoucher2-relay-bin.000001' position: 4
050810 3:50:19 [ERROR] Slave I/O thread: error connecting to master 'repl@192.168.42.62:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400
050810 3:50:20 [ERROR] Slave I/O thread killed while connecting to master
050810 3:50:20 [ERROR] Slave I/O thread exiting, read up to log 'FIRST', position 4
050810 3:50:20 [ERROR] Error reading relay log event: slave SQL thread was killed
050810 3:50:21 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './evoucher2-relay-bin.000001' position: 4
050810 3:50:21 [ERROR] Slave I/O thread: error connecting to master 'repl@192.168.42.62:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400

Regards,
Stefan

Options: ReplyQuote


Subject
Views
Written By
Posted
Master attempts to send entries it has already sent.
5124
August 24, 2005 06:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.