Changes between Version 10 and Version 11 of ippToPspsIngestof3piPV2

Timestamp:

Jan 19, 2015, 9:36:32 PM (11 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -255 +255 @@
 stsci01 loader fell over
 stare03 stare04 were funny needed restart
+
+=== monday 9pm ===
+
+several loaders fell over, they were fine until 7pm, they started failing a few at a time, this is the current status as of 9:30:
+
+{{{
+loader.py running on stare00
+problem with stare01
+loader.py running on stare03
+loader.py running on stare04
+loader.py running on ipp006
+loader.py running on stsci00
+problem with stsci01
+problem with stsci03
+problem with stsci04
+loader.py running on stsci05
+problem with stsci06
+problem with stsci07
+}}}
+
+{{{
+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   |
++----------+---------------------+
+|     4518 | PSPS_PV2_OB_SLICE00 | 
+|     6751 | PSPS_PV2_OB_SLICE02 | 
+|     9140 | PSPS_PV2_OB_SLICE04 | 
+|     8021 | PSPS_PV2_OB_SLICE06 | 
+|     5433 | PSPS_PV2_OB_SLICE08 | 
+|     4266 | PSPS_PV2_OB_SLICE10 | 
+|     5802 | PSPS_PV2_OB_SLICE12 | 
+|     6752 | PSPS_PV2_OB_SLICE14 | 
+|     9076 | PSPS_PV2_OB_SLICE16 | 
+|    11103 | PSPS_PV2_OB_SLICE18 | 
+|    10323 | PSPS_PV2_OB_SLICE20 | 
+|     7104 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.19 sec)
+
++----------+
+| count(*) |
++----------+
+|    32304 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    88289 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.12 sec)
+
+
+}}}
+
+00 is stuck
+01 needed restart
+03 is stuck
+04 is stuck
+006 is stuck (unstucked it)
+00 is stuck (not any more?)
+01 needed restart
+03/04/05/06/07 needed restart