Changes between Version 19 and Version 20 of PS1_IPP_Czarlog_20190524

Timestamp:

May 29, 2019, 11:28:40 PM (7 years ago)

Author:

cclin33

Comment:

--

PS1_IPP_Czarlog_20190524

@@ -342 +342 @@
   
 === Tuesday : 2019.05.28 ===
+* CCL: fix some chip/warp errors on update.LAP.PV3
+{{{
+SELECT exp_name,chipRun.chip_id,chipRun.state,warpRun.warp_id,warpRun.state,warpRun.label,warpSkyfile.fault FROM warpSkyfile, warpRun, fakeRun, camRun, chipRun, rawExp WHERE warpSkyfile.warp_id = warpRun.warp_id AND warpRun.fake_id = fakeRun.fake_id AND fakeRun.cam_id = camRun.cam_id AND camRun.chip_id = chipRun.chip_id AND chipRun.exp_id = rawExp.exp_id AND warpSkyfile.fault != 0 AND warpRun.label like 'update.LAP.PV3' group by warp_id;
++-------------+---------+--------+---------+--------+----------------+-------+
+| exp_name    | chip_id | state  | warp_id | state  | label          | fault |
++-------------+---------+--------+---------+--------+----------------+-------+
+| o5476g0043o | 1385555 | full   | 1330070 | update | update.LAP.PV3 |     2 |
+| o5477g0043o | 1385562 | full   | 1330072 | update | update.LAP.PV3 |     2 |
+| o5492g0068o | 1386613 | full   | 1331100 | update | update.LAP.PV3 |     2 |
+| o5492g0047o | 1386606 | full   | 1331103 | update | update.LAP.PV3 |     2 |
+| o5492g0071o | 1386614 | full   | 1331116 | update | update.LAP.PV3 |     2 |
+| o5492g0050o | 1386607 | full   | 1331119 | update | update.LAP.PV3 |     2 |
+| o5545g0178o | 1444319 | full   | 1391886 | update | update.LAP.PV3 |     2 |
+| o5545g0373o | 1444321 | full   | 1391954 | update | update.LAP.PV3 |     2 |
+| o5545g0160o | 1444314 | full   | 1391960 | update | update.LAP.PV3 |     2 |
+| o5511g0558o | 1444386 | full   | 1392003 | update | update.LAP.PV3 |     2 |
+| o5545g0159o | 1444313 | full   | 1392018 | update | update.LAP.PV3 |     2 |
+| o5545g0355o | 1444228 | full   | 1392057 | update | update.LAP.PV3 |     2 |
+| o5545g0175o | 1444317 | full   | 1392116 | update | update.LAP.PV3 |     2 |
+| o5511g0576o | 1444389 | full   | 1392209 | update | update.LAP.PV3 |     2 |
+| o5545g0177o | 1444318 | full   | 1392220 | update | update.LAP.PV3 |     2 |
+| o5545g0174o | 1444316 | full   | 1392402 | update | update.LAP.PV3 |     2 |
+| o5561g0366o | 1446275 | full   | 1396664 | update | update.LAP.PV3 |     2 |
+| o5545g0198o | 1446526 | full   | 1397154 | update | update.LAP.PV3 |     2 |
+| o7047g0144o | 1452313 | full   | 1399053 | update | update.LAP.PV3 |     2 |
+| o7047g0165o | 1452266 | full   | 1399947 | update | update.LAP.PV3 |     2 |
+| o7047g0166o | 1452267 | full   | 1399948 | update | update.LAP.PV3 |     2 |
+| o5567g0255o | 1458509 | full   | 1408829 | update | update.LAP.PV3 |     2 |
+| o5593g0155o | 1461891 | update | 1413545 | update | update.LAP.PV3 |     2 |
+| o5593g0133o | 1461887 | update | 1413562 | update | update.LAP.PV3 |     2 |
+| o5545g0559o | 1462623 | update | 1415795 | update | update.LAP.PV3 |     2 |
+| o5566g0474o | 1461739 | update | 1429470 | update | update.LAP.PV3 |     2 |
++-------------+---------+--------+---------+--------+----------------+-------+
+
+If their error messages are related to the missing "mk.fits, ch.fits, etc.", to reprocess them is the ways I can solve the issue.
+
+chiptool -dbname gpc1 -definebyquery -set_label mopsfix -set_workdir neb://@HOST@.0/gpc1/mops.fixbrokenLAP.20180323  -set_dist_group NULL -set_tess_id RINGS.V3 -set_end_stage warp -set_data_group mops.fixbrokenLAP.20180323 -set_reduction LAP_SCIENCE -exp_name xxx
+
+then send the old chip and warp to clean 
+chiptool -dbname gpc1 -updaterun -set_state goto_cleaned -set_label goto_cleaned -chip_id xxx
+warptool -dbname gpc1 -updaterun -set_state goto_cleaned -set_label goto_cleaned -warp_id xxx
+
+If their error messages are related to missing the "psf, mdc", try copy and overwrite the 0 size file with validated one.
+then revert them 
+warptool -revertwarped -fault 2 -label update.LAP.PV3 -dbname gpc1 
+
+}}}
 
 === Wednesday : 2019.05.29 ===