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

[Franklin Anderson de Oliveira Souza]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230809/101fb457/attachment.htm>