Master attempts to send entries it has already sent.
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
Subject
Views
Written By
Posted
Master attempts to send entries it has already sent.
5136
August 24, 2005 06:19AM
2475
August 25, 2005 09:10AM
2291
August 26, 2005 01:32AM
2536
August 26, 2005 01:39AM
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.