Changes between Version 34 and Version 35 of ippToPspsIngestof3piPV2

Timestamp:

Jan 26, 2015, 9:46:53 AM (11 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -855 +855 @@
 pending
 }}}
+
+=== monday 9:45am ===
+
+I kept starting / restarting loaders on sunday, but there are fewer now as it's nearly done.
+
+{{{
+mysql>  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                   |
++----------+---------------------+------------------------+
+|     1873 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE.16.1 | 
+|      738 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.0 | 
+|      668 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.1 | 
+|      240 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.2 | 
+|      334 | PSPS_PV2_OB_SLICE22 | PSPS_PV2_OB_SLICE22.1  | 
++----------+---------------------+------------------------+
+5 rows in set (0.01 sec)
+
++----------+
+| count(*) |
++----------+
+|   108802 | 
++----------+
+1 row in set (0.05 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|     3853 | PSPS_PV2_OB_SLICE16 | 
++----------+---------------------+
+1 row in set (0.01 sec)
+
+mysql> 
+
+}}}
+
+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.