Re: Strange intermittent WebDNA problems
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70074
interpreted = N
texte = > We're only having trouble with the server running OS X 104.11. We have another on red Hat that is still quite stable. We found _some_ relief by moving a few of the bigger db's (3 megs+) to MySQL, but we still have multiple crashes each day. Usually, the worst day is Saturday which is the day of our lightest traffic. Running this script has helped keep the problem mostly invisible to users. #!/bin/sh ## Threshold of CPU % activity ## CPU_LIMIT=145; ## number of times in a row this threshold must be reached ## THRESHOLD=2; ## time between checks ## SLEEP_TIME=5; ## Other non user-edit stuff ## COUNTER=0; AGAIN=0; while true; do { LINE=`ps -aux | grep 'WebCatalog -m' | grep -v grep ` CPU=`echo $LINE | awk '{print int($3)}'` #echo "cpu "$CPU; #echo "n_times "$COUNTER; if [ $CPU -gt $CPU_LIMIT ]; then COUNTER=`expr $COUNTER + 1`; if [ $AGAIN -gt 0 ]; then # echo "again "$AGAIN; if [ $COUNTER -gt $THRESHOLD ]; then PID=`echo $LINE | awk '{print $2}'` date kill -9 $PID COUNTER=0; AGAIN=0; fi else ### [ AGAIN == 0 ] AGAIN=1; fi else ### [ $CPU lt $CPU_LIMIT ] AGAIN=0; COUNTER=0; fi sleep $SLEEP_TIME; } done ~ ~ > Both our servers has been running without a hickup for several > years, and both stopped serving WebDNA pages the very exact same > day about two weeks ago. A restart cured the problem, but ever > since we have seen these intermittent blackouts, with no WebDNA > engine running. > > We have plenty of disk space and plenty of RAM on both servers, and > most of our dbs are really small. Traffic is low these days, since > we are not developing any new sites in WebDNA, and most of the old > ones has been converted to other languages. > > Both servers running Mac OS X, one on 10.3.9 and one 10.4.9. > > Best, > Christer > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
> We're only having trouble with the server running OS X 104.11. We have another on red Hat that is still quite stable. We found _some_ relief by moving a few of the bigger db's (3 megs+) to MySQL, but we still have multiple crashes each day. Usually, the worst day is Saturday which is the day of our lightest traffic. Running this script has helped keep the problem mostly invisible to users. #!/bin/sh ## Threshold of CPU % activity ## CPU_LIMIT=145; ## number of times in a row this threshold must be reached ## THRESHOLD=2; ## time between checks ## SLEEP_TIME=5; ## Other non user-edit stuff ## COUNTER=0; AGAIN=0; while true; do { LINE=`ps -aux | grep 'WebCatalog -m' | grep -v grep ` CPU=`echo $LINE | awk '{print int($3)}'` #echo "cpu "$CPU; #echo "n_times "$COUNTER; if [ $CPU -gt $CPU_LIMIT ]; then COUNTER=`expr $COUNTER + 1`; if [ $AGAIN -gt 0 ]; then # echo "again "$AGAIN; if [ $COUNTER -gt $THRESHOLD ]; then PID=`echo $LINE | awk '{print $2}'` date kill -9 $PID COUNTER=0; AGAIN=0; fi else ### [ AGAIN == 0 ] AGAIN=1; fi else ### [ $CPU lt $CPU_LIMIT ] AGAIN=0; COUNTER=0; fi sleep $SLEEP_TIME; } done ~ ~ > Both our servers has been running without a hickup for several > years, and both stopped serving WebDNA pages the very exact same > day about two weeks ago. A restart cured the problem, but ever > since we have seen these intermittent blackouts, with no WebDNA > engine running. > > We have plenty of disk space and plenty of RAM on both servers, and > most of our dbs are really small. Traffic is low these days, since > we are not developing any new sites in WebDNA, and most of the old > ones has been converted to other languages. > > Both servers running Mac OS X, one on 10.3.9 and one 10.4.9. > > Best, > Christer > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Phil Herring
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Moment of Thanks (1997)
Assigning new CART number (1997)
WebCatalog 3.0.8 is on FTP... (2000)
WebCat2b15MacPlugin - [protect] (1997)
automatically updating all records, one by one in a db (2000)
WCS Newbie question (1997)
Protect (1997)
Upgrading old WebCat Database Files (1997)
Re:Help name our technology! (1997)
decrypt and summ problems (1999)
DataBaseHelper Flawed (1997)
Hosts who have upgraded to v5.0? (2003)
Web Catalog 2 demo (1997)
MS Access (1999)
What am I doing wrong? (2000)
Custom formulas.db (1998)
Still trying to email... (1998)
Setting Cart value (2000)
SiteEdit Pro Update Announcement (1997)
Authenticate (1997)