Changeset 9100 for trunk/MagicSoft/Mars/datacenter/scripts

Timestamp:

08/05/08 17:33:16 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/scripts

Files:

• condorstatistics (modified) (2 diffs)
• dbchk (modified) (3 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/condorstatistics

@@ -64 +64 @@
    case $check0 in 
       1)   echo " check0=$check0 -> everything ok -> move files" >> $scriptlog 2>&1
-           printprocesslog "INFO plots successfully produced"
+           printprocesslog "INFO condor statistic filled succesfully"
            day=`basename $date`
            cd `dirname $date`
@@ -79 +79 @@
            cd $mars
            ;;
-      *)   echo " check0=$check0 -> ERROR -> couldn't create plots -> exit" >> $scriptlog 2>&1
-           printprocesslog "ERROR producing plots failed"
+      *)   echo " check0=$check0 -> ERROR -> couldn't fill condor statistic to DB -> exit" >> $scriptlog 2>&1
+           printprocesslog "ERROR filling condor statistic to DB failed"
            finish >> $scriptlog 2>&1
            ;;

trunk/MagicSoft/Mars/datacenter/scripts/dbchk

@@ -163 +163 @@
 
 # CHECK 3
-echo "Checking if all sequences from Sequences exists RunData" >> $scriptlog 2>&1
+echo "Checking if all sequences from Sequences exist RunData" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM Sequences GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -177 +177 @@
 
 # CHECK 4
-echo "Checking if all sequences from RunData exists in Sequences" >> $scriptlog 2>&1
+echo "Checking if all sequences from RunData exist in Sequences" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -190 +190 @@
 done
 
+# CHECK 5
+echo "Checking if all sequences from RunData exist in SequenceProcessStatus" >> $scriptlog 2>&1
+sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
+for sequence in $sequences
+do
+   var=`echo SELECT fSequenceFirst FROM SequenceProcessStatus WHERE fSequenceFirst=$sequence | mymysql`
+   if ! [ "$sequence" = "$var" ]
+   then
+      echo "Sequence $sequence exists in RunData but not in SequenceProcessStatus." >> $scriptlog 2>&1
+      printprocesslog "Sequence $sequence exists in RunData but not in SequenceProcessStatus (DB)." 
+      continue
+   fi
+done
+
 finish >> $scriptlog 2>&1