[Pgpool-general] insert_lock leaks

[Yoshiyuki Asaba]

Hi,

From: Simone Tregnago <simonetregnago at grivaonline.com>
Subject: Re: [Pgpool-general] insert_lock leaks
Date: Fri, 30 May 2008 09:48:11 +0200

> Yoshiyuki Asaba wrote:
> > Hi,
> > 
> > From: Simone Tregnago <simonetregnago at grivaonline.com>
> > 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
y-asaba at sraoss.co.jp