Hi, From: Simone Tregnago <[EMAIL PROTECTED]> Subject: Re: [Pgpool-general] insert_lock leaks Date: Fri, 30 May 2008 09:48:11 +0200
> Yoshiyuki Asaba wrote: > > Hi, > > > > From: Simone Tregnago <[EMAIL PROTECTED]> > > Subject: Re: [Pgpool-general] insert_lock leaks > > Date: Fri, 30 May 2008 09:31:09 +0200 > > > > > > OK. I have another question. What driver do you use? JDBC driver? > > > > no, it's a direct C connection with libpq. But in most of cases it uses > prepared statements, as JDBC does. Thanks. I wrote a test program and ran it. However I could not reproduce. Could you collect the following outputs when the problem reproduces? On pgpool Server: % ps auwwx | grep pgpool On PostgreSQL Servers: % ps auwwx | grep postgres % psql -c 'select * from pg_locks' <your DB> % psql -c 'select * from pg_stat_activity' <your DB> Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
