Changes between Version 15 and Version 16 of PS1_IPP_Czarlog_20190503

Timestamp:

May 7, 2019, 1:05:14 PM (7 years ago)

Author:

cclin33

Comment:

--

PS1_IPP_Czarlog_20190503

@@ -346 +346 @@
 
 === Tuesday : 2019.05.07 ===
+* CCL 12:30 : try to find warp_id and corresponding chip_id to see it chip state 
+{{{
+SELECT rawExp.exp_name,rawExp.exp_id,chipRun.chip_id,chipRun.state,camRun.cam_id,fakeRun.fake_id,warpRun.warp_id,warpRun.state,warpRun.label,warpRun.data_group \
+FROM warpRun, fakeRun, camRun, chipRun, rawExp \
+WHERE 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 warpRun.state like 'update' \
+AND warpRun.label like 'update.LAP.PV3'  order by exp_name limit 10
+                                                            
+mysql xxx -B -e 'SELECT chipRun.chip_id FROM warpRun, fakeRun, camRun, chipRun, rawExp \
+WHERE 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 warpRun.state like "update" \
+AND warpRun.label like "update.LAP.PV3" \
+AND chipRun.state not like "update" | \
+sed 's/^/chiptool -dbname gpc1 -updaterun -state wait -set_state update -set_label update.LAP.PV3 -chip_id /' > wait-update.sh
+&&
+sed 's/^/chiptool -dbname gpc1 -setimfiletoupdate -set_label update.LAP.PV3 -chip_id /' > setimfiletoupdate.sh
+
+** might not be all at "wait" state with "chipRun.state not like update"
+}}}
 
 === Wednesday : 2019.05.08 ===