Changes between Version 81 and Version 82 of Replication_Issues

Timestamp:

Nov 16, 2012, 1:40:08 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -6 +6 @@
 = 2012 =
 
+== 2012-11-14 ==
+{{{
+Last_error value when executing SHOW SLAVE STATUS on that host is:
+Error 'Duplicate entry '21338906' for key 1' on query. Default database: 'gpc1'. Query: 'INSERT INTO diffInputSkyfile(diff_id, skycell_id, warp1, stack1, warp2, stack2, tess_id) SELECT diff_id, skycell_id, warp1, stack1, warp2, stack2, tess_id from skycellsToDiff'
+}}}
+
+Fixed with the usual: {{{stop slave; set global sql_slave_skip_counter=1; start slave;}}}
 == 2012-11-13: nebulous backup ==
 Stopped mysql server on ippc63. rsyncing to ippc62.