Changes between Version 63 and Version 64 of Replication_Issues

Timestamp:

Oct 9, 2012, 6:45:23 AM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -5 +5 @@
 
 = 2012 =
+
+== 2012-10-09: ippdb01 -> ippdb03/ipp001 ==
+
+Same problem as yesterday.
+{{{
+Error 'Duplicate entry '19309559' for key 1' on query. Default database: 'gpc1'.
+Query: 'INSERT INTO diffInputSkyfile SELECT * from skycellsToDiff'
+}}}
+
+Same fix:
+{{{
+STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
+}}}
 
 == 2012-10-08: ippdb01 -> ippdb03/ipp001 ==