Changes between Version 58 and Version 59 of PS1_IPP_CzarLog_20120611

Timestamp:

Jun 14, 2012, 3:08:32 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

PS1_IPP_CzarLog_20120611

@@ -60 +60 @@
  * 10:30 Mark: restarted stdscience and found OSS stack didn't trigger right last night, running now. may be change to nightly_science.pl? MD SSdiffs ran normally and distributed.  
  * 11:05 OSS stacks finished and going out to distribution.
+ * 15:05 Serge: Replication on ipp001 was running fine when the same statement that stopped replication on ippdb03 yesterday was played. It is:
+{{{
+mysql> SELECT id, user, host, db, command, time, state, info FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY Host;
+
+| 768 | system user |           | isp  | Connect |  220 | Copying to tmp table             | 
+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 
+| 
+}}}
+   We need to figure out why this statement succeeds on ippdb01 but fails when it's replicated. My best guess is that it actually fails with a timeout and is then processed at the pantasks level.
 === Friday : YYYY.MM.DD ===