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

[Bo Peng]

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/