Re: Strange intermittent WebDNA problems
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70138
interpreted = N
texte = Note [COMMITDATABASE db=FileName] is much better in flushing only the database you want. chris On Apr 13, 2008, at 16:33, Christophe Billiottet wrote: > 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/ ------------------------------------------------------------- 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:
Note [COMMITDATABASE db=FileName] is much better in flushing only the database you want. chris On Apr 13, 2008, at 16:33, Christophe Billiottet wrote: > 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/ ------------------------------------------------------------- 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:
nested showif? (1998)
[WebDNA] HTTP crashes (2010)
[WebDNA] listfiles bugs on linux (2009)
Please post more "exceptions to the rules" ... (2005)
More on the email templates (1997)
WebCat2 - [format thousands] (1997)
WebCatalog can't find database (1997)
Converting characters to numbers ... (1997)
OBJECT (2001)
ShowNext (1997)
shipCost problems (2000)
WebCatalog2 Feature Feedback (1996)
[WebDNA] High-profile WebDNA sites? (2008)
Custom WebCat Prefs ... (1997)
Format of Required fields error message (1997)
Great product and great job ! (1997)
WebCat2 several catalogs? (1997)
(1997)
Country & Ship-to address & other fields ? (1997)
[cart] not being interpreted inside [founditems] (1997)