Re: [WebDNA] WebDNA slow processing
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107736
interpreted = N
texte = I think 3 is "ElapsedTime" while 4 is "AvailableMemory" (a negative = number would show WebDNA does not have enough RAM available) 6 would be "pathArgs" - chris On Nov 26, 2011, at 12:09, William DeVaul wrote: > Can you tell us what column 3, 4, and 6 are used for? >=20 > On Sat, Nov 26, 2011 at 7:25 AM,
= wrote: >> Based on what you copy here, the problem seems to be a RAM problem: = databases and templates are loaded in RAM by WebDNA, and there might be = other applications running on your server that could need lots of memory = (Safari is a good example). You can type "free" in your terminal to see = the avaiable RAM, check the swap usage (this would tremendously slow = things down) or even use your "Activity Monitor" application >>=20 >>=20 >> Here is the .debug exemple, broken in lines to simplify the reading >>=20 >> The webdna.debug, activated by "Technical Support Information" >>=20 >> 1.- 11/18/08 >> 2.- 14:20:09 >> 3.- 11 >> 4.- -944508928 >> 5.- 024.183.098.016 >> 6.- >> 7.- /var/www/cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 8.- Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.7) = Gecko/20050416 >> 9.- login >> 10.- password >> 11.- = http://www.domain.com/cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 12.- /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 13.- /var/www/html/ >> 14.- = command=3DAdminPut&InterpretAll=3DF&SerialNumber=3D************&SerialNumb= er2=3Dnone&DateFormat=3D%25m%2F%25d%2F%25Y&TimeFormat=3D%25H%3A%25M%3A%25S= &ReadDateFormat=3Dmdy&MathUseDateFormat=3D0&MaxFound=3D16000&CenturyBreak=3D= 0&LimitThreads=3D25&ZapNulls=3D0&PreParseScript=3D1&PostParseScript=3D0&Ca= cheTemplates=3DF&CheckTemplateInterval=3D2&AutoCommit=3DT&DeadlockSeconds=3D= 20&SafeWriteDatabase=3D1&CommandSecurity=3DT&CommandsAllowed=3DShowPage%2C= +FlushCache%2C+ShowCart%2C+Add%2C+Remove%2C+NewCart%2C+Purchase%2C+NewCart= Search%2C+Clear&CheckTemplateExtensions=3DT&ValidTemplateExtensions=3D.tmp= l+.tpl+.tp2+.dna+.html+.htm&CheckDatabaseExtensions=3DT&ValidDatabaseExten= sions=3D.db%2C+.txt&LineItemChangePassword=3Dftj8*%289&AbsolutePath=3D0&In= secureFileMode=3D666&SecureFileMode=3D660&DebugLevel=3D0&CatchSignal=3D0&L= ogError=3D0&DisplayError=3D1 >> 15.- = __utmz=3D238728966.1225062648.23.3.utmcsr=3Dstore.webdna.us|utmccn=3D(refe= rral)|utmcmd=3Dreferral|utmcct=3D/default.tpl&__utma=3D238728966.114012872= 0646497800.1222376773.1226506042.1226682779.28& >> 16.- Host=3D = www.domain.com&User-Agent=3DMozilla/5.0%20%28Macintosh%3B%20U%3B%20PPC%20M= ac%20OS%20X%20Mach-O%3B%20en-US%3B%20rv%3A1.7.7%29%20Gecko/20050416&Accept= =3Dtext/xml%2Capplication/xml%2Capplication/xhtml%2Bxml%2Ctext/html%3Bq%3D= 0.9%2Ctext/plain%3Bq%3D0.8%2Cimage/png%2C%2A/%2A%3Bq%3D0.5&Accept-Language= =3Den-us%2Cen%3Bq%3D0.5&Accept-Encoding=3Dgzip%2Cdeflate&Accept-Charset=3D= ISO-8859-1%2Cutf-8%3Bq%3D0.7%2C%2A%3Bq%3D0.7&Keep-Alive=3D300&Connection=3D= keep-alive&Referer=3Dhttp%3A//www.domain.com/cgi-bin/WebCatalogEngine/Admi= n/AdminPrefs.tpl&Cookie=3D__utmz%3D238728966.1225062648.23.3.utmcsr%3Dstor= e.webdna.us%7Cutmccn%3D%28referral%29%7Cutmcmd%3Dreferral%7Cutmcct%3D/defa= ult.tpl%3B%20__utma%3D238728966.1140128720646497800.1222376773.1226506042.= 1226682779.28&Authorization=3DBasic%20YWRtaW46VTZeamF0MQ%3D%3D&Content-Typ= e=3Dapplication/x-www-form-urlencoded&Content-Length=3D792& >>=20 >> The SignalCatcher.debug, activated by "Catching Terminate signal" = will provide the problematic code and the domain name: >>=20 >> ---Thu Oct 23 01:59:05 2008 CDT Starting processid 16763 receive = SIGSEGV: >> ContextName: [EXCLUSIVELOCK] >> TemplatePath: = /var/www/html/www.domain.com/euca/dev/a1pg/WebMerchant/processorders.tpl >> Includefile: ^WebMerchant/DoPurchases.inc >> PartOfWebDNA: [ExclusiveLock db=3DWebMerchantPrefs.db&db=3DOrders.db] >> [text]ordersFolder=3D../[lookup = db=3DSandBoxPrefs&lookInField=3Dpreference&value=3DOrdersFolder&returnFiel= d=3Dvalue][/text] >> [text]completedFolder=3D../[lookup = db=3DSandBoxPrefs&lookInField=3Dpreference&value=3DCompletedF >>=20 >>=20 >> - chris >>=20 >> On Nov 25, 2011, at 11:29, Thierry Almy wrote: >>=20 >>> Hi >>>=20 >>> We're running a copy of WebDNA 6.2 on a MacPro 2x QuadCore 2,4 GHz, = 6GB RAM, OS 10.6.8, iTools 9.0.5i >>> Apache has about 35 vhosts >>>=20 >>> As soon as the server gets a bit load (~100 concurrent connections) = and WebDNA uses 110% to 160% of the processor, it takes up to 10 seconds = to serve a page with WebDNA. >>> Since we have 8-Cores in the server, I guess WebDNA should be able = to use more than 160% .... or am I wrong? >>>=20 >>> Pages served directly from apache (no DNA) appear very quick. >>>=20 >>> In cases of heavy load I have the following lines in the console = log: >>> 25.11.11 14:26:43 sioux WebDNA[210] Error Could not = establish connection with the module. >>>=20 >>>=20 >>> And I've also seen the following lines, which makes me even more = nervous: >>> 25.11.11 11:18:44 sioux com.apple.SystemStarter[36] Notice = *** set a breakpoint in malloc_error_break to debug >>> 25.11.11 11:18:45 sioux com.apple.SystemStarter[36] Notice = WebCatalog(210,0xa047a540) malloc: *** error for object 0xe0c970: = pointer being freed was not allocated >>> 25.11.11 11:47:12 sioux com.apple.SystemStarter[36] Notice = sem_open failed: returned EMFILE: Too many open files >>>=20 >>> All the lines are repeated several times. >>>=20 >>>=20 >>> How can I find out what's blocking WebCatalog? >>> Is something wrong with my module? >>>=20 >>>=20 >>> Thanks for any help >>> Thierry >>>=20 >>> ______________________ >>> mac&web gmbh >>> thierry almy >>> grabenstrasse 15 >>> 8200 schaffhausen >>> switzerland >>> web www.mac-web.ch >>>=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
Associated Messages, from the most recent to the oldest:
I think 3 is "ElapsedTime" while 4 is "AvailableMemory" (a negative = number would show WebDNA does not have enough RAM available) 6 would be "pathArgs" - chris On Nov 26, 2011, at 12:09, William DeVaul wrote: > Can you tell us what column 3, 4, and 6 are used for? >=20 > On Sat, Nov 26, 2011 at 7:25 AM, = wrote: >> Based on what you copy here, the problem seems to be a RAM problem: = databases and templates are loaded in RAM by WebDNA, and there might be = other applications running on your server that could need lots of memory = (Safari is a good example). You can type "free" in your terminal to see = the avaiable RAM, check the swap usage (this would tremendously slow = things down) or even use your "Activity Monitor" application >>=20 >>=20 >> Here is the .debug exemple, broken in lines to simplify the reading >>=20 >> The webdna.debug, activated by "Technical Support Information" >>=20 >> 1.- 11/18/08 >> 2.- 14:20:09 >> 3.- 11 >> 4.- -944508928 >> 5.- 024.183.098.016 >> 6.- >> 7.- /var/www/cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 8.- Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.7) = Gecko/20050416 >> 9.- login >> 10.- password >> 11.- = http://www.domain.com/cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 12.- /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.tpl >> 13.- /var/www/html/ >> 14.- = command=3DAdminPut&InterpretAll=3DF&SerialNumber=3D************&SerialNumb= er2=3Dnone&DateFormat=3D%25m%2F%25d%2F%25Y&TimeFormat=3D%25H%3A%25M%3A%25S= &ReadDateFormat=3Dmdy&MathUseDateFormat=3D0&MaxFound=3D16000&CenturyBreak=3D= 0&LimitThreads=3D25&ZapNulls=3D0&PreParseScript=3D1&PostParseScript=3D0&Ca= cheTemplates=3DF&CheckTemplateInterval=3D2&AutoCommit=3DT&DeadlockSeconds=3D= 20&SafeWriteDatabase=3D1&CommandSecurity=3DT&CommandsAllowed=3DShowPage%2C= +FlushCache%2C+ShowCart%2C+Add%2C+Remove%2C+NewCart%2C+Purchase%2C+NewCart= Search%2C+Clear&CheckTemplateExtensions=3DT&ValidTemplateExtensions=3D.tmp= l+.tpl+.tp2+.dna+.html+.htm&CheckDatabaseExtensions=3DT&ValidDatabaseExten= sions=3D.db%2C+.txt&LineItemChangePassword=3Dftj8*%289&AbsolutePath=3D0&In= secureFileMode=3D666&SecureFileMode=3D660&DebugLevel=3D0&CatchSignal=3D0&L= ogError=3D0&DisplayError=3D1 >> 15.- = __utmz=3D238728966.1225062648.23.3.utmcsr=3Dstore.webdna.us|utmccn=3D(refe= rral)|utmcmd=3Dreferral|utmcct=3D/default.tpl&__utma=3D238728966.114012872= 0646497800.1222376773.1226506042.1226682779.28& >> 16.- Host=3D = www.domain.com&User-Agent=3DMozilla/5.0%20%28Macintosh%3B%20U%3B%20PPC%20M= ac%20OS%20X%20Mach-O%3B%20en-US%3B%20rv%3A1.7.7%29%20Gecko/20050416&Accept= =3Dtext/xml%2Capplication/xml%2Capplication/xhtml%2Bxml%2Ctext/html%3Bq%3D= 0.9%2Ctext/plain%3Bq%3D0.8%2Cimage/png%2C%2A/%2A%3Bq%3D0.5&Accept-Language= =3Den-us%2Cen%3Bq%3D0.5&Accept-Encoding=3Dgzip%2Cdeflate&Accept-Charset=3D= ISO-8859-1%2Cutf-8%3Bq%3D0.7%2C%2A%3Bq%3D0.7&Keep-Alive=3D300&Connection=3D= keep-alive&Referer=3Dhttp%3A//www.domain.com/cgi-bin/WebCatalogEngine/Admi= n/AdminPrefs.tpl&Cookie=3D__utmz%3D238728966.1225062648.23.3.utmcsr%3Dstor= e.webdna.us%7Cutmccn%3D%28referral%29%7Cutmcmd%3Dreferral%7Cutmcct%3D/defa= ult.tpl%3B%20__utma%3D238728966.1140128720646497800.1222376773.1226506042.= 1226682779.28&Authorization=3DBasic%20YWRtaW46VTZeamF0MQ%3D%3D&Content-Typ= e=3Dapplication/x-www-form-urlencoded&Content-Length=3D792& >>=20 >> The SignalCatcher.debug, activated by "Catching Terminate signal" = will provide the problematic code and the domain name: >>=20 >> ---Thu Oct 23 01:59:05 2008 CDT Starting processid 16763 receive = SIGSEGV: >> ContextName: [exclusivelock] >> TemplatePath: = /var/www/html/www.domain.com/euca/dev/a1pg/WebMerchant/processorders.tpl >> Includefile: ^WebMerchant/DoPurchases.inc >> PartOfWebDNA: [ExclusiveLock db=3DWebMerchantPrefs.db&db=3DOrders.db] >> [text]ordersFolder=3D../[lookup = db=3DSandBoxPrefs&lookInField=3Dpreference&value=3DOrdersFolder&returnFiel= d=3Dvalue][/text] >> [text]completedFolder=3D../[lookup = db=3DSandBoxPrefs&lookInField=3Dpreference&value=3DCompletedF >>=20 >>=20 >> - chris >>=20 >> On Nov 25, 2011, at 11:29, Thierry Almy wrote: >>=20 >>> Hi >>>=20 >>> We're running a copy of WebDNA 6.2 on a MacPro 2x QuadCore 2,4 GHz, = 6GB RAM, OS 10.6.8, iTools 9.0.5i >>> Apache has about 35 vhosts >>>=20 >>> As soon as the server gets a bit load (~100 concurrent connections) = and WebDNA uses 110% to 160% of the processor, it takes up to 10 seconds = to serve a page with WebDNA. >>> Since we have 8-Cores in the server, I guess WebDNA should be able = to use more than 160% .... or am I wrong? >>>=20 >>> Pages served directly from apache (no DNA) appear very quick. >>>=20 >>> In cases of heavy load I have the following lines in the console = log: >>> 25.11.11 14:26:43 sioux WebDNA[210] Error Could not = establish connection with the module. >>>=20 >>>=20 >>> And I've also seen the following lines, which makes me even more = nervous: >>> 25.11.11 11:18:44 sioux com.apple.SystemStarter[36] Notice = *** set a breakpoint in malloc_error_break to debug >>> 25.11.11 11:18:45 sioux com.apple.SystemStarter[36] Notice = WebCatalog(210,0xa047a540) malloc: *** error for object 0xe0c970: = pointer being freed was not allocated >>> 25.11.11 11:47:12 sioux com.apple.SystemStarter[36] Notice = sem_open failed: returned EMFILE: Too many open files >>>=20 >>> All the lines are repeated several times. >>>=20 >>>=20 >>> How can I find out what's blocking WebCatalog? >>> Is something wrong with my module? >>>=20 >>>=20 >>> Thanks for any help >>> Thierry >>>=20 >>> ______________________ >>> mac&web gmbh >>> thierry almy >>> grabenstrasse 15 >>> 8200 schaffhausen >>> switzerland >>> web www.mac-web.ch >>>=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
christophe.billiottet@webdna.us
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:
Re:2nd WebCatalog2 Feature Request (1996)
[input] formating (1998)
Viewing old carts (was FEW QUESTIONS) (1997)
Nested search (1997)
Emailer Set Up (1997)
WebCatalog2 Feature Feedback (1996)
WebCat & WebTen (1997)
f2 download problems (1997)
2nd try:Webcat interfering with Webstar? (1998)
Shop till you drop dead on the avenue ... (1997)
The Send Mail Button is the Best Troubleshooter (1998)
Calculating multiple shipping... (1997)
WebTV problems with WebCatalog?? (1998)
WebCatalog Technical Reference (1997)
WebMerchant bomb (1998)
Repeating Fields (1997)
[subtotal] and others (1997)
Simple way to create unique SKU (1997)
converted seed value? (1998)
Nested vs conditional (1997)