[WebDNA] SQLExecute Memory Leak

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100419
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C8F193.4196FD80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, We have been using Webdna for a few years now. At least twice a day the DBServer.exe memory gets sky high. "WebCatalog does not have enough memory to complete this command" is logged to the errorlog.txt, and the service needs to be restarted. We were able to narrow one of the issues to the SQLExecute statements that we use. With every query made the memory climbs, and does not go down once the query has been completed. Has anyone else found this to be an issue? We are using a Mysql Database (version 4.1.20). The Web server is running Windows 2003. We are using WebDNA version 6.1. Thanks! ------=_NextPart_000_0026_01C8F193.4196FD80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

We have been using Webdna for a few years now. At = least twice a day the DBServer.exe memory gets sky high. “WebCatalog = does not have enough memory to complete this command” is logged to the errorlog.txt, and the service needs to be restarted. =

 

We were able to narrow one of the issues to the = SQLExecute statements that we use. With every query made the memory climbs, and = does not go down once the query has been completed.

 

Has anyone else found this to be an = issue?

 

We are using a Mysql Database (version 4.1.20). The = Web server is running  Windows 2003. We are using WebDNA version = 6.1.

 

Thanks!

 

------=_NextPart_000_0026_01C8F193.4196FD80-- Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] SQLExecute Memory Leak ("Sarah Nussbaum" 2008)
  2. Re: [WebDNA] SQLExecute Memory Leak (Greg Kesler 2008)
  3. [WebDNA] SQLExecute Memory Leak ("Sarah Nussbaum" 2008)
This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C8F193.4196FD80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, We have been using Webdna for a few years now. At least twice a day the DBServer.exe memory gets sky high. "WebCatalog does not have enough memory to complete this command" is logged to the errorlog.txt, and the service needs to be restarted. We were able to narrow one of the issues to the SQLExecute statements that we use. With every query made the memory climbs, and does not go down once the query has been completed. Has anyone else found this to be an issue? We are using a Mysql Database (version 4.1.20). The Web server is running Windows 2003. We are using WebDNA version 6.1. Thanks! ------=_NextPart_000_0026_01C8F193.4196FD80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

We have been using Webdna for a few years now. At = least twice a day the DBServer.exe memory gets sky high. “WebCatalog = does not have enough memory to complete this command” is logged to the errorlog.txt, and the service needs to be restarted. =

 

We were able to narrow one of the issues to the = SQLExecute statements that we use. With every query made the memory climbs, and = does not go down once the query has been completed.

 

Has anyone else found this to be an = issue?

 

We are using a Mysql Database (version 4.1.20). The = Web server is running  Windows 2003. We are using WebDNA version = 6.1.

 

Thanks!

 

------=_NextPart_000_0026_01C8F193.4196FD80-- "Sarah Nussbaum"

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: E-mailer error codes (1997) Cybersource and WebCat ... again (2000) RE: Multiple Stores and WebCatalog Prefs (1997) WC2.0 Memory Requirements (1997) Grep Question - NOT YET SOLVED (fwd) (2003) Version 4? (2000) Mac v. NT (1998) Sami (1998) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [referrer] tag (1997) Interfacing WebMerchant to www.fedex.com (1997) Re:I've had it! (1999) Not Java, Javascript and WebDNA (2002) So many lookers, hey smith micro (2003) Nested vs conditional (1997) WCS Newbie question (1997) Sorry But This seems to be my fate (2000) Multiple fields on 1 input (1997) Firesite cache vs webcat cache (1997) Hiding HTML and page breaks (1997)