IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 20 and Version 21 of PS1_IPP_Czarlog_20190204


Ignore:
Timestamp:
Feb 8, 2019, 12:15:52 PM (7 years ago)
Author:
fairlamb
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PS1_IPP_Czarlog_20190204

    v20 v21  
    266266
    267267From these, the following are done, indicated by the state="full":
     268
     269{{{
    268270+-------------+--------+---------------------+----------------------------+-------+---------+
    269271| exp_name    | exp_id | label               | data_group                 | state | chip_id |
     
    276278| o5476g0289o | 235984 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full  | 2128163 |
    277279+-------------+--------+---------------------+----------------------------+-------+---------+
     280}}}
     281
    278282
    279283Therefore, set their old chips, the ones stuck in update, to clean:
    280284SELECT exp_name, exp_id, label, data_group, chipRun.state, chipRun.chip_id FROM rawExp LEFT JOIN chipRun USING (exp_id) WHERE exp_name IN ("o5218g0041o", "o5218g0057o", "o5362g0570o", "o5362g0583o", "o5476g0223o", "o5476g0289o") AND chipRun.state="update";
     285
     286{{{
    281287+-------------+--------+--------------+------------------+--------+---------+
    282288| exp_name    | exp_id | label        | data_group       | state  | chip_id |
     
    289295| o5476g0289o | 235984 | ps_ud_MOPS.2 | ecliptic.rp.1hr  | update |  489341 |
    290296+-------------+--------+--------------+------------------+--------+---------+
     297}}}
     298
    291299use:
    292300{{{