Changes between Version 61 and Version 62 of Replication_Issues

Timestamp:

Oct 8, 2012, 9:00:27 AM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -6 +6 @@
 = 2012 =
 
+== 2012-10-08: ippdb01 -> ippdb03/ipp001 ==
+{{{
+Error 'Duplicate entry '19172463' for key 1' on query. Default database: 'gpc1'. Query: 'INSERT INTO diffInputSkyfile SELECT * from skycellsToDiff'
+}}}
+
+Fix:
+{{{
+STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
+}}}
 == 2012-08-25 / ippdb01 to ippdb03-ipp001 ==
 difftool.c allows playing twice an insert statement, hence breaking the replication.