Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-16 Thread Marko Kreen
On Wed, Feb 15, 2006 at 03:02:45PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > My non-OpenSSL build shows no memory leak, so the leak and OpenSSL > > seem to be correlated. I'd be more inclined to suspect a bug in > > pgcrypto's OpenSSL-specific code than in OpenSSL itsel

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-16 Thread Daniel Blaisdell
I appreciate you guys looking at this bug. Taking Tom's suggestion that it might be a system crypt implementation issue I upgraded OpenSSL from 0.9.7e to 0.9.7i. I also upgraded any other libraries that were installed with the word crypt. After running ldconfig I then recompiled Postgres 8.1.2 aga

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > My non-OpenSSL build shows no memory leak, so the leak and OpenSSL > seem to be correlated. I'd be more inclined to suspect a bug in > pgcrypto's OpenSSL-specific code than in OpenSSL itself. Will keep > digging. The problem appears to be here: static

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Michael Fuhr
On Wed, Feb 15, 2006 at 02:28:33PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > Did you test OpenSSL builds? > > Nope, I did not, and that's a good point. Will try again with openssl. My non-OpenSSL build shows no memory leak, so the leak and OpenSSL seem to be correlate

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Wed, Feb 15, 2006 at 01:43:18PM -0500, Tom Lane wrote: >> Interesting, because I see no leak with this example on Fedora 4 or >> HPUX. Platform dependency is sounding more and more likely. > Did you test OpenSSL builds? Nope, I did not, and that's a

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Michael Fuhr
On Wed, Feb 15, 2006 at 01:43:18PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I can reproduce this in 8.1.3 on FreeBSD 6.0 and Solaris 9. Here's > > a standalone test case: > > > SELECT crypt(x::text, '$1$salt') FROM generate_series(1, 500) AS g(x); > > Interesting, be

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > I can reproduce this in 8.1.3 on FreeBSD 6.0 and Solaris 9. Here's > a standalone test case: > SELECT crypt(x::text, '$1$salt') FROM generate_series(1, 500) AS g(x); Interesting, because I see no leak with this example on Fedora 4 or HPUX. Platform dep

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Tom Lane
"Daniel Blaisdell" <[EMAIL PROTECTED]> writes: > Table Setup: > employeeid integer > salt text > md5password text > Problem Query: > select * from table where md5password = crypt('password',salt) I tried this with dummy data and couldn't see any memory leak, using Fedora Core 4 and CVS-tip postgr

Re: [BUGS] BUG #2260: PGCrypto Memory Problem

2006-02-15 Thread Michael Fuhr
On Tue, Feb 14, 2006 at 05:28:25PM +, Daniel Blaisdell wrote: > Problem Query: > select * from table where md5password = crypt('password',salt) > > The first time this query is run, I see the postgres process bump up to 8MB > of ram from where it initializes. > > On subsequent issues of the s