[pgpool-general: 8917] Re: WARNING: there is no transaction in progress

Bo Peng pengbo at sraoss.co.jp
Thu Aug 10 13:59:55 JST 2023


Hi,

> after setting the parameter prefer_lower_delay_standby = off the errors
> disappeared. I will keep it like this.

I think it might be a bug of prefer_lower_delay_standby.
If you would like to help us to reproduce the issue,
could you share your pgpool.conf and the steps to reproduce this issue?

Thanks!

On Wed, 9 Aug 2023 16:34:15 -0400
Franklin Anderson de Oliveira Souza <franklinbr at gmail.com> wrote:

> Hello,
> 
> after setting the parameter prefer_lower_delay_standby = off the errors
> disappeared. I will keep it like this.
> 
> Em qua., 9 de ago. de 2023 às 00:34, Bo Peng <pengbo at sraoss.co.jp> escreveu:
> 
> > Hi
> >
> > > We have a java application that uses jdbc to connect to pgpool 4.4.3 that
> > > is connected to a master and a replica. It's working but in the logs
> > there
> > > are thousands of the following warning:
> > >
> > > WARNING: there is no transaction in progress
> > >
> > > Any tips to resolve this warning ?! pgpool is committing on the replica
> > > with no open transactions.
> >
> > I am not sure if pgpool sent "commit/abort" or not.
> > Could you share the pgpool log and PostgreSQL logs of both master and
> > replica?
> >
> > If it is possible, could you share the query that caused this issue?
> > Alternatively, if possible, could you set log_statement = 'all' and share
> > the logs?
> > Please note that after reproducing the issue,
> > disable log_statement = 'all' to save the disk space.
> >
> > On Tue, 8 Aug 2023 09:28:55 -0400
> > Franklin Anderson de Oliveira Souza <franklinbr at gmail.com> wrote:
> >
> > > Hello everyone,
> > >
> > > We have a java application that uses jdbc to connect to pgpool 4.4.3 that
> > > is connected to a master and a replica. It's working but in the logs
> > there
> > > are thousands of the following warning:
> > >
> > > WARNING: there is no transaction in progress
> > >
> > > Any tips to resolve this warning ?! pgpool is committing on the replica
> > > with no open transactions.
> > >
> > > Tanks
> > >
> > > --
> > > foobar
> >
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS LLC
> > TEL: 03-5979-2701 FAX: 03-5979-2702
> > URL: https://www.sraoss.co.jp/
> >
> 
> 
> -- 
> foobar


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/



More information about the pgpool-general mailing list