Changes between Version 5 and Version 6 of ippToPspsIngestof3piPV2

Timestamp:

Jan 18, 2015, 9:35:00 AM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -122 +122 @@
  * stsci00 , 01, 03, 06, 07 -restart
 
+== Sunday 9:15am ==
+
+Loaders whcih need restart:
+stare01
+stare03
+ipp006
+stsci00
+stsci01
+stsci03
+stsci04
+stsci05
+
+(stare00/04/stsci6/7 did not)
+
+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   |
++----------+---------------------+
+|     5817 | PSPS_PV2_OB_SLICE00 | 
+|     7359 | PSPS_PV2_OB_SLICE02 | 
+|     9422 | PSPS_PV2_OB_SLICE04 | 
+|    10425 | PSPS_PV2_OB_SLICE06 | 
+|     7978 | PSPS_PV2_OB_SLICE08 | 
+|     6381 | PSPS_PV2_OB_SLICE10 | 
+|     6999 | PSPS_PV2_OB_SLICE12 | 
+|     9094 | PSPS_PV2_OB_SLICE14 | 
+|    11213 | PSPS_PV2_OB_SLICE16 | 
+|    12397 | PSPS_PV2_OB_SLICE18 | 
+|    12021 | PSPS_PV2_OB_SLICE20 | 
+|     8814 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.20 sec)
+
++----------+
+| count(*) |
++----------+
+|    14630 | 
++----------+
+1 row in set (0.01 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|   107920 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.14 sec)
+