Changes between Version 16 and Version 17 of PS1_IPP_Czarlog_20190311

Timestamp:

Mar 14, 2019, 5:53:32 PM (7 years ago)

Author:

tdeboer

Comment:

--

PS1_IPP_Czarlog_20190311

@@ -98 +98 @@
  * TdB: ipp067 is put back to repair following repairs by Haydn. This will allow the errors under the current label to clear out, which will be good testing. Following that, we can put the machine back to up state, and reprocess the IDs gathered under broke label.
 
+ * TdB: With ipp067 back up, I will start clearing out the errors. First off, the broken files under ps_ud_MOPS.broke will be set back to the regular ps_ud_MOPS label in batches and set to update using:
+{{{
+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 "ps_ud_MOPS.broke" and warpRun.state like "update" group by warp_id limit 200; ' | grep -v data_group | awk '{print "chiptool -dbname gpc1 -setimfiletoupdate -set_label ps_ud_MOPS -chip_id  "$1" ;warptool -dbname gpc1 -setskyfiletoupdate -set_label ps_ud_MOPS -warp_id "$2 }' | tcsh
+}}}
 === Friday : 2019.03.15 ===