Changeset 9128 for trunk/MagicSoft/Mars/datacenter/scripts/dbchk

Timestamp:

08/21/08 18:27:34 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/scripts/dbchk (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/scripts/dbchk

@@ -50 +50 @@
 
 getdbsetup
-alias mymysql='mysql -s -u $us --password=$pw --host=vela $db'
-
-# check for crashed runs, sequences and datasets
+alias mymysql='mysql -s -u $us --password=$pw --host=$ho $db'
+
+# check for crashed nights, runs, sequences and datasets
+echo "Checking if something is crashed on nightly basis" >> $scriptlog 2>&1
+nights=`echo "SELECT fDate FROM SequenceBuildStatus WHERE isnull(fFailedTime) and not isnull(fStartTime) and adddate(fStartTime, Interval 12 HOUR) < Now()" | mymysql`
+if [ ! "$nights" = "" ]
+then
+   printprocesslog "WARN For the following nights something seems to be crashed. Please check manually: $nights"
+   echo "WARN For the following nights something  seems to be crashed. Please check manually: $nights" >> $scriptlog 2>&1
+else
+   echo " Nothing found." >> $scriptlog 2>&1
+fi
+
 echo "Checking if something is crashed on run basis" >> $scriptlog 2>&1
 cruns=`echo "SELECT fRunNumber FROM RunProcessStatus WHERE isnull(fFailedTime) and not isnull(fStartTime) and adddate(fStartTime, Interval 12 HOUR) < Now()" | mymysql`