Changes between Version 68 and Version 69 of PS1_IPP_CzarLog_20120604

Timestamp:

Jun 8, 2012, 9:26:53 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

PS1_IPP_CzarLog_20120604

@@ -108 +108 @@
  * 21:10 Serge: I'm stopping the mysql server on ippdb03... Everything is frozen.
  * 21:20 Serge: Restarted mysql, summitcopy, and registration.
+ * 21:23 Serge: Seem to run smoothly. However the query 1118 looks suspect:
+{{{
+mysql> SELECT id, user, host, db, command, time, state, info FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id=1118;
++------+------+-----------------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| id   | user | host                        | db   | command | time | state                | info                                                                                                                                                                                                                                                                                          |
++------+------+-----------------------------+------+---------+------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| 1118 | ipp  | ipp050.ifa.hawaii.edu:41063 | isp  | Query   |  398 | 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 | 
+}}}
+It's likely been generated by summitcopy (running on ipp050)
 === Saturday : YYYY.MM.DD ===