RE: [WebDNA] SQLExecute Memory Leak

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100421
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C8F1C4.6429BC80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable But I am using a later version (6.1). I assume that the problem would = have been resolved for this version.=20 =20 _____ =20 From: Greg Kesler [mailto:gregk@clarityconnect.com]=20 Sent: Tuesday, July 29, 2008 4:06 PM To: talk@webdna.us Subject: Re: [WebDNA] SQLExecute Memory Leak =20 Hello Sarah: I checked the revision list at: http://webdna.smithmicro.com/ref/WebDNA%20Change%20History.html There is a notice of a memory leak that was fixed with version 4.5.1. 6/15/2002 4.5.0 * Bug Fixes =20 *All Platforms:=20 *Fixed a memory leak with the database cache code. High volume site would be most affected by the memory leak, as it only occured when more = than one thread required access to the same database at the same time.=20 Thank you, Greg. At 03:53 PM 7/29/2008, you wrote: Hi, =20 We have been using Webdna for a few years now. At least twice a day the DBServer.exe memory gets sky high. =13WebCatalog does not have enough = memory to complete this command=14 is logged to the errorlog.txt, and the = service needs to be restarted.=20 =20 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.=20 =20 Has anyone else found this to be an issue? =20 We are using a Mysql Database (version 4.1.20). The Web server is = running Windows 2003. We are using WebDNA version 6.1. =20 Thanks! =20 ------=_NextPart_000_003A_01C8F1C4.6429BC80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

But I am using a later version = (6.1). I assume that the problem would have been resolved for this version. =

 

From: Greg = Kesler [mailto:gregk@clarityconnect.com]
Sent: Tuesday, July 29, = 2008 4:06 PM
To: talk@webdna.us
Subject: Re: [WebDNA] = SQLExecute Memory Leak

 

Hello = Sarah:

I checked the revision list at:
http://webdna.smithmicro.com/ref/WebDNA%20Change%20Histo= ry.html

There is a notice of a memory leak that was fixed with version = 4.5.1.

6/15/2002 = 4.5.0

·         Bug = Fixes

 

Thank you,

Greg.

At 03:53 PM 7/29/2008, you wrote:

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_003A_01C8F1C4.6429BC80-- 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)
This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C8F1C4.6429BC80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable But I am using a later version (6.1). I assume that the problem would = have been resolved for this version.=20 =20 _____ =20 From: Greg Kesler [mailto:gregk@clarityconnect.com]=20 Sent: Tuesday, July 29, 2008 4:06 PM To: talk@webdna.us Subject: Re: [WebDNA] SQLExecute Memory Leak =20 Hello Sarah: I checked the revision list at: http://webdna.smithmicro.com/ref/WebDNA%20Change%20History.html There is a notice of a memory leak that was fixed with version 4.5.1. 6/15/2002 4.5.0 * Bug Fixes =20 *All Platforms:=20 *Fixed a memory leak with the database cache code. High volume site would be most affected by the memory leak, as it only occured when more = than one thread required access to the same database at the same time.=20 Thank you, Greg. At 03:53 PM 7/29/2008, you wrote: Hi, =20 We have been using Webdna for a few years now. At least twice a day the DBServer.exe memory gets sky high. =13WebCatalog does not have enough = memory to complete this command=14 is logged to the errorlog.txt, and the = service needs to be restarted.=20 =20 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.=20 =20 Has anyone else found this to be an issue? =20 We are using a Mysql Database (version 4.1.20). The Web server is = running Windows 2003. We are using WebDNA version 6.1. =20 Thanks! =20 ------=_NextPart_000_003A_01C8F1C4.6429BC80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

But I am using a later version = (6.1). I assume that the problem would have been resolved for this version. =

 

From: Greg = Kesler [mailto:gregk@clarityconnect.com]
Sent: Tuesday, July 29, = 2008 4:06 PM
To: talk@webdna.us
Subject: Re: [WebDNA] = SQLExecute Memory Leak

 

Hello = Sarah:

I checked the revision list at:
http://webdna.smithmicro.com/ref/WebDNA%20Change%20Histo= ry.html

There is a notice of a memory leak that was fixed with version = 4.5.1.

6/15/2002 = 4.5.0

·         Bug = Fixes

 

Thank you,

Greg.

At 03:53 PM 7/29/2008, you wrote:

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_003A_01C8F1C4.6429BC80-- "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:

[WebDNA] Case-insensitive URLs (2011) [CART] (1997) Sorting by date (1997) Online reference (1997) Summary search -- speed (1997) OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998) Webcatalog error, Plug-in for Webstar (1996) Time Remaining? (1998) Looking for 5 to 12 shops with 3 URLs & statements (1997) Applescript error (1998) WebCat2: Items xx to xx shown, etc. (1997) EIMS Problems (1997) breaking & sorting (2000) OR in Showifs (Was: Secure Web Server) (1999) WebCat2 several catalogs? (1997) select multiple (1997) weiered lookup (2004) WebCatalog usage (1997) question: webdelivery folder and file (1997) FAX orders (1996)