IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 39921


Ignore:
Timestamp:
Jan 6, 2017, 11:16:07 AM (10 years ago)
Author:
eugene
Message:

merge changes from trunk

Location:
branches/czw_branch/20160809/ippMonitor
Files:
8 edited

Legend:

Unmodified
Added
Removed
  • branches/czw_branch/20160809/ippMonitor/czartool/czartool/CzarDb.pm

    r38258 r39921  
    274274# CZW: 2014-09-12 edit to force in lanl labels
    275275    if ($server eq 'stdscience') {
    276         push @{$labels}, 'LAP.PV3.20140730.final';
     276#        push @{$labels}, 'LAP.PV3.20140730.final';
    277277#        push @{$labels}, 'LAP.PV3.20140730.local';
    278278#        push @{$labels}, 'LAP.PV3.20140730.ipp';
     
    284284#        push @{$labels}, 'LAP.PV3.20140730.diff01';
    285285#        push @{$labels}, 'LAP.PV3.20140730.diff01.left';
    286         push @{$labels}, 'LAP.PV3.20140730.ff01.remote';
    287         push @{$labels}, 'LAP.PV3.20140730.ff01';
    288         push @{$labels}, 'LAP.PV3.20140730.ff01.left';
    289         push @{$labels}, 'LAP.PV3W.20150312';
     286#        push @{$labels}, 'LAP.PV3.20140730.ff01.remote';
     287#        push @{$labels}, 'LAP.PV3.20140730.ff01';
     288#        push @{$labels}, 'LAP.PV3.20140730.ff01.left';
     289#        push @{$labels}, 'LAP.PV3.20140730.ff01.bulge';
     290#        push @{$labels}, 'LAP.PV3W.20150312';
    290291#       push @{$labels}, 'SAS.20141118';
     292## MEH 20150921 manuall add WS labels while in ippqub stdscience       
     293        push @{$labels}, 'OSS.WS.nightlyscience';
     294        push @{$labels}, 'MSS.WS.nightlyscience';
     295        push @{$labels}, 'ESS.WS.nightlyscience';
     296        push @{$labels}, 'ThreePi.WS.nightlyscience';
     297        push @{$labels}, 'SNIa.WS.nightlyscience';
     298        push @{$labels}, 'QUB.WS.nightlyscience';       
     299        push @{$labels}, 'QUB.SS.nightlyscience';
     300        push @{$labels}, 'ps_ud_QUB';
     301        #push @{$labels}, 'CFA.WS.nightlyscience';
     302        #push @{$labels}, 'CFA.SS.nightlyscience';
     303        push @{$labels}, 'FSS.WS.nightlyscience';
     304        #push @{$labels}, 'NCU.ref.20161026';
     305        #push @{$labels}, 'NCU.ref.20161026.update';
     306        #push @{$labels}, 'NCU.WS.nightlyscience';
     307        #push @{$labels}, 'NCU.SS.nightlyscience';
     308        #push @{$labels}, 'QUB.lowdec.20160712';
     309        #push @{$labels}, 'SAS.20151208';
     310## MEH 20150928 manually add MD.PV3 WS labels too       
     311        #push @{$labels}, 'MD01.PV3.WSdiff.20150312';
     312        #push @{$labels}, 'MD02.PV3.WSdiff.20150312';
     313        #push @{$labels}, 'MD03.PV3.WSdiff.20150312';
     314        #push @{$labels}, 'MD04.PV3.WSdiff.20150312';
     315        #push @{$labels}, 'MD05.PV3.WSdiff.20150312';
     316        #push @{$labels}, 'MD06.PV3.WSdiff.20150312';
     317        #push @{$labels}, 'MD07.PV3.WSdiff.20150312';
     318        #push @{$labels}, 'MD08.PV3.WSdiff.20150312';
     319        #push @{$labels}, 'MD09.PV3.WSdiff.20150312';
     320        #push @{$labels}, 'MD10.PV3.WSdiff.20150312';
    291321    }
    292322
     
    964994        my ($host, $used, $available, $writable, $readable) = @row;
    965995
     996        # stsci hosts are no longer with us
     997        next if $host =~ /stsci/;
     998
    966999        if (($used+$available) == 0) {
    9671000          $underLimit = 1;
     
    9711004          $underLimit = 1;
    9721005        }
     1006
    9731007
    9741008        # Col 1: host
  • branches/czw_branch/20160809/ippMonitor/czartool/czartool/Nebulous.pm

    r35742 r39921  
    112112            next;
    113113        } elsif (($line =~ m/(ipp[0-9]+\.[0-9]{1})\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i)||
    114                ($line =~ m/(ippb[0-9]+\.[0-9]{1})\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i) ||
    115                ($line =~ m/(stsci[0-1][0-9]+\.[0-9]{1})\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i)) {
     114               ($line =~ m/(ippb[0-9]+\.[0-9]{1})\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i)
     115# these nodes are gone
     116#               || ($line =~ m/(stsci[0-1][0-9]+\.[0-9]{1})\s.+[0-9]+\s+([0-9]+)\s+([0-9]+)\s+([0-9]+)%.*/i))
     117        ) {
    116118
    117119            $self->{_totalHosts}++;
  • branches/czw_branch/20160809/ippMonitor/czartool/czartool/Pantasks.pm

    r38200 r39921  
    77
    88my @servers = (
    9         "addstar",
    10         "addstarlap",
     9#        "addstar",
     10#        "addstarlap",
     11        "ippqub:stdscience_ws",
    1112        "cleanup",
    12         "deepstack",
    13         "detrend",
     13#        "deepstack",
     14#        "detrend",
    1415        "distribution",
    1516        "pstamp",
  • branches/czw_branch/20160809/ippMonitor/czartool/czartool/czarconfig.xml.in

    r38211 r39921  
    4949    <serverinterval>20 MINUTE</serverinterval>
    5050    <!-- whitespace-separated server list for servers we want roboczar to check -->
    51     <interestedservers>stdscience distribution summitcopy registration pstamp </interestedservers>
     51    <interestedservers>ippqub:stdscience_ws stdscience distribution summitcopy registration pstamp </interestedservers>
    5252    <!-- <interestedservers>pstamp</interestedservers> -->
    5353  </roboczar>
  • branches/czw_branch/20160809/ippMonitor/def/simplePlotSkycalImage.d

    r34436 r39921  
    44MENU  ipp.plots.dat
    55
    6 WHERE skycalRun.state != 'new'
     6WHERE skycalRun.state = 'full'
    77WHERE skycalRun.skycal_id = skycalResult.skycal_id
    88WHERE skycalRun.stack_id = stackRun.stack_id
  • branches/czw_branch/20160809/ippMonitor/def/simplePlotStaticskyImage.d

    r34436 r39921  
    44MENU  ipp.plots.dat
    55
    6 WHERE staticskyRun.state != 'new'
     6WHERE staticskyRun.state = 'full'
    77WHERE staticskyRun.sky_id = staticskyResult.sky_id
    88WHERE staticskyRun.sky_id = staticskyInput.sky_id
  • branches/czw_branch/20160809/ippMonitor/raw/czartool_labels.php

    r39498 r39921  
    8080
    8181$servers=array(
    82         "addstar",
    83         "addstarlap",
     82        #"addstar",
     83        #"addstarlap",
     84        "ippqub:stdscience_ws",
    8485        "cleanup",
    85         "detrend",
     86        #"detrend",
    8687        "distribution",
    8788        "pstamp",
     
    270271      createTableColumnHeader("Status (sec behind master)");
    271272      showReplicationsStatus($REPL_HOST_GPC1, $REPL_USER_GPC1, $REPL_PASSWORD_GPC1, $REPL_DBNAME_GPC1);
    272 
     273      showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
    273274      # XXX EAM : problem showReplicationsStatus($REPL_HOST_NEBULOUS, $REPL_USER_NEBULOUS, $REPL_PASSWORD_NEBULOUS, $REPL_DBNAME_NEBULOUS);
    274275      showReplicationsStatus($REPL_HOST_PSTAMP, $REPL_USER_PSTAMP, $REPL_PASSWORD_PSTAMP, $REPL_DBNAME_PSTAMP);
    275276      showReplicationsStatus($REPL_HOST_IPPADMIN, $REPL_USER_IPPADMIN, $REPL_PASSWORD_IPPADMIN, $REPL_DBNAME_IPPADMIN);
    276277      showReplicationsStatus($REPL_HOST_ISP, $REPL_USER_ISP, $REPL_PASSWORD_ISP, $REPL_DBNAME_ISP);
    277       showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
     278##      showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
    278279      echo "</table>";
    279280
     
    313314
    314315    // list the results
    315     while (dbFetchInto($qry, $row)) {
     316    while ($qry->fetchInto($row)) {
    316317
    317318        echo "<tr>";
     
    358359
    359360    // list the results
    360     while (dbFetchInto($qry, $expType)) {
     361    while ($qry->fetchInto($expType)) {
    361362
    362363        $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
    363364        $qry2 = $projectdb->query($sql);
    364       dbFetchInto($qry2, $summit);
     365        $qry2->fetchInto($summit);
    365366        $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
    366367        $qry2 = $projectdb->query($sql);
    367       dbFetchInto($qry2, $mhpcc);
     368        $qry2->fetchInto($mhpcc);
    368369
    369370        echo "<tr>";
     
    397398    $qry = $db->query($sql);
    398399    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    399     while (dbFetchInto($qry, $row)) {
     400    while ($qry->fetchInto($row)) {
    400401
    401402        $labels[] = $row[0];
     
    621622    $qry = $db->query($sql);
    622623    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    623     dbFetchInto($qry, $row);
     624    $qry->fetchInto($row);
    624625
    625626    return $row[0];
     
    655656    $qry = $db->query($sql);
    656657    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    657     dbFetchInto($qry, $row);
     658    $qry->fetchInto($row);
    658659
    659660    return $row[0];
     
    673674    $qry = $db->query($sql);
    674675    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    675     dbFetchInto($qry, $row);
     676    $qry->fetchInto($row);
    676677
    677678    $pending = $row[0];
     
    730731    $dates = "";
    731732    $firstIn = true;
    732     while (dbFetchInto($qry, $row)) {
     733    while ($qry->fetchInto($row)) {
    733734
    734735        if ($firstIn) {
     
    887888    $qry = $db->query($sql);
    888889    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    889     dbFetchInto($qry, $row);
     890    $qry->fetchInto($row);
    890891
    891892    $alive = $row[0];
     
    906907    $qry = $db->query($sql);
    907908    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
    908     dbFetchInto($qry, $row);
     909    $qry->fetchInto($row);
    909910
    910911    return $row[0];
     
    947948    }
    948949    $res = $dbRepl->query('SHOW SLAVE STATUS');
    949     while (dbFetchInto($res, $row)) {
     950    while ($res->fetchInto($row)) {
    950951        # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
    951952        $errorStatusInMySql = $row[18];
    952953        $sec_behind = $row[32];
    953         $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"<font color=\"red\">PROBLEM</font>");
     954        if ($sec_behind===NULL) {
     955            $sec_behind = 99999999;
     956            $errorStatusInMySql = 999999999;
     957        }   
     958        $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"<font style=\"BACKGROUND-COLOR: yellow\"  color=\"red\">PROBLEM</font>");
    954959        echo "<tr><td>$replDatabaseName</td><td>$replStatus</td></tr>";
    955960        if ($errorStatusInMySql!=0) {
  • branches/czw_branch/20160809/ippMonitor/raw/czartool_servers.php

    r28156 r39921  
    3333
    3434$servers=array(
    35         "addstar",
     35        #"addstar",
     36        "ippqub:stdscience_ws",
    3637        "cleanup",
    37         "detrend",
     38        #"detrend",
    3839        "distribution",
    3940        "pstamp",
    40         "update",
    41         "publishing",
     41        #"update",
     42        #"publishing",
    4243        "registration",
    4344        "replication",
Note: See TracChangeset for help on using the changeset viewer.