Changes between Version 26 and Version 27 of ippToPspsIngestof3piPV2

Timestamp:

Jan 22, 2015, 4:46:16 PM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -624 +624 @@
 3. split 04 --> 2 loaders
 4. tried reloading slice10 to get missing batches, no effect (either they are already queued or they are not..)
+
+===thursday 4:45pm ===
+
+stsci10 fell over, restarted loading.
+
+{{{
+select count(*), datastore_product,name from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%' group by datastore_product, name ;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   | name                   |
++----------+---------------------+------------------------+
+|     1558 | PSPS_PV2_OB_SLICE00 | PSPS_PV2_OB_SLICE.00   | 
+|     2921 | PSPS_PV2_OB_SLICE02 | PSPS_PV2_OB_SLICE.02   | 
+|     3224 | PSPS_PV2_OB_SLICE04 | PSPS_PV2_OB_SLICE04.1  | 
+|     2036 | PSPS_PV2_OB_SLICE04 | PSPS_PV2_OB_SLICE04.2  | 
+|     4577 | PSPS_PV2_OB_SLICE06 | PSPS_PV2_OB_SLICE.06   | 
+|     1903 | PSPS_PV2_OB_SLICE08 | PSPS_PV2_OB_SLICE.08   | 
+|      875 | PSPS_PV2_OB_SLICE10 | PSPS_PV2_OB_SLICE.10   | 
+|     2894 | PSPS_PV2_OB_SLICE12 | PSPS_PV2_OB_SLICE.12   | 
+|     2340 | PSPS_PV2_OB_SLICE14 | PSPS_PV2_OB_SLICE.14   | 
+|     3619 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE.16.1 | 
+|     1483 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE.16.2 | 
+|     2867 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.0 | 
+|     2431 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.1 | 
+|     2913 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.2 | 
+|     4447 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20.1 | 
+|     2611 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20.2 | 
+|     4604 | PSPS_PV2_OB_SLICE22 | PSPS_PV2_OB_SLICE.22   | 
++----------+---------------------+------------------------+
+17 rows in set (0.16 sec)
+
++----------+
+| count(*) |
++----------+
+|    69419 | 
++----------+
+1 row in set (0.04 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    47303 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.11 sec)
+
+}}}