Re: Strange intermittent WebDNA problems
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70137
interpreted = N
texte = On my side, i found that "Commit Databases Automatically After Modification" was too heavy for large DB with lot of activity: i unchecked it, which made my system faster, and i use a [FLUSHDATABASES] tag in pages i know will be regularely loaded, but not as often as when a database is modified. In both cases, i think that databases are ALL flushed. If the server is rebooted, WebDNA flushes the databases before shutting down. If the server crashes, your last modifications will be lost, yes. It is a matter to compare speed with security. chris On Apr 13, 2008, at 16:06, Tennis De Jong wrote: > I have not seen a pattern. The largest database on the server is > about 15 mb. > > I do have "Commit Databases Automatically After Modification" > checked. What happens to a database with modifications if it is not > committed and the server is rebooted or crashes? Is the newest data > lost? > > Thanks! > Tennis > > > > > On Apr 13, 2008, at 10:39 AM, Christophe Billiottet wrote: >> Can you tell if the DB or templates not found by WebDNA show a >> specific pattern? place/permissions/UID-GID/ or even corruption? >> WebDNA regularely flushes databases and templates on disk. In >> "preferences", you have the option to "Automatically commit >> databases to disk after modification". This can turn into a heavy >> process for large bases with frequent modifications. >> >> chris >> >> >> >> On Apr 13, 2008, at 14:09, Tennis De Jong wrote: >> >>> I had a outage yesterday afternoon around 4pm. In looking at the >>> error logs I noticed that WebDNA started having problems around >>> 1pm. The problems started with not being able to find a >>> "ShoppingCarts" folder in a store that has been running for years. >>> WebDNA then started having problems finding certain .inc files and >>> around 3pm the error log show WebDNA was unable to find and >>> display certain .tpl documents. >>> >>> The server has numerous web sites that share the same .inc >>> documents. WebDNA was able to find the .inc documents for 99% of >>> the sites. It's very random when it decides it can't find a .inc >>> document. The final errors before it totally quit serving pages >>> was it's inability to find some databases. Some of these database >>> have been on the same server for several years and have never been >>> moved or modifieds. It appears WebDNA just decides to stop finding >>> them... >>> >>> Our server is an Xserve dual 1.33 ghz with 2 gb ram. It has a 320 >>> gb hard drive with only 86 gb used. We run iTools 8.2 with WebDNA >>> 6.0a >>> >>> In the past most of our WebDNA outages happened between noon and >>> 2pm. >>> >>> Regards, >>> Tennis >>> >>> >>> >>> >>> >>> >>> >>> On Apr 13, 2008, at 8:50 AM, Karl Schroll wrote: >>>> We had an outage this morning as well, but it was the same >>>> symptom I last reported: template or DB not found for some, but >>>> not all, sites. >>>> >>>> >>>> On Apr 13, 2008, at 4:29 AM, Paul Willis wrote: >>>> >>>>>> OK I had another WebDNA stop this morning at 07:36 GMT - anyone >>>>>> else? >>>>> >>>>> Webdna stopped running for us this morning. CPU was running very >>>>> high. WebDNA Monitor was running but all that was being served >>>>> was "WebDNA server is not running" message. >>>>> >>>>> A Whistleblower alert went off at approx 7:14 am BST (GMT+1) >>>>> although looking in the server system log there were problems >>>>> long before... >>>>> >>>>> Apr 13 05:21:00 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 05:26:04 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:21:58 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:51:18 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:56:19 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 07:04:28 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> >>>>> 2x1GHz XServe running Mac OS X Server 10.4.11 with all the >>>>> software updates. >>>>> 2GB RAM >>>>> 43GB disk space available (of 55GB) >>>>> WebDNA unix-Macintosh OS X Apache Module version 6.0a >>>>> A bunch of smallish dbs nothing too stressful >>>>> No site gets much traffic >>>>> No code changes on any of the sites for ages. >>>>> >>>>> ie: no reason for it to stop working at all that we can see. >>>>> >>>>> Paul >>>>> >>>>> ------------------------------------------------------------- >>>>> 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/ >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> >> ------------------------------------------------------------- >> 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/ >> > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:
On my side, i found that "Commit Databases Automatically After Modification" was too heavy for large DB with lot of activity: i unchecked it, which made my system faster, and i use a [flushdatabases] tag in pages i know will be regularely loaded, but not as often as when a database is modified. In both cases, i think that databases are ALL flushed. If the server is rebooted, WebDNA flushes the databases before shutting down. If the server crashes, your last modifications will be lost, yes. It is a matter to compare speed with security. chris On Apr 13, 2008, at 16:06, Tennis De Jong wrote: > I have not seen a pattern. The largest database on the server is > about 15 mb. > > I do have "Commit Databases Automatically After Modification" > checked. What happens to a database with modifications if it is not > committed and the server is rebooted or crashes? Is the newest data > lost? > > Thanks! > Tennis > > > > > On Apr 13, 2008, at 10:39 AM, Christophe Billiottet wrote: >> Can you tell if the DB or templates not found by WebDNA show a >> specific pattern? place/permissions/UID-GID/ or even corruption? >> WebDNA regularely flushes databases and templates on disk. In >> "preferences", you have the option to "Automatically commit >> databases to disk after modification". This can turn into a heavy >> process for large bases with frequent modifications. >> >> chris >> >> >> >> On Apr 13, 2008, at 14:09, Tennis De Jong wrote: >> >>> I had a outage yesterday afternoon around 4pm. In looking at the >>> error logs I noticed that WebDNA started having problems around >>> 1pm. The problems started with not being able to find a >>> "ShoppingCarts" folder in a store that has been running for years. >>> WebDNA then started having problems finding certain .inc files and >>> around 3pm the error log show WebDNA was unable to find and >>> display certain .tpl documents. >>> >>> The server has numerous web sites that share the same .inc >>> documents. WebDNA was able to find the .inc documents for 99% of >>> the sites. It's very random when it decides it can't find a .inc >>> document. The final errors before it totally quit serving pages >>> was it's inability to find some databases. Some of these database >>> have been on the same server for several years and have never been >>> moved or modifieds. It appears WebDNA just decides to stop finding >>> them... >>> >>> Our server is an Xserve dual 1.33 ghz with 2 gb ram. It has a 320 >>> gb hard drive with only 86 gb used. We run iTools 8.2 with WebDNA >>> 6.0a >>> >>> In the past most of our WebDNA outages happened between noon and >>> 2pm. >>> >>> Regards, >>> Tennis >>> >>> >>> >>> >>> >>> >>> >>> On Apr 13, 2008, at 8:50 AM, Karl Schroll wrote: >>>> We had an outage this morning as well, but it was the same >>>> symptom I last reported: template or DB not found for some, but >>>> not all, sites. >>>> >>>> >>>> On Apr 13, 2008, at 4:29 AM, Paul Willis wrote: >>>> >>>>>> OK I had another WebDNA stop this morning at 07:36 GMT - anyone >>>>>> else? >>>>> >>>>> Webdna stopped running for us this morning. CPU was running very >>>>> high. WebDNA Monitor was running but all that was being served >>>>> was "WebDNA server is not running" message. >>>>> >>>>> A Whistleblower alert went off at approx 7:14 am BST (GMT+1) >>>>> although looking in the server system log there were problems >>>>> long before... >>>>> >>>>> Apr 13 05:21:00 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 05:26:04 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:21:58 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:51:18 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 06:56:19 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> Apr 13 07:04:28 callisto WebDNA[309]: Could not establish >>>>> connection with the module. >>>>> >>>>> 2x1GHz XServe running Mac OS X Server 10.4.11 with all the >>>>> software updates. >>>>> 2GB RAM >>>>> 43GB disk space available (of 55GB) >>>>> WebDNA unix-Macintosh OS X Apache Module version 6.0a >>>>> A bunch of smallish dbs nothing too stressful >>>>> No site gets much traffic >>>>> No code changes on any of the sites for ages. >>>>> >>>>> ie: no reason for it to stop working at all that we can see. >>>>> >>>>> Paul >>>>> >>>>> ------------------------------------------------------------- >>>>> 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/ >>>> >>>> >>>> ------------------------------------------------------------- >>>> 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/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> >> ------------------------------------------------------------- >> 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/ >> > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/
Christophe Billiottet
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:
Disappearing HTML/WebDNA (1998)
email program problem (1998)
Stinkin' [Referrer] (1998)
[WebDNA] thisAutonumber? (2011)
RE: PDF (1999)
Three new problems, maybe a fourth (1997)
Price and Formula.db (2002)
shownext (1997)
db protection on NT (1997)
ShipCost and TaxRate problems (1998)
taxTotal problem (1998)
Locking up with WebCatalog... (1997)
Credit Card Gateways (2005)
problems with 2 tags shakur (1997)
Nav. 4 probs with cart (1997)
WebCat2.0 [format thousands .0f] no go (1997)
WebCatalog/WebMerchant 2.1 (1998)
Help with taxTotal calculation (1998)
blank page from template (1997)
filemaker - orderfile (1997)