Re: Possible memory leak using $sth->{NAME} ?

2006-06-08 Thread Tim Bunce
At this point I'm pretty sure it's a bug in DBD::ODBC, so I'll let Jeff Urlwin pick up from here. Tim. On Wed, Jun 07, 2006 at 11:52:15AM -0700, David Brewer wrote: > I'm still not able to replicate on mysql. However, I have created a > test script (included below) which, given access to an empt

Re: Possible memory leak using $sth->{NAME} ?

2006-06-07 Thread David Brewer
I'm still not able to replicate on mysql. However, I have created a test script (included below) which, given access to an empty mssql database, should do everything necessary to demonstrate the behavior. Please let me know if there is any further information I could provide or tests I could cre

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread David Brewer
I have not yet been able to replicate in mysql but I spent some time paring down the query to the minimum version that causes the memory leak. The results are interesting and I think may point toward DBD::ODBC being the issue. I don't understand the internals well enough to be sure of that, thou

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread David Brewer
OK, I will attempt to replicate in mysql and get back to you. In the meantime, I have run my test script in some older versions of DBI to see if that helps anything. I tried 1.49, 1.48, 1.47, 1.45, 1.41, and 1.38. I saw pretty the same behavior in each version. Thanks, David On 6/6/06, Tim B

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread Tim Bunce
Can you get DBD::mysql to leak in the same way ($sth->{NAME})? I need to be able to duplicate the problem and I can't do that easily with ODBC or ADO. Tim. On Tue, Jun 06, 2006 at 12:14:36PM -0700, David Brewer wrote: > I've tried this with a couple of different drivers now -- DBD::ADO and > DBD:

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread David Brewer
I've tried this with a couple of different drivers now -- DBD::ADO and DBD::mysql. In both cases the same simple connect and disconnect routine seems to leak 1 SV per execution. The ADO example is exactly the same as the previous example, except I substituted "DBI:ADO" for "DBI:ODBC". The MySQL

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread David Brewer
Sure, I'd be glad to check into that. I think Apache::Leak already runs the code twice -- first it runs the code to make sure that anything that would get cached is already in memory. Then it measures the memory usage, runs the code again, and measures the memory usage a final time to determine

Re: Possible memory leak using $sth->{NAME} ?

2006-06-06 Thread Tim Bunce
On Mon, Jun 05, 2006 at 07:51:22PM -0700, David Brewer wrote: > OK, I have pared my problem down to a small test script and I've cut > away a lot of the modules I'm using that don't seem to be part of the > issue. The test script is included at the end of this message. Thanks. > This small scrip

Re: Possible memory leak using $sth->{NAME} ?

2006-06-05 Thread David Brewer
OK, I have pared my problem down to a small test script and I've cut away a lot of the modules I'm using that don't seem to be part of the issue. The test script is included at the end of this message. This small script doesn't leak much memory, but it's surprising to me that it leaks at all. E

Possible memory leak using $sth->{NAME} ?

2006-06-02 Thread David Brewer
I am having what appears to a memory leak problem on a mod_perl project I am working on. On the worst case web page (a search results page) I am leaking an average of about 160k per page load! I think I've finally isolated the problem and it appears to be related to DBI. It's very possible that