PS1 IPP Czar Logs for the week YYYY.MM.DD - YYYY.MM.DD

(Up to PS1 IPP Czar Logs)

Monday : YYYY.MM.DD

Tuesday : YYYY.MM.DD

Wednesday : 2017.10.04

• MEH: SNIaF data issues, nightly pantasks updating past data and restarted to reset distribution cleanup time window

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 ; "
  

• 16:40 CZW: Setting ippb15 to up in nebulous to test shuffle script. I plan to put it back to repair before leaving today.
  • 17:05 CZW: Back to repair. I have enough tests to know what needs work still.

Friday : YYYY.MM.DD

Saturday : YYYY.MM.DD

Sunday : YYYY.MM.DD