Changes between Version 25 and Version 26 of Replication_Issues

Timestamp:

Sep 13, 2011, 5:28:35 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -3 +3 @@
 
 [[PageOutline]]
+
+= 20110913/1720: ippdb03 "error" =
+Not really an error actually.
+isp was being updating with the statement ({{{SHOW FULL PROCESSLIST}}} or look at mysqld.err):
+{{{
+INSERT INTO summitExp SELECT NULL, incoming.*, NULL, 0, NULL FROM incoming LEFT JOIN summitExp
+  USING(exp_name, camera, telescope)   
+  WHERE summitExp.exp_name is NULL AND summitExp.camera is NULL AND summitExp.telescope is NULL
+}}}
+I killed the process in the mysql server and skipped the statement {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;}}}
+
+Note: I had to do it twice.
 
 = 20110913/0930: ipp001 error =