Re: [Sqlgrey-users] Memoryleak in sqlgrey 1.6.7

[Andrew D. <and...@gm...>]

Hello Casey,

Monday, September 11, 2006, 2:14:51 PM, Casey Feskens wrote:

> Lionel Bouton wrote:
>> I recently had an unrelated problem with DBD-Pg and investigated the
>> "Changes" files of DBI (Perl's database API) and DBD-Pg (Perl DBI's 
>> PostgreSQL driver) by downloading the latest versions available from 
>> CPAN. I've spotted reports of memory leaks fixed in DBI 1.52 (latest 
>> available) and DBD-Pg 1.44 (current is 1.49, which, for me, solved a 
>> prepared statement problem when DBD-Pg was compiled with GCC 4.1.1). You 
>> should check your DBI version and if you use PostgreSQL, please check 
>> DBD-Pg's version too.

> Thanks, for the tip.  We are running DBI 1.52 and DBD-Pg 1.49.
> I'm going to do some further profiling and see what I find out.

I use sqlgrey  on a SuSE 10.0 box with postgres, and I've seen the
postmaster leak.  If I restart sqlgrey the memory in postmaster
releases.  Looks like I have perl-DBI-1.48-2, and I found DBD-Pg-1.47
in my .cpan directory, though no-where else, so I'm not even sure if
I'm using DBD-Pg.

-- 
Best regards,
 Andrew                            mailto:and...@gm...