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:
New commands in Final candidate (1997)
shipcost (1997)
Variables for chat (1997)
Search all Fields in a db (1997)
Needed, Freelance Web Developer (2007)
WebCat2b13MacPlugIn - More limits on [include] (1997)
typhoon... (1997)
Single Link browsing (1997)
New public beta available (1997)
Summing fields (1997)
Can you do this??? and other stuff (1997)
Table code broken? (2004)
Plugin or CGI or both (1997)
php vs WebCatalog (2000)
Can't Search field (1998)
Make sure I understand this??? (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
[OT] Form POSTing with LONG variable (2007)
More help for discount pricing (1998)
Shipcost update problem (1997)