Changes between Version 18 and Version 19 of Replication_Issues

Timestamp:

Jul 27, 2011, 2:16:38 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -3 +3 @@
 
 [[PageOutline]]
+= 20110727/1410: gpc1 Replication Error =
+ippdb03 crashed. SHOW SLAVE STATUS messages was like: 'Duplicate entry ...'
+
+I applied {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;}}} about twenty times and everything looks fine now.
+(Messages were like: 'Duplicate entry ...')
+
 = 20110726/1810: gpc1 Replication Error =
-ippdb03 crashed
+ippdb03 crashed. SHOW SLAVE STATUS messages was like: 'Duplicate entry ...'
+
 I applied {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;}}} four times and everything looks fine now.
-
+(Messages were like: 'Duplicate entry ...')
 = 20110429/0850: gpc1 Replication Error =
 From mysql slave on ippc02 (SHOW SLAVE STATUS)