IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 3 and Version 4 of PS1_IPP_Czarlog_20190510


Ignore:
Timestamp:
May 11, 2019, 12:31:01 PM (7 years ago)
Author:
tdeboer
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • PS1_IPP_Czarlog_20190510

    v3 v4  
    3434
    3535=== Saturday : 2019.05.11 ===
     36 * TdB: One exposure of the night was ruined, which caused chunk OSSR.R13S1.12.Q.i to be incomplete. Check the status and see if a desperate diff needs to be made:
     37{{{
     38mysql -hscidbm -uX -pX gpc1 -B -e "SELECT selchunk.chunk,selchunk.object,MAX(CASE WHEN selchunk.visit=1 THEN selchunk.warp_id ELSE 0 END) as warp1,MAX(CASE WHEN selchunk.visit=2 THEN selchunk.warp_id ELSE 0 END) as warp2,MAX(CASE WHEN selchunk.visit=3 THEN selchunk.warp_id ELSE 0 END) as warp3,MAX(CASE WHEN selchunk.visit=4 THEN selchunk.warp_id ELSE 0 END) as warp4,MAX(CASE WHEN diffchunk.visit=1 THEN diffchunk.diff_id ELSE 0 END) as diff1,MAX(CASE WHEN diffchunk.visit=2 THEN diffchunk.diff_id ELSE 0 END) as diff2,MAX(CASE WHEN diffchunk.visit=3 THEN diffchunk.diff_id ELSE 0 END) as diff3,MAX(CASE WHEN diffchunk.visit=4 THEN diffchunk.diff_id ELSE 0 END) as diff4,selchunk.workdir,selchunk.label,selchunk.data_group,selchunk.reduction FROM (SELECT SUBSTRING_INDEX(comment, ' ',1) AS chunk,SUBSTRING_INDEX(comment, ' ',-1) AS visit,object,warp_id,rawExp.workdir,chipRun.label,chipRun.data_group,rawExp.reduction FROM 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 rawExp.exp_name LIKE 'o%' AND substr(comment, 1, position(' ' in comment)) LIKE 'OSSR.R13S1.12.Q.i%' AND rawExp.dateobs LIKE '`date -u "+%Y-%m-%d"`%' ORDER BY warp_id DESC) as selchunk LEFT JOIN ((SELECT SUBSTRING_INDEX(comment, ' ',1) AS chunk,SUBSTRING_INDEX(comment, ' ',-1) AS visit, object,warp_id,diff_id FROM diffRun JOIN diffInputSkyfile USING (diff_id) JOIN warpRun ON (warp1=warp_id) 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 rawExp.exp_name LIKE 'o%' AND substr(comment, 1, position(' ' in comment)) LIKE 'OSSR.R13S1.12.Q.i%' AND rawExp.dateobs LIKE '`date -u "+%Y-%m-%d"`%' AND stack2 IS NULL GROUP BY warp_id) UNION (SELECT SUBSTRING_INDEX(comment, ' ',1) AS chunk,SUBSTRING_INDEX(comment, ' ',-1) AS visit, object,warp_id,diff_id FROM diffRun JOIN diffInputSkyfile USING (diff_id) JOIN warpRun ON (warp2=warp_id) 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 rawExp.exp_name LIKE 'o%' AND substr(comment, 1, position(' ' in comment)) LIKE 'OSSR.R13S1.12.Q.i%' AND rawExp.dateobs LIKE '`date -u "+%Y-%m-%d"`%' AND stack2 IS NULL GROUP BY warp_id)) as diffchunk ON selchunk.warp_id=diffchunk.warp_id GROUP BY selchunk.object;"
     39}}}
     40 which returns:
     41{{{
     42chunk   object  warp1   warp2   warp3   warp4   diff1   diff2   diff3   diff4   workdir label   data_group      reduction
     43OSSR.R13S1.12.Q.i       ps1_28_0298     2107392 2107411 2107431 2107450 1764479 1764479 1764537 1764537 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     44OSSR.R13S1.12.Q.i       ps1_28_0299     2107384 2107405 2107423 2107444 1764467 1764467 1764525 1764525 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     45OSSR.R13S1.12.Q.i       ps1_28_0303     2107399 2107418 2107438 2107456 1764488 1764488 1764546 1764546 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     46OSSR.R13S1.12.Q.i       ps1_28_0304     2107390 2107408 2107428 2107449 1764473 1764473 1764536 1764536 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     47OSSR.R13S1.12.Q.i       ps1_28_0305     2107388 2107407 2107426 2107446 1764472 1764472 1764528 1764528 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     48OSSR.R13S1.12.Q.i       ps1_28_0310     2107397 2107416 2107436 2107454 1764487 1764487 1764543 1764543 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     49OSSR.R13S1.12.Q.i       ps1_28_0391     2107383 2107404 2107425 2107443 1764468 1764468 1764519 1764519 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     50OSSR.R13S1.12.Q.i       ps1_28_0399     2107400 2107421 2107441 2107459 1764497 1764497 1764556 1764556 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     51OSSR.R13S1.12.Q.i       ps1_28_0400     2107389 2107414 2107430 2107451 1764485 1764485 1764538 1764538 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     52OSSR.R13S1.12.Q.i       ps1_28_0401     2107391 2107410 2107429 2107448 1764478 1764478 1764531 1764531 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     53OSSR.R13S1.12.Q.i       ps1_28_0402     2107382 2107403 0       2107442 1764462 1765059 0       1765059 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     54OSSR.R13S1.12.Q.i       ps1_28_0403     2107385 2107402 2107420 2107440 1764461 1764461 1764520 1764520 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     55OSSR.R13S1.12.Q.i       ps1_28_0410     2107398 2107419 2107437 2107458 1764495 1764495 1764554 1764554 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     56OSSR.R13S1.12.Q.i       ps1_28_0412     2107395 2107412 2107434 2107453 1764480 1764480 1764544 1764544 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     57OSSR.R13S1.12.Q.i       ps1_28_0413     2107393 2107415 2107432 2107452 1764486 1764486 1764539 1764539 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     58OSSR.R13S1.12.Q.i       ps1_28_0414     2107387 2107409 2107424 2107445 1764474 1764474 1764527 1764527 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     59OSSR.R13S1.12.Q.i       ps1_28_0415     2107386 2107406 2107427 2107447 1764469 1764469 1764532 1764532 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     60OSSR.R13S1.12.Q.i       ps1_28_0416     2107381 2107401 2107422 2107439 1764457 1764457 1764516 1764516 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     61OSSR.R13S1.12.Q.i       ps1_28_0426     2107396 2107417 2107435 2107457 1764493 1764493 1764547 1764547 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     62OSSR.R13S1.12.Q.i       ps1_28_0428     2107394 2107413 2107433 2107455 1764484 1764484 1764545 1764545 neb://@HOST@.0/gpc1/20190511    OSS.nightlyscience      OSS.20190511    SWEETSPOT
     63}}}
     64 In fact, it has already been diffed, since we see two separate diff_ids for this obejct, diff_id=1764462 (made from 2107382 and 2107403) and diff_id=1765059 (made from 2107403 and 2107442). I am guessing the nightly_science.pl script kicked in here, at the end of the night.
     65
    3666
    3767=== Sunday : 2019.05.12 ===