Re: RAM issue
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67671
interpreted = N
texte = Have you tried explicitly delete the temp table from time to time? sort =of way to clear the memory-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfAdam O'ConnorSent: Wednesday, July 05, 2006 1:13 PMTo: WebDNA TalkSubject: Re: RAM issueYes server admin found nothing out of the ordinary. However we did find =the problem, and yes it was not related to RAM. Its was due to a bug in=20webdna's [TABLE] context.When we use the [table] context the memory used for the [table] is not=20removed from our server's RAM. Instead it simply accumulates until the=20server runs out and DBSever.exe crashes. The page still stays up, but=20dbs don't work because available memory is used up, therefore the server =generates tons of 'Not enough memory errors....' and no one can use the=20site.We previously suspected that [table] was not stable, but this proved it=20for us. The server crashed every day last week, today we removed the=20code snippet and all is fine, memory stabilized. We had discovered that =every time this page was loading, this small [table] containing three=20records, was not being removed from the server RAM like a normal .db.Another member to add to WebDNA errata.-adamBess Ho wrote:> It concerns me too. Did you have experience network admin to check out =your web server? to see if you have to do some server maintainance such =as defrag etc?>> I am thinking your webdna server crash is caused by another incident =unrelated to RAM?>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Adam O'Connor> Sent: Wednesday, June 28, 2006 12:55 PM> To: WebDNA Talk> Subject: RAM issue>>> Quick question, I am working with a Win2003 webdna server which had 2g => of RAM, then was upgraded to 4g RAM. However only 1,003,388 is shown =as=20> being used by webcat. At some points the server is crashing because=20> webcat is complaining of not having enough memory, but never goes =above=20> 700meg. What's the deal? Do I have to reinstall webcat? Is it a=20> registry issue on the sever? Am I missing a config issue regarding =webcat?>> Anyone experience this before?>> -Adam>> -------------------------------------------------------------> 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/> =20-------------------------------------------------------------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:
Have you tried explicitly delete the temp table from time to time? sort =of way to clear the memory-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfAdam O'ConnorSent: Wednesday, July 05, 2006 1:13 PMTo: WebDNA TalkSubject: Re: RAM issueYes server admin found nothing out of the ordinary. However we did find =the problem, and yes it was not related to RAM. Its was due to a bug in=20webdna's [table] context.When we use the [table] context the memory used for the [table] is not=20removed from our server's RAM. Instead it simply accumulates until the=20server runs out and DBSever.exe crashes. The page still stays up, but=20dbs don't work because available memory is used up, therefore the server =generates tons of 'Not enough memory errors....' and no one can use the=20site.We previously suspected that [table] was not stable, but this proved it=20for us. The server crashed every day last week, today we removed the=20code snippet and all is fine, memory stabilized. We had discovered that =every time this page was loading, this small [table] containing three=20records, was not being removed from the server RAM like a normal .db.Another member to add to WebDNA errata.-adamBess Ho wrote:> It concerns me too. Did you have experience network admin to check out =your web server? to see if you have to do some server maintainance such =as defrag etc?>> I am thinking your webdna server crash is caused by another incident =unrelated to RAM?>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Adam O'Connor> Sent: Wednesday, June 28, 2006 12:55 PM> To: WebDNA Talk> Subject: RAM issue>>> Quick question, I am working with a Win2003 webdna server which had 2g => of RAM, then was upgraded to 4g RAM. However only 1,003,388 is shown =as=20> being used by webcat. At some points the server is crashing because=20> webcat is complaining of not having enough memory, but never goes =above=20> 700meg. What's the deal? Do I have to reinstall webcat? Is it a=20> registry issue on the sever? Am I missing a config issue regarding =webcat?>> Anyone experience this before?>> -Adam>> -------------------------------------------------------------> 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/> =20-------------------------------------------------------------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/
"Bess Ho"
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:
Migrating to NT (1997)
Checking for blank form fields (sort of...) (1998)
Search/sort in URL Was: GuestBook example (1997)
Extended [ConvertChars] (1997)
Problems mit mysql (2004)
question: webmerchant connection (1997)
Append command (1999)
Encrypted links ... (2000)
WebCatalog2 for NT Beta Request (1997)
[ShowNext] (1997)
Template transformed itself into a database? (1998)
Simultaneous Users (1999)
WebDNA Trouble... (1999)
RE: [WebDNA] WebDNA & mySQL (2008)
Https not showing products (2004)
Add to Cart & List of Products (1997)
multiple search commands (1997)
anyone interested in doing an open-source WebCat based forum? (2002)
WebCatalog and Filemaker (1996)
[writefile] (1997)