Changes between Version 52 and Version 53 of Replication_Issues

Timestamp:

Apr 27, 2012, 11:11:36 AM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -5 +5 @@
 
 = 20120427/11:05 ipp001 =
-ipp001 replication broken because of {{{'Duplicate entry '32' for key 1' on query. Default database: 'ippadmin'. Query: 'insert into users (username, password) values ('chenx', 'chenx')'}}}
-
+ipp001 replication broken because of {{{'Duplicate entry '32' for key 1' on query. Default database: 'ippadmin'. Query: 'insert into users (username, password) values ('chenx', 'chenx')'}}}. I ran the usual {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}}. Then {{{'Duplicate entry '30' for key 1' on query. Default database: 'ippadmin'. Query: 'INSERT into cookies (username, cookie) values ('chenx', '32709')'}}}. Another {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}} made it.
 
 = 20120313/12:05 ipp001 =