Changeset 18782 for trunk/DataCheck/Sourcefile.sh

Timestamp:

03/15/17 22:32:26 (8 years ago)

Author:

Daniela Dorner

Message:

in case of mysql-warnings skript is also stopped now (after the last changes they would have stayed unnoticed)

File:

• trunk/DataCheck/Sourcefile.sh (modified) (2 diffs)

trunk/DataCheck/Sourcefile.sh

@@ -118 +118 @@
    finish
 fi
-if ! ls $sqlrc >/dev/null
+if ! ls $sqlrc >/dev/null 2>&1 || [ "$sqlrc" = "" ]
 then
    echo "Can't find sql.rc ($sqlrc)"
@@ -229 +229 @@
       val=
       finish
+   else
+      warning=`echo $val | grep -o -E 'mysql: \[Warning\]'`
+      if [ "$warning" != "" ]
+      then
+         printprocesslog "WARN possible problem to query DB "$db" on host "$ho" with user "$us" (program: $program, function sendquery) "
+         printprocesslog "MYSQLWARN [returncode: "$checkmysql"] "$val
+         val=
+         finish
+      fi
    fi
    if [ "$val" = "NULL" ]