Re: Strange intermittent WebDNA problems
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70078
interpreted = N
texte = Christer Olsson wrote: >> >> I think it would be wise for the group if these scenerios could >> accompany details like: >> >> * Database size (MB) >> * Load ("heavy" being transactions per seconds or something) >> * Is safe-write on or not? >> * Are you finding mal-formed record sets when looking at the .db? >> * Does this database interrelate with other .db's? >> * Do you find any difference of using [exclusivelock..] as apposed >> to not using it? > > 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 Christer, since this is a reply to my post... it is odd that two of your servers started experiencing the problem the same time. Are those servers using a sync to a time server? Beyond that, I just don't think any of you guys/gals are posting enough details to make any sort of rational judgment of what is going on. I think I'll defer to Steve Craig's assessment and just blame it on SMSI attacking our servers! ;-) O.K., seriously, without any more info, I can only speak generally. In my experience, 99% of mysterious CPU pegs and process build ups have to do with databases and tables. (loops are usually not too mysterious). Formulas.db? I will nickname that .db "Notorious F". As I believe Christophe mentioned earlier somewhere (and no one responded with any info)... what do you get when you do a top? Do you see two WebCatalog processes running (sometimes WebDNAMonitor, sometimes WebCatalog depending on build)? Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 770-3822 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:
Christer Olsson wrote: >> >> I think it would be wise for the group if these scenerios could >> accompany details like: >> >> * Database size (MB) >> * Load ("heavy" being transactions per seconds or something) >> * Is safe-write on or not? >> * Are you finding mal-formed record sets when looking at the .db? >> * Does this database interrelate with other .db's? >> * Do you find any difference of using [exclusivelock..] as apposed >> to not using it? > > 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 Christer, since this is a reply to my post... it is odd that two of your servers started experiencing the problem the same time. Are those servers using a sync to a time server? Beyond that, I just don't think any of you guys/gals are posting enough details to make any sort of rational judgment of what is going on. I think I'll defer to Steve Craig's assessment and just blame it on SMSI attacking our servers! ;-) O.K., seriously, without any more info, I can only speak generally. In my experience, 99% of mysterious CPU pegs and process build ups have to do with databases and tables. (loops are usually not too mysterious). formulas.db? I will nickname that .db "Notorious F". As I believe Christophe mentioned earlier somewhere (and no one responded with any info)... what do you get when you do a top? Do you see two WebCatalog processes running (sometimes WebDNAMonitor, sometimes WebCatalog depending on build)? Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 770-3822 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/
Donovan Brooke
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:
A Trigger Question (2000)
Extended [Convertchars] needed (1997)
2.0 Beta (1997)
Sort Order on a page search (1997)
search for all (1998)
Getting Total Quantity (1997)
dbQuickView 2.0 (2005)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Is this possible in simple search? question? (1998)
Whats going on with my SERIAL NUMBER??? (1998)
html email again... (2001)
errormessages.db (1997)
Help with Repost Data msg from form (1997)
RE: WebCat name recognition (was MacFinder -- a new WebDNAweb site) (1998)
Permission denied for append context (2004)
code to phantom spacing (2001)
Separate SSL Server (1997)
Running 2 two WebCatalog.acgi's (1996)
wierd crashes for multi-sendmails on NT (1997)
WebCat for Site Search? (1997)