Changeset 18762

Timestamp:

02/18/17 14:08:40 (8 years ago)

Author:

Daniela Dorner

Message:

catch mysql errors and print them to processlog

File:

• trunk/DataCheck/Sourcefile.sh (modified) (1 diff)

trunk/DataCheck/Sourcefile.sh

@@ -188 +188 @@
    getdbsetup
    printprocesslog "DEBUG sendquery QUERY: "$query
-   if ! val=`mysql $sqlpwfile -s -u $us $pw --host=$ho $db -e " $query "`
-   then
-      printprocesslog "ERROR could not query DB "$db" on host "$ho" with user "$us
-      #printprocesslog "ERROR could not query db (program: $program, function sendquery)"
-      #return 1 #why???
+   val=`mysql $sqlpwfile -s -u $us $pw --host=$ho $db -e " $query " 2>&1`
+   checkmysql=`echo $?`
+   if [ $checkmysql -gt 0 ]
+   then
+      printprocesslog "ERROR could not query DB "$db" on host "$ho" with user "$us" (program: $program, function sendquery) "
+      printprocesslog "MYSQLERROR [returncode: "$checkmysql"] "$val
+      error=`echo $val | grep -E -o 'ERROR [1-9]{1,4}' | grep -E -o '[1-9]{1,4}'`
+      # here possible reaction to mysql error
       finish
    fi