Changes between Version 30 and Version 31 of ippToPspsIngestof3piPV2

Timestamp:

Jan 24, 2015, 7:37:58 AM (11 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -765 +765 @@
 loaders keep falling over (not sure why)...  I wont' agressively fix this - I am not sure that restarted them repeatedly is the answer.
 
+== sat 7:37am ===
+
+majority died
+
+i restarted them 
+{{{
+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                   |
++----------+---------------------+------------------------+
+|      279 | PSPS_PV2_OB_SLICE00 | PSPS_PV2_OB_SLICE.00   | 
+|      869 | PSPS_PV2_OB_SLICE02 | PSPS_PV2_OB_SLICE.02   | 
+|     1231 | PSPS_PV2_OB_SLICE04 | PSPS_PV2_OB_SLICE04.1  | 
+|      141 | PSPS_PV2_OB_SLICE04 | PSPS_PV2_OB_SLICE04.2  | 
+|     1346 | PSPS_PV2_OB_SLICE06 | PSPS_PV2_OB_SLICE06.1  | 
+|     1004 | PSPS_PV2_OB_SLICE06 | PSPS_PV2_OB_SLICE06.2  | 
+|     1199 | PSPS_PV2_OB_SLICE12 | PSPS_PV2_OB_SLICE.12   | 
+|      945 | PSPS_PV2_OB_SLICE14 | PSPS_PV2_OB_SLICE.14   | 
+|     2827 | PSPS_PV2_OB_SLICE16 | PSPS_PV2_OB_SLICE.16.1 | 
+|     2276 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.0 | 
+|     1718 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.1 | 
+|     1617 | PSPS_PV2_OB_SLICE18 | PSPS_PV2_OB_SLICE.18.2 | 
+|     1490 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20.0 | 
+|     1549 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20.1 | 
+|     1211 | PSPS_PV2_OB_SLICE20 | PSPS_PV2_OB_SLICE.20.2 | 
+|     1521 | PSPS_PV2_OB_SLICE22 | PSPS_PV2_OB_SLICE22.1  | 
+|     1370 | PSPS_PV2_OB_SLICE22 | PSPS_PV2_OB_SLICE22.2  | 
++----------+---------------------+------------------------+
+17 rows in set (0.12 sec)
+
++----------+
+| count(*) |
++----------+
+|    91819 | 
++----------+
+1 row in set (0.05 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    22593 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.10 sec)
+
+
+}}}