Changeset 39804

Timestamp:

Nov 4, 2016, 5:51:29 PM (10 years ago)

Author:

mhuber

Message:

(MEH) fixing error report for db repl if null sec_behind and misc old changes of others

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (12 diffs)

trunk/ippMonitor/raw/czartool_labels.php

@@ -80 +80 @@
 
 $servers=array(
-        "addstar",
-        "addstarlap",
+        #"addstar",
+        #"addstarlap",
+        "ippqub:stdscience_ws",
         "cleanup",
-        "detrend",
+        #"detrend",
         "distribution",
         "pstamp",
@@ -270 +271 @@
       createTableColumnHeader("Status (sec behind master)");
       showReplicationsStatus($REPL_HOST_GPC1, $REPL_USER_GPC1, $REPL_PASSWORD_GPC1, $REPL_DBNAME_GPC1);
-
+      showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
       # XXX EAM : problem showReplicationsStatus($REPL_HOST_NEBULOUS, $REPL_USER_NEBULOUS, $REPL_PASSWORD_NEBULOUS, $REPL_DBNAME_NEBULOUS);
       showReplicationsStatus($REPL_HOST_PSTAMP, $REPL_USER_PSTAMP, $REPL_PASSWORD_PSTAMP, $REPL_DBNAME_PSTAMP);
       showReplicationsStatus($REPL_HOST_IPPADMIN, $REPL_USER_IPPADMIN, $REPL_PASSWORD_IPPADMIN, $REPL_DBNAME_IPPADMIN);
       showReplicationsStatus($REPL_HOST_ISP, $REPL_USER_ISP, $REPL_PASSWORD_ISP, $REPL_DBNAME_ISP);
-      showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
+##      showReplicationsStatus($REPL_HOST_NEBULOUS_SECONDARY, $REPL_USER_NEBULOUS_SECONDARY, $REPL_PASSWORD_NEBULOUS_SECONDARY, $REPL_DBNAME_NEBULOUS_SECONDARY);
       echo "</table>";
 
@@ -313 +314 @@
 
     // list the results
-    while (dbFetchInto($qry, $row)) {
+    while ($qry->fetchInto($row)) {
 
         echo "<tr>";
@@ -358 +359 @@
 
     // list the results
-    while (dbFetchInto($qry, $expType)) {
+    while ($qry->fetchInto($expType)) {
 
         $sql = "SELECT COUNT(*) FROM summitExp WHERE dateobs > '$date' AND exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
-      dbFetchInto($qry2, $summit);
+        $qry2->fetchInto($summit);
         $sql = "SELECT COUNT(*) FROM summitExp JOIN rawExp ON summitExp.exp_name = rawExp.exp_name WHERE summitExp.dateobs > '$date' AND summitExp.exp_type = '$expType[0]'";
         $qry2 = $projectdb->query($sql);
-      dbFetchInto($qry2, $mhpcc);
+        $qry2->fetchInto($mhpcc);
 
         echo "<tr>";
@@ -397 +398 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    while (dbFetchInto($qry, $row)) {
+    while ($qry->fetchInto($row)) {
 
         $labels[] = $row[0];
@@ -621 +622 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    dbFetchInto($qry, $row);
+    $qry->fetchInto($row);
 
     return $row[0];
@@ -655 +656 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    dbFetchInto($qry, $row);
+    $qry->fetchInto($row);
 
     return $row[0];
@@ -673 +674 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    dbFetchInto($qry, $row);
+    $qry->fetchInto($row);
 
     $pending = $row[0];
@@ -730 +731 @@
     $dates = ""; 
     $firstIn = true;
-    while (dbFetchInto($qry, $row)) {
+    while ($qry->fetchInto($row)) {
 
         if ($firstIn) {
@@ -887 +888 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    dbFetchInto($qry, $row);
+    $qry->fetchInto($row);
 
     $alive = $row[0];
@@ -906 +907 @@
     $qry = $db->query($sql);
     if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
-    dbFetchInto($qry, $row);
+    $qry->fetchInto($row);
 
     return $row[0];
@@ -947 +948 @@
     }
     $res = $dbRepl->query('SHOW SLAVE STATUS');
-    while (dbFetchInto($res, $row)) {
+    while ($res->fetchInto($row)) {
         # Have a look for Last_Errno in http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
         $errorStatusInMySql = $row[18];
         $sec_behind = $row[32];
-        $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"<font color=\"red\">PROBLEM</font>");
+        if ($sec_behind===NULL) {
+            $sec_behind = 99999999;
+            $errorStatusInMySql = 999999999;
+        }   
+        $replStatus = ($errorStatusInMySql==0?"OK ($sec_behind)":"<font style=\"BACKGROUND-COLOR: yellow\"  color=\"red\">PROBLEM</font>");
         echo "<tr><td>$replDatabaseName</td><td>$replStatus</td></tr>";
         if ($errorStatusInMySql!=0) {