Changes between Version 35 and Version 36 of ippToPspsIngestof3piPV2

Timestamp:

Jan 26, 2015, 3:17:36 PM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -892 +892 @@
 
 additionally, I will requeue done slices ( 00 / 02 / 04 / 06 / 08 / 10/ 12 / 14/ 20 ) to clean up missing batches. I do not expect this to fil the holes that are large (or the pole), I am still investigating this.
+
+=== Monday 1-26 - 2015  3:15pm === 
+
+Much progress:
+
+1.  dropped SAS.diff.test, sas37.test, MD04.test from pending batches, that allowed the missing batches from PV2 to be picked up (it was blocking it)
+
+2. found a cut of 85 on the dec that was preventing the pole from being queued. I do not know how this works for other (non ob) batches, but it works for ob. 
+
+{{{
+mysql>  select count(*), datastore_product,name from pending join box on box_id = id join skychunk on name = skychunk 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                   |
++----------+---------------------+------------------------+
+|       12 | PSPS_PV2_OB_SLICE02 | PSPS_PV2_OB_SLICE.02   | 
+|       33 | PSPS_PV2_OB_SLICE08 | PSPS_PV2_OB_SLICE.08   | 
+|      501 | PSPS_PV2_OB_SLICE10 | PSPS_PV2_OB_SLICE.10   | 
+|      880 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE16.0  | 
+|      698 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE16.1  | 
+|      497 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.0 | 
+|      608 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.1 | 
+|       67 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.2 | 
+|       44 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20   | 
+|      237 | PSPS_PV2_OB_SLICE22 | PSPS_PV2_OB_SLICE22.1  | 
++----------+---------------------+------------------------+
+10 rows in set (0.01 sec)
+
++----------+
+| count(*) |
++----------+
+|   109810 | 
++----------+
+1 row in set (0.06 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|     3577 | PSPS_PV2_OB_SLICE18 | 
++----------+---------------------+
+1 row in set (0.00 sec)
+
+}}}