Hi, From: Simone Tregnago <[EMAIL PROTECTED]> Subject: Re: [Pgpool-general] insert_lock leaks Date: Fri, 30 May 2008 09:31:09 +0200
> > Could you provide a reproducible program? > > > > That's very hard to do since the leaks comes using our ERP with hundreds > of opened connections ( in order to work properly I had to set > num_init_children=1000 and max_pool=4). I can't imagine how to reproduce > a test software: until now I wasn't able to guess the guilty > > context. OK. I have another question. What driver do you use? JDBC driver? Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] > Maybe, if you have suggestions on what to look ( or to log ) in order to > help me to identify something... > A first hypothesis is that the leaks remains with tables with serial > fields, but I can't be sure of that. > Yesterday I killed 3-4 zombie connections that took one table locked. > Note that the ERP don't use PostgreSQL locks, so only PgPool makes > explicit locks. > > Thanks for you attention, > Simone Tregnago _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
