Changes between Initial Version and Version 1 of PS1_IPP_Czarlog_20190311

Timestamp:

Mar 11, 2019, 2:35:05 PM (7 years ago)

Author:

Mark Huber

Comment:

--

PS1_IPP_Czarlog_20190311

@@ +1 @@
+== PS1 IPP Czar Logs for the week YYYY.MM.DD - YYYY.MM.DD == 
+[[PageOutline]]
+
+(Up to [wiki:PS1_IPP_CzarLogs PS1 IPP Czar Logs])
+
+=== Monday : 2019.03.11 ===
+
+ * MEH: simple oneliner to remove the faulted chip/warps in update.OSS to update.OSS.broke until ipp067 back online -- remember to add the user/password
+{{{
+mysql -hscidbm -uXXXXX -pXXXXX gpc1 -B -e ' select chip_id,warp_id,warpRun.label,warpRun.data_group,warpRun.state,chipRun.label,chipRun.state from warpRun join warpSkyfile using (warp_id) join fakeRun using (fake_id) join camRun using (cam_id) join chipRun using (chip_id) join chipProcessedImfile using (chip_id) where warpRun.label like "update.OSS" and warpRun.data_group like "OSS%" and warpRun.state like "update" and  ( warpSkyfile.fault>0 or chipProcessedImfile.fault>0 ) group by warp_id limit 500; ' | grep -v data_group | awk '{print "chiptool -dbname gpc1 -updaterun -set_label update.OSS.broke -chip_id  "$1" ;warptool -dbname gpc1  -updaterun -set_label update.OSS.broke -warp_id "$2 }'
+}}}  
+
+=== Tuesday : YYYY.MM.DD ===
+
+=== Wednesday : YYYY.MM.DD ===
+
+=== Thursday : YYYY.MM.DD ===
+
+=== Friday : YYYY.MM.DD ===
+
+=== Saturday : YYYY.MM.DD ===
+
+=== Sunday : YYYY.MM.DD ===