Changes between Version 2 and Version 3 of PS1_IPP_Czarlog_20190401

Timestamp:

Apr 1, 2019, 10:46:13 AM (7 years ago)

Author:

cclin33

Comment:

--

PS1_IPP_Czarlog_20190401

@@ -9 +9 @@
 * EAM 09:00: powered-off ipp001, ipp003, ipp022
 * CCL 09:20: restart stdscience manually
+* CCL: not fixed chip or warp ids, they are related to stsci servers, mask files, or memory block, etc.
+{{{
+mysql -hippdb08 -uippuser -p gpc1 -e "SELECT chipRun.chip_id,chipRun.state,chipRun.label,chipRun.data_group,chipRun.dist_group FROM chipRun WHERE chipRun.label like 'update.LAP.PV3.broke'"
+
+mysql -hippdb08 -uippuser -p gpc1 -e "SELECT chipRun.chip_id,camRun.cam_id,fakeRun.fake_id,warpRun.warp_id,warpRun.state,warpRun.label,warpRun.data_group FROM warpRun, fakeRun, camRun, chipRun WHERE warpRun.fake_id = fakeRun.fake_id AND fakeRun.cam_id = camRun.cam_id AND camRun.chip_id = chipRun.chip_id AND warpRun.label like 'update.LAP.PV3.broke'"
+}}}
 
 === Tuesday : 2019.04.02 ===