[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.4196FD80Content-Type: text/plain;charset="us-ascii"Content-Transfer-Encoding: 7bitHi, We have been using Webdna for a few years now. At least twice a day theDBServer.exe memory gets sky high. "WebCatalog does not have enough memoryto complete this command" is logged to the errorlog.txt, and the serviceneeds to be restarted. We were able to narrow one of the issues to the SQLExecute statements thatwe use. With every query made the memory climbs, and does not go down oncethe 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 runningWindows 2003. We are using WebDNA version 6.1. Thanks! ------=_NextPart_000_0026_01C8F193.4196FD80Content-Type: text/html;charset="us-ascii"Content-Transfer-Encoding: quoted-printable
Hi,
We have been using Webdna for a few years now. At =leasttwice a day the DBServer.exe memory gets sky high. “WebCatalog =does nothave enough memory to complete this command” is logged to theerrorlog.txt, and the service needs to be restarted. =
We were able to narrow one of the issues to the =SQLExecutestatements that we use. With every query made the memory climbs, and =does notgo 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 =Webserver 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:
This is a multi-part message in MIME format.------=_NextPart_000_0026_01C8F193.4196FD80Content-Type: text/plain;charset="us-ascii"Content-Transfer-Encoding: 7bitHi, We have been using Webdna for a few years now. At least twice a day theDBServer.exe memory gets sky high. "WebCatalog does not have enough memoryto complete this command" is logged to the errorlog.txt, and the serviceneeds to be restarted. We were able to narrow one of the issues to the SQLExecute statements thatwe use. With every query made the memory climbs, and does not go down oncethe 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 runningWindows 2003. We are using WebDNA version 6.1. Thanks! ------=_NextPart_000_0026_01C8F193.4196FD80Content-Type: text/html;charset="us-ascii"Content-Transfer-Encoding: quoted-printable
Hi,
We have been using Webdna for a few years now. At =leasttwice a day the DBServer.exe memory gets sky high. “WebCatalog =does nothave enough memory to complete this command” is logged to theerrorlog.txt, and the service needs to be restarted. =
We were able to narrow one of the issues to the =SQLExecutestatements that we use. With every query made the memory climbs, and =does notgo 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 =Webserver 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)