Changes between Version 13 and Version 14 of ippToPspsIngestof3piPV2

Timestamp:

Jan 20, 2015, 8:40:48 AM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -331 +331 @@
  * stsci07 needed a second restart
 
+=== Tue 8:30 am ===
+
+someone cranked the cluster up to 11 last night..  All my stuff stopped.
+
+{{{
+mysql>  select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%' group by datastore_product ;select count(*) from batch where dvo_db like 'LAP.PV2%' and loaded_to_datastore =1; select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%';
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|     4516 | PSPS_PV2_OB_SLICE00 | 
+|     6749 | PSPS_PV2_OB_SLICE02 | 
+|     9139 | PSPS_PV2_OB_SLICE04 | 
+|     7953 | PSPS_PV2_OB_SLICE06 | 
+|     5334 | PSPS_PV2_OB_SLICE08 | 
+|     3726 | PSPS_PV2_OB_SLICE10 | 
+|     5426 | PSPS_PV2_OB_SLICE12 | 
+|     6105 | PSPS_PV2_OB_SLICE14 | 
+|     8944 | PSPS_PV2_OB_SLICE16 | 
+|    11090 | PSPS_PV2_OB_SLICE18 | 
+|    10216 | PSPS_PV2_OB_SLICE20 | 
+|     7087 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.18 sec)
+
++----------+
+| count(*) |
++----------+
+|    34068 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    86285 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.13 sec)
+
+
+}}}
+
+ * stare00 - stalled --- > moved to stsci08
+ * stare01 -stopped restarted
+ * stare03 stalled
+
+ * stare04 stalled --->  moved to stsci09
+ * ipp006 restarted
+ *stsci 00 /01 /03 ok
+ * stsci 04 restarted
+ * stsci 05 / 06 restarted
+ * stsci 07 restarted
+
+
+
+