Changes between Version 36 and Version 37 of Replication_Issues

Timestamp:

Nov 21, 2011, 8:50:37 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -3 +3 @@
 
 [[PageOutline]]
+
+= 20111121/08:47: ippdb03/ipp001  = 
+Two instances of czarpoll were started at the same time, running two "OPTIMIZE TABLE burntool". Replication broke on both clients. The message on both client was: {{{"Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'OPTIMIZE TABLE burntool'"}}}
+
+Fixed with {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}}
 
 = 20111117/16:23: ipp001 crashed =