Changes between Version 9 and Version 10 of ippToPspsIngestof3piPV2

Timestamp:

Jan 19, 2015, 8:40:43 AM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -214 +214 @@
 
 stare03 stare04 were stuck - I restarted them after killing the processlist in mysql
+
+
+=== Mon 8:30 am ===
+{{{
+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   |
++----------+---------------------+
+|     4716 | PSPS_PV2_OB_SLICE00 | 
+|     6752 | PSPS_PV2_OB_SLICE02 | 
+|     9141 | PSPS_PV2_OB_SLICE04 | 
+|     8800 | PSPS_PV2_OB_SLICE06 | 
+|     6170 | PSPS_PV2_OB_SLICE08 | 
+|     4832 | PSPS_PV2_OB_SLICE10 | 
+|     6298 | PSPS_PV2_OB_SLICE12 | 
+|     7490 | PSPS_PV2_OB_SLICE14 | 
+|     9629 | PSPS_PV2_OB_SLICE16 | 
+|    11493 | PSPS_PV2_OB_SLICE18 | 
+|    10847 | PSPS_PV2_OB_SLICE20 | 
+|     7609 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.19 sec)
+
++----------+
+| count(*) |
++----------+
+|    27399 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    93777 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.13 sec)
+
+}}}
+
+stsci01 loader fell over
+stare03 stare04 were funny needed restart