Changes between Version 3 and Version 4 of PS1_IPP_Czarlog_20190304

Timestamp:

Mar 5, 2019, 10:00:01 AM (7 years ago)

Author:

fairlamb

Comment:

--

PS1_IPP_Czarlog_20190304

@@ -129 +129 @@
 === Tuesday : 2019.03.05 ===
 
+JRF (Morning): It looks like processing has been slowing down over the evening (drops from around 200 to 150 items per hour).
+
+Can turn off/on separate tasks in pantasks e.g.
+{{{
+chip.revert.off
+}}}
+will turn off the ship.revert task, this is indicated by a minus sign next to the task:
+{{{
+-+ chip.revert
+}}}
+Simply do chip.revert.on to turn it back on.
+To turn off a whole bunch of tasks at once you can do chip.off, to turn off all chip tasks. Can be useful if you want it to focus on getting some warps through. You can also shutdown pantasks without being on the machine running it (I didn't know this).
+
+
+ippb22 still having hardware issues. Taken down on nebulous, Haydn will investigate what to do with it.
+
+
+Looking to see if anything is misbehaving in ganglia, ippdb09 has pretty high load most of the time:
+Having a look at the processlist in the nebulous database gives the following process that has been running for a long time:
+{{{
+| 26081089 | nebulous | ippc73.ifa.hawaii.edu:47235  | nebulous | Query       |    52602 | Sending data                                                          | SELECT
+            storage_object.so_id,
+            uri,
+            mountedvol.available,
+            vol_id,
+            cab_id
+        FROM storage_object
+        JOIN instance
+            USING (so_id)
+        JOIN mountedvol
+            USING(vol_id)
+        JOIN volume
+            USING(vol_id)
+        WHERE ext_id = 'gpc1/OSS.nt/2014/10/28/o6958g0546o.810979/o6958g0546o.810979.ch.1190018.XY50.ptn'
+            AND mountedvol.available = '1'      
+}}}
+Killed the process:
+{{{
+mysql> kill 26081089;
+}}}
+