Changes between Version 5 and Version 6 of PS1_IPP_Czarlog_20190401

Timestamp:

Apr 1, 2019, 1:55:25 PM (7 years ago)

Author:

cclin33

Comment:

--

PS1_IPP_Czarlog_20190401

@@ -11 +11 @@
 * CCL: not fixed chip or warp ids, they are related to stsci servers, mask files, psf files, or memory block, etc.
 {{{
+* chip
 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'"
+* warp
+mysql -hippdb08 -uippuser -pippuser 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 'ps_ud_MOPS' \
+AND warpRun.warp_id IN (1027567 , 1027638 , 1027645 , 1027695 , 1027697 , 1027705 , 1027711 , 1027781 , 1027785 , 1027828 , 1050735 , 1142465 , 1281048 , 1284676 , 1284689 , 1391868 , 1392030 , 1392058 , 1392250 , 1413405 , 1413407 , 1414496 , 1414848 , 1848779)"
 }}}
 *  EAM 11:00 : Gavin has switch ippops1 & ippops2 to use ippops3 for homedirs and ippc18 for NIS