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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: DNS <letanloc(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Date: 2007-05-02 14:02:35
Message-ID: 20070502140235.GJ4585@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dhugael McLean 2007-05-03 16:21:51 BUG #3260: Subtracting intervals
Previous Message DNS 2007-05-02 13:21:30 Re: PGSQL - WARNING: 25P01: there is no transaction in progress