Changes between Version 41 and Version 42 of PS1_IPP_Czarlog_20190510
- Timestamp:
- May 17, 2019, 11:12:04 AM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PS1_IPP_Czarlog_20190510
v41 v42 418 418 mysql -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 419 419 }}} 420 And to c ehck 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: 421 421 {{{ 422 422 mysql -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;' 423 423 }}} 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.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. 425 425 426 426 * TdB: at around 17:30, the IPPmonitor stalled. Turns out, mysql crashed on ippdb05. Let's check things:
