Changes between Initial Version and Version 1 of Replication_Issues

Timestamp:

Nov 4, 2010, 2:58:12 PM (16 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ +1 @@
+The purpose of this page is to show how databases replication problems were solved.
+[[PageOutline]]
+
+= 20101104/1429: gpc1 replication on ipp001 =
+  Problem detected through czartool
+  * Logged onto ipp001
+  * Started mysql client as root
+  * 'SHOW SLAVE STATUS\G' showed (shortened)
+{{{
+          Slave_SQL_Running: No
+                 Last_Errno: 1062
+                 Last_Error: Error 'Duplicate entry '23' for key 1' on query. Default database: 'ippadmin'. 
+                             Query: 'INSERT into cookies (username, cookie) values ('psobs', '99497')'
+}}}
+  * Local non-replicated database involved... Statement skipped (in MySQL client):
+{{{
+  STOP SLAVE;
+  SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 
+  START SLAVE;
+}}}
+  * Then 'SHOW SLAVE STATUS\G' showed (shortened)
+{{{
+          Slave_SQL_Running: Yes
+                 Last_Errno: 0
+                 Last_Error: 
+}}}
+
+