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

Поиск
Список
Период
Сортировка
От DNS
Тема Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Дата
Msg-id 1178286863.038210.177180@u30g2000hsc.googlegroups.com
обсуждение исходный текст
Ответ на Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
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...@commandprompt.com (Alvaro Herrera) wrote:
> DNS escribi=F3:
>
> > On 27 avr, 19:17, t...@sss.pgh.pa.us (Tom Lane) wrote:
>
> > > This is just a warning, which most likely is there only because someb=
ody
> > > typed COMMIT or ABORT unnecessarily.  What problem are you actually h=
aving?
>
> > 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.co=
m/
> The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Evgeny Gridasov
Дата:
Сообщение: Re: BUG #3261: autovacuum starts regarding config setting
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PGSQL - WARNING: 25P01: there is no transaction in progress