Changes between Version 9 and Version 10 of PS1_IPP_Czarlog_20190510

Timestamp:

May 13, 2019, 3:55:38 PM (7 years ago)

Author:

mhuber

Comment:

--

PS1_IPP_Czarlog_20190510

@@ -157 +157 @@
 }}}
 
+ * MEH: cleanup chip updates example 
+{{{
+mysql -hscidbm -uX -pX gpc1 -B -e ' select chip_id,warp_id,warpRun.label,warpRun.data_group,warpRun.state,chipRun.label,chipRun.state from warpRun join fakeRun using (fake_id) join camRun using (cam_id) join chipRun using (chip_id)  where warpRun.label like "update.%" and warpRun.data_group like "%" and warpRun.state like "full" and chipRun.state like "full" group by warp_id limit 1000; ' | grep -v data_group | awk '{print "chiptool -dbname gpc1 -updaterun -state full -set_state goto_cleaned -set_label goto_cleaned -chip_id "$1 }'
+
+mysql -hippdb08 -uX -pX gpc1 -B -e ' select count(chip_id) from chipRun where state like "goto_cleaned" and label like "goto_cleaned"; select count(warp_id) from warpRun where state like "goto_cleaned" and label like "goto_cleaned"; select count(diff_id) from diffRun where state like "goto_cleaned" and label like "goto_cleaned"; select count(stack_id) from stackRun where state like "goto_cleaned" and label like "goto_cleaned"; select count(dist_id) from distRun where state like "goto_cleaned" and label like "goto_cleaned"; '; date
+}}}
+
 === Tuesday : 2019.05.14 ===