Changes between Version 33 and Version 34 of PS1_IPP_CzarLog_20110725

Timestamp:

Jul 28, 2011, 10:06:22 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

PS1_IPP_CzarLog_20110725

@@ -71 +71 @@
  * 09:21 Serge: pubtool -revert -label (OSS.nightlyscience, MD10.nightlyscience, MD08.nightlyscience)
  * 09:22 Serge: warp.on, chip.on
+ * 09:55 Serge: trying to fix the 400+ failed published items
+{{{
+mysql> select pub_id, client_id, diffRun.state, diffRun.data_group, diffRun.dist_group from publishRun 
+       join publishDone using(pub_id) join diffRun on stage_id = diff_id where publishDone.fault > 0 
+       and publishRun.state ='new' and diffRun.dist_group ='ThreePi';
++--------+-----------+-------+------------------+------------+
+| pub_id | client_id | state | data_group       | dist_group |
++--------+-----------+-------+------------------+------------+
+| 237134 |         5 | full  | ThreePi.20110713 | ThreePi    | -> publishRun.state set to drop (likely too old)
+| 242765 |         1 | full  | ThreePi.20110727 | ThreePi    | \
+| 242871 |         1 | full  | ThreePi.20110727 | ThreePi    | |
+| 242873 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242882 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242928 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242929 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242930 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242945 |         1 | full  | ThreePi.20110726 | ThreePi    | |--> All fixed with pubtool -revert -pub_id <pub_id>
+| 242974 |         1 | full  | ThreePi.20110726 | ThreePi    | |
+| 242996 |         5 | full  | ThreePi.20110728 | ThreePi    | |
+| 243046 |         1 | full  | ThreePi.20110728 | ThreePi    | |
+| 243050 |         1 | full  | ThreePi.20110728 | ThreePi    | |
+| 243054 |         1 | full  | ThreePi.20110728 | ThreePi    | |
+| 243059 |         5 | full  | ThreePi.20110728 | ThreePi    | /
++--------+-----------+-------+------------------+------------+
+15 rows in set (0.01 sec)
+