Changes between Version 14 and Version 15 of ippToPspsIngestof3piPV2

Timestamp:

Jan 20, 2015, 10:48:28 AM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -383 +383 @@
  * stsci 07 restarted
 
-
-
-
+=== Tue 10:45am ===
+
+ * stsci10 needs restart
+
+{{{
+mysql> mysql>  select count(*), datastore_product from pending join box on box_ijoin 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   |
++----------+---------------------+
+|     4407 | PSPS_PV2_OB_SLICE00 | 
+|     6621 | PSPS_PV2_OB_SLICE02 | 
+|     9086 | PSPS_PV2_OB_SLICE04 | 
+|     7859 | PSPS_PV2_OB_SLICE06 | 
+|     5157 | PSPS_PV2_OB_SLICE08 | 
+|     3597 | PSPS_PV2_OB_SLICE10 | 
+|     5311 | PSPS_PV2_OB_SLICE12 | 
+|     5973 | PSPS_PV2_OB_SLICE14 | 
+|     8830 | PSPS_PV2_OB_SLICE16 | 
+|    11001 | PSPS_PV2_OB_SLICE18 | 
+|    10128 | PSPS_PV2_OB_SLICE20 | 
+|     7006 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.18 sec)
+
++----------+
+| count(*) |
++----------+
+|    35241 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    84976 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.13 sec)
+
+}}}
+
+