Changeset 9128 for trunk

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/scripts/dbchk (modified) (1 diff)
• datacenter/scripts/dowebplots (modified) (1 diff)
• datacenter/scripts/scriptlauncher (modified) (1 diff)

trunk/MagicSoft/Mars/Changelog

@@ -23 +23 @@
    * datacenter/db/plotdb.php:
      - changed input field from 6 to 8 digits
+
+   * datacenter/scripts/dbchk:
+     - added check if something on nightly basis failed
+
+   * datacenter/scripts/dowebplots:
+     - fixed sequencepath in rsync
 
 

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`

trunk/MagicSoft/Mars/datacenter/scripts/dowebplots

@@ -133 +133 @@
 
 echo "do rsync for sequence files" >> $scriptlog 2>&1
-rsync -av --delete $sequencepath/ $webpath/sequences >> $scriptlog 2>&1
+rsync -av --delete $sequpath/ $webpath/sequences >> $scriptlog 2>&1
 
 echo "do rsync for dataset files" >> $scriptlog 2>&1

trunk/MagicSoft/Mars/datacenter/scripts/scriptlauncher

@@ -40 +40 @@
 
 num=$#
-echo "$num scripts have to be launched" #>> $scriptlog 2>&1
+echo "$num scripts have to be launched" >> $scriptlog 2>&1
 i=1