Re: PGSQL - WARNING: 25P01: there is no transaction in progress

Even desactivate Auto-vacuum didn't fix my issue. Is there any place
where I can see past transactions or transactions in queue that hasn't
been processed ?

Thank you,

On 2 mai, 10:02, alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (Alvaro Herrera) wrote:
> DNS escribió:
>
> > On 27 avr, 19:17, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
>
> > > This is just a warning, which most likely is there only because somebody
> > > typed COMMIT or ABORT unnecessarily. What problem are you actually having?
>
> > No one is working on the database when come up the warning. The
> > warning makes us worrier about the database but nothing serious on
> > database side.
>
> This is not possible. The server does not send this message all by
> itself. Maybe the driver or connection pooler you are using is sending
> a ROLLBACK command when it connects, to "clear up" the connection or
> something like that.
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.