Changeset 39921
- Timestamp:
- Jan 6, 2017, 11:16:07 AM (10 years ago)
- Location:
- branches/czw_branch/20160809/ippMonitor
- Files:
-
- 8 edited
-
czartool/czartool/CzarDb.pm (modified) (4 diffs)
-
czartool/czartool/Nebulous.pm (modified) (1 diff)
-
czartool/czartool/Pantasks.pm (modified) (1 diff)
-
czartool/czartool/czarconfig.xml.in (modified) (1 diff)
-
def/simplePlotSkycalImage.d (modified) (1 diff)
-
def/simplePlotStaticskyImage.d (modified) (1 diff)
-
raw/czartool_labels.php (modified) (12 diffs)
-
raw/czartool_servers.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/czw_branch/20160809/ippMonitor/czartool/czartool/CzarDb.pm
r38258 r39921 274 274 # CZW: 2014-09-12 edit to force in lanl labels 275 275 if ($server eq 'stdscience') { 276 push @{$labels}, 'LAP.PV3.20140730.final';276 # push @{$labels}, 'LAP.PV3.20140730.final'; 277 277 # push @{$labels}, 'LAP.PV3.20140730.local'; 278 278 # push @{$labels}, 'LAP.PV3.20140730.ipp'; … … 284 284 # push @{$labels}, 'LAP.PV3.20140730.diff01'; 285 285 # 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'; 290 291 # 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'; 291 321 } 292 322 … … 964 994 my ($host, $used, $available, $writable, $readable) = @row; 965 995 996 # stsci hosts are no longer with us 997 next if $host =~ /stsci/; 998 966 999 if (($used+$available) == 0) { 967 1000 $underLimit = 1; … … 971 1004 $underLimit = 1; 972 1005 } 1006 973 1007 974 1008 # Col 1: host -
branches/czw_branch/20160809/ippMonitor/czartool/czartool/Nebulous.pm
r35742 r39921 112 112 next; 113 113 } 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 ) { 116 118 117 119 $self->{_totalHosts}++; -
branches/czw_branch/20160809/ippMonitor/czartool/czartool/Pantasks.pm
r38200 r39921 7 7 8 8 my @servers = ( 9 "addstar", 10 "addstarlap", 9 # "addstar", 10 # "addstarlap", 11 "ippqub:stdscience_ws", 11 12 "cleanup", 12 "deepstack",13 "detrend",13 # "deepstack", 14 # "detrend", 14 15 "distribution", 15 16 "pstamp", -
branches/czw_branch/20160809/ippMonitor/czartool/czartool/czarconfig.xml.in
r38211 r39921 49 49 <serverinterval>20 MINUTE</serverinterval> 50 50 <!-- 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> 52 52 <!-- <interestedservers>pstamp</interestedservers> --> 53 53 </roboczar> -
branches/czw_branch/20160809/ippMonitor/def/simplePlotSkycalImage.d
r34436 r39921 4 4 MENU ipp.plots.dat 5 5 6 WHERE skycalRun.state != 'new'6 WHERE skycalRun.state = 'full' 7 7 WHERE skycalRun.skycal_id = skycalResult.skycal_id 8 8 WHERE skycalRun.stack_id = stackRun.stack_id -
branches/czw_branch/20160809/ippMonitor/def/simplePlotStaticskyImage.d
r34436 r39921 4 4 MENU ipp.plots.dat 5 5 6 WHERE staticskyRun.state != 'new'6 WHERE staticskyRun.state = 'full' 7 7 WHERE staticskyRun.sky_id = staticskyResult.sky_id 8 8 WHERE staticskyRun.sky_id = staticskyInput.sky_id -
branches/czw_branch/20160809/ippMonitor/raw/czartool_labels.php
r39498 r39921 80 80 81 81 $servers=array( 82 "addstar", 83 "addstarlap", 82 #"addstar", 83 #"addstarlap", 84 "ippqub:stdscience_ws", 84 85 "cleanup", 85 "detrend",86 #"detrend", 86 87 "distribution", 87 88 "pstamp", … … 270 271 createTableColumnHeader("Status (sec behind master)"); 271 272 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); 273 274 # XXX EAM : problem showReplicationsStatus($REPL_HOST_NEBULOUS, $REPL_USER_NEBULOUS, $REPL_PASSWORD_NEBULOUS, $REPL_DBNAME_NEBULOUS); 274 275 showReplicationsStatus($REPL_HOST_PSTAMP, $REPL_USER_PSTAMP, $REPL_PASSWORD_PSTAMP, $REPL_DBNAME_PSTAMP); 275 276 showReplicationsStatus($REPL_HOST_IPPADMIN, $REPL_USER_IPPADMIN, $REPL_PASSWORD_IPPADMIN, $REPL_DBNAME_IPPADMIN); 276 277 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); 278 279 echo "</table>"; 279 280 … … 313 314 314 315 // list the results 315 while ( dbFetchInto($qry,$row)) {316 while ($qry->fetchInto($row)) { 316 317 317 318 echo "<tr>"; … … 358 359 359 360 // list the results 360 while ( dbFetchInto($qry,$expType)) {361 while ($qry->fetchInto($expType)) { 361 362 362 363 $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'"; 363 364 $qry2 = $projectdb->query($sql); 364 dbFetchInto($qry2,$summit);365 $qry2->fetchInto($summit); 365 366 $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'"; 366 367 $qry2 = $projectdb->query($sql); 367 dbFetchInto($qry2,$mhpcc);368 $qry2->fetchInto($mhpcc); 368 369 369 370 echo "<tr>"; … … 397 398 $qry = $db->query($sql); 398 399 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 399 while ( dbFetchInto($qry,$row)) {400 while ($qry->fetchInto($row)) { 400 401 401 402 $labels[] = $row[0]; … … 621 622 $qry = $db->query($sql); 622 623 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 623 dbFetchInto($qry,$row);624 $qry->fetchInto($row); 624 625 625 626 return $row[0]; … … 655 656 $qry = $db->query($sql); 656 657 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 657 dbFetchInto($qry,$row);658 $qry->fetchInto($row); 658 659 659 660 return $row[0]; … … 673 674 $qry = $db->query($sql); 674 675 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 675 dbFetchInto($qry,$row);676 $qry->fetchInto($row); 676 677 677 678 $pending = $row[0]; … … 730 731 $dates = ""; 731 732 $firstIn = true; 732 while ( dbFetchInto($qry,$row)) {733 while ($qry->fetchInto($row)) { 733 734 734 735 if ($firstIn) { … … 887 888 $qry = $db->query($sql); 888 889 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 889 dbFetchInto($qry,$row);890 $qry->fetchInto($row); 890 891 891 892 $alive = $row[0]; … … 906 907 $qry = $db->query($sql); 907 908 if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";} 908 dbFetchInto($qry,$row);909 $qry->fetchInto($row); 909 910 910 911 return $row[0]; … … 947 948 } 948 949 $res = $dbRepl->query('SHOW SLAVE STATUS'); 949 while ( dbFetchInto($res,$row)) {950 while ($res->fetchInto($row)) { 950 951 # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html 951 952 $errorStatusInMySql = $row[18]; 952 953 $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>"); 954 959 echo "<tr><td>$replDatabaseName</td><td>$replStatus</td></tr>"; 955 960 if ($errorStatusInMySql!=0) { -
branches/czw_branch/20160809/ippMonitor/raw/czartool_servers.php
r28156 r39921 33 33 34 34 $servers=array( 35 "addstar", 35 #"addstar", 36 "ippqub:stdscience_ws", 36 37 "cleanup", 37 "detrend",38 #"detrend", 38 39 "distribution", 39 40 "pstamp", 40 "update",41 "publishing",41 #"update", 42 #"publishing", 42 43 "registration", 43 44 "replication",
Note:
See TracChangeset
for help on using the changeset viewer.
