Changeset 13579 for trunk/DataCheck

Timestamp:

05/07/12 10:39:53 (13 years ago)

Author:

Daniela Dorner

Message:

added check for empty return of mysql

File:

• trunk/DataCheck/Monitoring/CheckStatus.sh (modified) (2 diffs)

trunk/DataCheck/Monitoring/CheckStatus.sh

@@ -36 +36 @@
    query="SELECT Count(*) FROM "$step"Status "$where
    num=`sendquery`
-   if [ $num -gt 0 ]
-   then
-      printprocesslog "WARN found in "$step" "$num" rows with errors."
-      sel=$selstart", '(', fReturnCode, ')')"
-      query="SELECT "$sel" FROM "$step"Status "$where
-      sendquery | mail -s 'found failed jobs in '$step $erradrs
-      printprocesslog "INFO sent mail about failed jobs in "$step" to "$erradrs
+   if [ "$num" == "" ]
+   then 
+      printprocesslog "WARN could not get number of failed jobs from the DB."
+   else
+      if [ $num -gt 0 ]
+      then
+         printprocesslog "WARN found in "$step" "$num" rows with errors."
+         sel=$selstart", '(', fReturnCode, ')')"
+         query="SELECT "$sel" FROM "$step"Status "$where
+         sendquery | mail -s 'found failed jobs in '$step $erradrs
+         printprocesslog "INFO sent mail about failed jobs in "$step" to "$erradrs
+      fi
    fi
 
@@ -54 +59 @@
    query="SELECT Count(*) FROM "$step"Status "$where
    num=`sendquery`
-   if [ $num -gt 0 ]
-   then
-      printprocesslog "WARN found in "$step" "$num" crashed jobs."
-      sel=$selstart", '(', fStartTime, ')')"
-      query="SELECT "$sel" FROM "$step"Status "$where
-      sendquery | mail -s 'found crashed jobs in '$step $erradrs
-      printprocesslog "INFO sent mail about crashed jobs in "$step" to "$erradrs
+   if [ "$num" == "" ]
+   then 
+      printprocesslog "WARN could not get number of crashed jobs from the DB."
+   else
+      if [ $num -gt 0 ]
+      then
+         printprocesslog "WARN found in "$step" "$num" crashed jobs."
+         sel=$selstart", '(', fStartTime, ')')"
+         query="SELECT "$sel" FROM "$step"Status "$where
+         sendquery | mail -s 'found crashed jobs in '$step $erradrs
+         printprocesslog "INFO sent mail about crashed jobs in "$step" to "$erradrs
+      fi
    fi
 done