Changes between Version 1 and Version 2 of PS1_IPP_Czarlog_20171002

Timestamp:

Oct 5, 2017, 4:39:16 PM (9 years ago)

Author:

Mark Huber

Comment:

--

PS1_IPP_Czarlog_20171002

@@ -11 +11 @@
  * MEH: SNIaF data issues, nightly pantasks updating past data and restarted to reset distribution cleanup time window
 
-=== Thursday : YYYY.MM.DD ===
-
+=== Thursday : 2017.10.05 ===
+ * MEH: sloppy example query to check for buildup of unpublished nightly *SS WWdiff exposures 
+{{{
+mysql -hscidbm -uippuser -p gpc1 -B -e " select expall.exp_name,expall.comment,expall.dateobs from ( select exp_name,comment,dateobs from rawExp where dateobs like '`date -u  "+%Y-%m-%d"`%' and obs_mode like '%SS%') expall left join ( select exp_name from diffRun join diffInputSkyfile using (diff_id) join publishRun join warpRun join fakeRun using (fake_id) join camRun using (cam_id) join camProcessedExp using (cam_id) join chipRun using (chip_id) join rawExp using (exp_id) where ( warp1=warp_id or warp2=warp_id ) and diffRun.reduction like 'SWEETSPOT' and stack2 is NULL and diffRun.data_group like '%SS.`date -u "+%Y%m%d"`' and diffRun.diff_id=stage_id group by exp_name ) exppub on expall.exp_name=exppub.exp_name where exppub.exp_name is NULL ; "
+}}}
 === Friday : YYYY.MM.DD ===