IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 41 and Version 42 of PS1_IPP_Czarlog_20190510


Ignore:
Timestamp:
May 17, 2019, 11:12:04 AM (7 years ago)
Author:
tdeboer
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PS1_IPP_Czarlog_20190510

    v41 v42  
    418418mysql -hscidbm -uX -pX gpc1 -B -e 'SELECT chip_id,data_group,label FROM chipRun WHERE state like "wait" and data_group like "LAP.PV3.20140730.20150%" and label not like "update.LAP.PV3";' | grep -v data_group | awk '{print "chiptool -dbname gpc1 -updaterun -set_state goto_cleaned -set_label goto_cleaned -chip_id  "$1}' | tcsh
    419419}}}
    420  And to cehck if the cleanip is working ok, we can query the curent states (and numbers) for a data_group:
     420 And to check if the cleanup is working ok, we can query the current states (and numbers) for a data_group:
    421421{{{
    422422mysql -hscidbm -uX -pX gpc1 -B -e 'SELECT waitct,data_group,label,state from (SELECT count(*) as waitct,data_group,label,state FROM chipRun where data_group like "LAP.PV3.20140730.20150%" GROUP BY data_group,state) as s;'
    423423}}}
    424  Ihave sent everything with wait states under data_group "LAP.PV3.20140730.20150%" to clean, to make current updates smoother. But, this needs to be done for subsequent groups as well.
     424 I have sent everything with wait states under data_group "LAP.PV3.20140730.20150%" to clean, to make current updates smoother. But, this needs to be done for subsequent groups as well.
    425425
    426426 * TdB: at around 17:30, the IPPmonitor stalled. Turns out, mysql crashed on ippdb05. Let's check things: