Changes between Version 23 and Version 24 of PS1_IPP_Czarlog_20150608

Timestamp:

Jun 12, 2015, 8:47:44 AM (11 years ago)

Author:

eugene

Comment:

--

PS1_IPP_Czarlog_20150608

@@ -45 +45 @@
 2015/06/12 00:40:16 | ipp066 | FATAL | Nebulous::Client::replicate - can not copy instance file:///data/ipp070.0/nebulous/b9/91/7090330756.gpc1:20150612:o7185g0074o:o7185g0074o.ota34.fits
 }}}
-=== Friday : YYYY.MM.DD ===
+=== Friday : 2015.06.12 ===
+
+ * 08:45 EAM: various issues this morning.  processing seems to be sluggish for reasons that are not yet obvious.  some things I needed to do:
+   * registration problems for a couple of exposures.  I needed to revert the exposures:
+{{{
+regtool -dbname gpc1 -revertprocessedexp -exp_id 927096
+regtool -dbname gpc1 -revertprocessedexp -exp_id 927200
+}}}
+   * 7 diffs from Jun 11 were not running because their source warps had been cleaned.  I set the warps to update.  some useful mysql commands:
+{{{
+ select diff_id, diffInputSkyfile.skycell_id, diffSkyfile.fault, warpSkyfile.data_state, diffSkyfile.data_state, warp1, warp2 
+   from diffInputSkyfile 
+   left join diffSkyfile using (diff_id, skycell_id) 
+   join diffRun using (diff_id) 
+   join warpSkyfile on (warp1 = warp_id and warpSkyfile.skycell_id = diffInputSkyfile.skycell_id) 
+   where label = 'ThreePi.nightlyscience' and state = 'new' and diffSkyfile.fault is null
++---------+------------------+-------+------------+------------+---------+---------+
+| diff_id | skycell_id       | fault | data_state | data_state | warp1   | warp2   |
++---------+------------------+-------+------------+------------+---------+---------+
+| 1160284 | skycell.1961.008 |  NULL | update     | NULL       | 1589194 | 1589744 | 
+| 1160286 | skycell.1879.060 |  NULL | update     | NULL       | 1589192 | 1589742 | 
+| 1160286 | skycell.1879.070 |  NULL | update     | NULL       | 1589192 | 1589742 | 
+| 1160286 | skycell.1879.090 |  NULL | update     | NULL       | 1589192 | 1589742 | 
+| 1160287 | skycell.1881.058 |  NULL | update     | NULL       | 1589200 | 1589827 | 
+| 1160291 | skycell.2038.051 |  NULL | update     | NULL       | 1589201 | 1589775 | 
+| 1160291 | skycell.2038.081 |  NULL | update     | NULL       | 1589201 | 1589775 | 
+| 1160292 | skycell.2039.090 |  NULL | update     | NULL       | 1589195 | 1589743 | 
+| 1160293 | skycell.1959.010 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1959.040 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1959.050 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1959.070 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1960.009 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1960.039 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160293 | skycell.1960.049 |  NULL | update     | NULL       | 1589187 | 1589825 | 
+| 1160294 | skycell.2038.051 |  NULL | update     | NULL       | 1589189 | 1589745 | 
++---------+------------------+-------+------------+------------+---------+---------+
+}}}
+    The warps in data_state 'update' were earlier in 'cleaned'.  I dumped the output above to a file and used the following awk to set them to update:
+{{{
+awk '(NR > 1){printf "warptool -setskyfiletoupdate -set_label ThreePi.nightlyscience -dbname gpc1 -warp_id %s -skycell_id %s\n", $6, $2}' | tcsh
+}}}
+
+
 
 === Saturday : YYYY.MM.DD ===