Re: [BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes]
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106524
interpreted = N
texte = Mammoth !!!My largest DB is 723.000 records (<20 fields) weighing 260 MB - is that =Mammoth to WebDNA?PalleOn 13/04/2011, at 17.47, christophe.billiottet@webdna.us wrote:> If there is 6GB available and you do not work with mammoth databases, =it is probably a loop somewhere: for instance if you [include] A within =B and then B within A, you could possibly create such a RAM problem.>=20> - chris>=20>=20> On Apr 13, 2011, at 12:32, Palle Bo Nielsen wrote:>=20>> Dear Christophe,>>=20>> I would like to do that but it would be approx. 5.000 lines of code.>>=20>> Btw, if RAM should be the problem despite the facts from earlier in =this thread. What would be the most optimal settings in the WebDNA Admin =area? Furthermore, would there be any recommendations related to =settings of the Mac OS X Server Admin or any other area to avoid =memory-problems like this?>>=20>> Br>> Palle>>=20>>=20>> On 13/04/2011, at 17.25, christophe.billiottet@webdna.us wrote:>>=20>>> Certainly! WebDNA runs fine with a 64MB VPS server. You would =probably have to share with us the code of the page =/Library/WebServer/Documents/sites/macnyt/forum/default.tpl. Chances are =there is a problem with it.>>>=20>>> - chris>>>=20>>>=20>>> On Apr 13, 2011, at 12:13, Palle Bo Nielsen wrote:>>>=20>>>> Dear Christophe,>>>>=20>>>> On this particular server, there is only 4 sites running (3 which =are very passive and 1 which is fairly active).>>>>=20>>>> Applications running...>>>>=20>>>> - Apache (Mac OS X Server incl. Mail Service activated - low =activity)>>>> - WebDNA (500 MB RAM - 46 DB's)>>>> - ImageMagick (almost passive)>>>> - Intermapper (4 MB RAM)>>>> - Simon (20 MB RAM)>>>>=20>>>> Total Active Memory Footprint ~ 2 GB. 6 GB Unused - Total 8 GB RAM>>>>=20>>>> WebDNA should have plenty of RAM at it's disposal>>>>=20>>>> ??>>>>=20>>>> Palle>>>>=20>>>>=20>>>>=20>>>> On 13/04/2011, at 13.03, christophe.billiottet@webdna.us wrote:>>>>=20>>>>> Hi Palle! how many websites on your server? do you run other =applications than apache and WebDNA, like PHP, MySQL, a mailserver or =others? did you check in your WebDNA administration how many bases are =open in RAM? is the RAM problem coincides with the server crash?>>>>>=20>>>>> - chris=20>>>>>=20>>>>>=20>>>>> On Apr 13, 2011, at 7:42, Palle Bo Nielsen wrote:>>>>>=20>>>>>> Hi Christipher et al,>>>>>>=20>>>>>> Well now the error reporting system is actually reporting.>>>>>>=20>>>>>> I get this error...:>>>>>>=20>>>>>> --- snip --->>>>>> 04/13/201106:34:27SHOWPAGE091.153.253.064=Error: WebCatalog does not have enough memory to complete this command=/forum/default.tpl=/Library/WebServer/Documents/sites/macnyt/forum/default.tpl>>>>>> --- snip --->>>>>>=20>>>>>> How does that compute since the server has 8GB RAM at it's =disposal?>>>>>>=20>>>>>> I hope to get some inspiration on this one since my server is =crashing several time every 24H.>>>>>>=20>>>>>> Any good ideas/suggestion...?>>>>>>=20>>>>>> Palle>>>>>>=20>>>>>>=20>>>>>> On 10/04/2011, at 16.28, christophe.billiottet@webdna.us wrote:>>>>>>=20>>>>>>> To me, it looks like a code error loop that would be logged by =the "Log Error Messages" turned on.>>>>>>>=20>>>>>>> - chris>>>>>>>=20>>>>>>>=20>>>>>>> On Apr 10, 2011, at 3:25, Palle Bo Nielsen wrote:>>>>>>>=20>>>>>>>> God morning all (Danish time),>>>>>>>>=20>>>>>>>> I posted this one to the talk-list some time ago, but it did =not get any reaction. So now I repost it again since my problems i =increasing although there has not been any changes to the server config =or WebDNA code.>>>>>>>>=20>>>>>>>> I hope to get some good ideas from the creative community.>>>>>>>>=20>>>>>>>> All the best>>>>>>>> Palle>>>>>>>>=20>>>>>>>>=20>>>>>>>>=20>>>>>>>>=20>>>>>>>> Begin forwarded message:>>>>>>>>=20>>>>>>>>> From: Palle Bo Nielsen
>>>>>>>>> Date: 26. mar 2011 15.20.00 CET>>>>>>>>> To: talk@webdna.us>>>>>>>>> Subject: [WebDNA] [BULK] WebDNA discovery in the Console - =[having many crashes]>>>>>>>>> Reply-To: >>>>>>>>>=20>>>>>>>>> Hi all,>>>>>>>>>=20>>>>>>>>> In the past weeks I have experienced irregularities on my =server which causes WebDNA to hang with a log of CPU usage (more than =100% constantly) and it will not resolve before I kill the process or =restart the server (CPU). This is of cause bad since the visitors are =not allowed to visit the websites on the server while this is happening.>>>>>>>>>=20>>>>>>>>> Due to this I have done som inspection to the Console logs and =found the following which I find interesting and suppecious. Are any of =you fellow list-members able to help me out here, weather this could =have anything to do woth my descibtion or maybe give a good advise based =on the following to log snippets.>>>>>>>>>=20>>>>>>>>> SYSTEM.LOG>>>>>>>>> ---- start snippet ---->>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:56: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:58: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:57 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:57 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:58: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:58 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:59: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> ---- end snippet ---->>>>>>>>>=20>>>>>>>>> Every time my web-service goes to it's knees a lot of these =one are to be found in the access_log - and I mean MANY abd they dont =disappear before a restart of service or CPU.>>>>>>>>>=20>>>>>>>>> APACHE2 - ACCESS_LOG>>>>>>>>> ---- start snippet ---->>>>>>>>> ::1 - - [26/Mar/2011:09:17:01 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:16:30 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:16:57 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:38 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:45 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:38 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:41 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:40 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:41 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:22 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:17 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:20 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ---- end snippet ---->>>>>>>>>=20>>>>>>>>> All the best>>>>>>>>> Palle--------------------------------------------------------->>>>>>>>> This message is sent to you because you are subscribed to>>>>>>>>> the mailing list .>>>>>>>>> To unsubscribe, E-mail to: >>>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>>>>> Bug Reporting: support@webdna.us>>>>>>>>=20>>>>>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>>>>>>>=20>>>>>>> --------------------------------------------------------->>>>>>> This message is sent to you because you are subscribed to>>>>>>> the mailing list .>>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>>> Bug Reporting: support@webdna.us>>>>>>=20>>>>>> --------------------------------------------------------->>>>>> This message is sent to you because you are subscribed to>>>>>> the mailing list .>>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>> Bug Reporting: support@webdna.us>>>>>=20>>>>> --------------------------------------------------------->>>>> This message is sent to you because you are subscribed to>>>>> the mailing list .>>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>> Bug Reporting: support@webdna.us>>>>=20>>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Mammoth !!!My largest DB is 723.000 records (<20 fields) weighing 260 MB - is that =Mammoth to WebDNA?PalleOn 13/04/2011, at 17.47, christophe.billiottet@webdna.us wrote:> If there is 6GB available and you do not work with mammoth databases, =it is probably a loop somewhere: for instance if you [include] A within =B and then B within A, you could possibly create such a RAM problem.>=20> - chris>=20>=20> On Apr 13, 2011, at 12:32, Palle Bo Nielsen wrote:>=20>> Dear Christophe,>>=20>> I would like to do that but it would be approx. 5.000 lines of code.>>=20>> Btw, if RAM should be the problem despite the facts from earlier in =this thread. What would be the most optimal settings in the WebDNA Admin =area? Furthermore, would there be any recommendations related to =settings of the Mac OS X Server Admin or any other area to avoid =memory-problems like this?>>=20>> Br>> Palle>>=20>>=20>> On 13/04/2011, at 17.25, christophe.billiottet@webdna.us wrote:>>=20>>> Certainly! WebDNA runs fine with a 64MB VPS server. You would =probably have to share with us the code of the page =/Library/WebServer/Documents/sites/macnyt/forum/default.tpl. Chances are =there is a problem with it.>>>=20>>> - chris>>>=20>>>=20>>> On Apr 13, 2011, at 12:13, Palle Bo Nielsen wrote:>>>=20>>>> Dear Christophe,>>>>=20>>>> On this particular server, there is only 4 sites running (3 which =are very passive and 1 which is fairly active).>>>>=20>>>> Applications running...>>>>=20>>>> - Apache (Mac OS X Server incl. Mail Service activated - low =activity)>>>> - WebDNA (500 MB RAM - 46 DB's)>>>> - ImageMagick (almost passive)>>>> - Intermapper (4 MB RAM)>>>> - Simon (20 MB RAM)>>>>=20>>>> Total Active Memory Footprint ~ 2 GB. 6 GB Unused - Total 8 GB RAM>>>>=20>>>> WebDNA should have plenty of RAM at it's disposal>>>>=20>>>> ??>>>>=20>>>> Palle>>>>=20>>>>=20>>>>=20>>>> On 13/04/2011, at 13.03, christophe.billiottet@webdna.us wrote:>>>>=20>>>>> Hi Palle! how many websites on your server? do you run other =applications than apache and WebDNA, like PHP, MySQL, a mailserver or =others? did you check in your WebDNA administration how many bases are =open in RAM? is the RAM problem coincides with the server crash?>>>>>=20>>>>> - chris=20>>>>>=20>>>>>=20>>>>> On Apr 13, 2011, at 7:42, Palle Bo Nielsen wrote:>>>>>=20>>>>>> Hi Christipher et al,>>>>>>=20>>>>>> Well now the error reporting system is actually reporting.>>>>>>=20>>>>>> I get this error...:>>>>>>=20>>>>>> --- snip --->>>>>> 04/13/201106:34:27SHOWPAGE091.153.253.064=Error: WebCatalog does not have enough memory to complete this command=/forum/default.tpl=/Library/WebServer/Documents/sites/macnyt/forum/default.tpl>>>>>> --- snip --->>>>>>=20>>>>>> How does that compute since the server has 8GB RAM at it's =disposal?>>>>>>=20>>>>>> I hope to get some inspiration on this one since my server is =crashing several time every 24H.>>>>>>=20>>>>>> Any good ideas/suggestion...?>>>>>>=20>>>>>> Palle>>>>>>=20>>>>>>=20>>>>>> On 10/04/2011, at 16.28, christophe.billiottet@webdna.us wrote:>>>>>>=20>>>>>>> To me, it looks like a code error loop that would be logged by =the "Log Error Messages" turned on.>>>>>>>=20>>>>>>> - chris>>>>>>>=20>>>>>>>=20>>>>>>> On Apr 10, 2011, at 3:25, Palle Bo Nielsen wrote:>>>>>>>=20>>>>>>>> God morning all (Danish time),>>>>>>>>=20>>>>>>>> I posted this one to the talk-list some time ago, but it did =not get any reaction. So now I repost it again since my problems i =increasing although there has not been any changes to the server config =or WebDNA code.>>>>>>>>=20>>>>>>>> I hope to get some good ideas from the creative community.>>>>>>>>=20>>>>>>>> All the best>>>>>>>> Palle>>>>>>>>=20>>>>>>>>=20>>>>>>>>=20>>>>>>>>=20>>>>>>>> Begin forwarded message:>>>>>>>>=20>>>>>>>>> From: Palle Bo Nielsen >>>>>>>>> Date: 26. mar 2011 15.20.00 CET>>>>>>>>> To: talk@webdna.us>>>>>>>>> Subject: [WebDNA] [BULK] WebDNA discovery in the Console - =[having many crashes]>>>>>>>>> Reply-To: >>>>>>>>>=20>>>>>>>>> Hi all,>>>>>>>>>=20>>>>>>>>> In the past weeks I have experienced irregularities on my =server which causes WebDNA to hang with a log of CPU usage (more than =100% constantly) and it will not resolve before I kill the process or =restart the server (CPU). This is of cause bad since the visitors are =not allowed to visit the websites on the server while this is happening.>>>>>>>>>=20>>>>>>>>> Due to this I have done som inspection to the Console logs and =found the following which I find interesting and suppecious. Are any of =you fellow list-members able to help me out here, weather this could =have anything to do woth my descibtion or maybe give a good advise based =on the following to log snippets.>>>>>>>>>=20>>>>>>>>> SYSTEM.LOG>>>>>>>>> ---- start snippet ---->>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:56: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:56 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:58: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:57 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:57 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:58: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:58 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> Mar 26 05:36:59: --- last message repeated 499 times --->>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: *** process 125 exceeded =500 log message per second limit - remaining messages this second =discarded ***>>>>>>>>> Mar 26 05:36:59 minione WebDNA[125]: Could not establish =connection with the module.=20>>>>>>>>> ---- end snippet ---->>>>>>>>>=20>>>>>>>>> Every time my web-service goes to it's knees a lot of these =one are to be found in the access_log - and I mean MANY abd they dont =disappear before a restart of service or CPU.>>>>>>>>>=20>>>>>>>>> APACHE2 - ACCESS_LOG>>>>>>>>> ---- start snippet ---->>>>>>>>> ::1 - - [26/Mar/2011:09:17:01 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:16:30 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:16:57 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:38 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:45 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:38 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:41 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:40 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:41 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:22 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:17 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ::1 - - [26/Mar/2011:09:17:20 +0100] "OPTIONS * HTTP/1.0" 200 =->>>>>>>>> ---- end snippet ---->>>>>>>>>=20>>>>>>>>> All the best>>>>>>>>> Palle--------------------------------------------------------->>>>>>>>> This message is sent to you because you are subscribed to>>>>>>>>> the mailing list .>>>>>>>>> To unsubscribe, E-mail to: >>>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>>>>> Bug Reporting: support@webdna.us>>>>>>>>=20>>>>>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us>>>>>>>=20>>>>>>> --------------------------------------------------------->>>>>>> This message is sent to you because you are subscribed to>>>>>>> the mailing list .>>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>>> Bug Reporting: support@webdna.us>>>>>>=20>>>>>> --------------------------------------------------------->>>>>> This message is sent to you because you are subscribed to>>>>>> the mailing list .>>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>>> Bug Reporting: support@webdna.us>>>>>=20>>>>> --------------------------------------------------------->>>>> This message is sent to you because you are subscribed to>>>>> the mailing list .>>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>> Bug Reporting: support@webdna.us>>>>=20>>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Palle Bo Nielsen
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:
[WebDNA] orderfile - encrypt test request (2011)
RE: Missing contexts on NT (1997)
dynamic giffing. (2000)
Help formatting search results w/ table (1997)
Storebuilder Seems to have just died (2003)
[/application] error? (1997)
Date Range search (1997)
looping table rows (1999)
Ghostly cached webpage (2000)
WebCat & Backoffice Solution? (2000)
Upgrading old WebCat Database Files (1997)
EIMS Problems (1997)
Upcoming 2.1 Release and PCS Committment (1997)
multi-paragraph fields (1997)
NT Version on IIS 4.0 (1997)
Newbie Tax Question (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
WebDNA Writer Needed (1997)
POS (2000)
WebCat2 beta 11 - new prefs ... (1997)