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

Started by DNSalmost 19 years ago9 messagesbugs
Jump to latest
#1DNS
letanloc@gmail.com

Hello,

I have the following Warning with Postgresql, can anybody helps:

1- My server is crashing suddenbly
2- I do a cold reboot
3- In pgsql log, I have this message:
2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no
transaction in progress
2007-04-27 14:15:05 EDT user database LOCATION: EndTransactionBlock,
xact.c:2878
4- I try to search the transaction ID but can't find it.
5- How can I identify the transaction that caused this problem ? Is
there any log for the past transactions in PgSQL ?

I have found there is maybe two methods to correct the problem. It's
with ROLLBACK PREPARED or REINDEX but I'm not sure if it would work.

If someone can advice me steps-by-steps how to fix this error.

Thank you for your help.

#2DNS
letanloc@gmail.com
In reply to: DNS (#1)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

I forget to add, it's PGSQL version 8.1 . Thank you!

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: DNS (#1)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

DNS <letanloc@gmail.com> writes:

3- In pgsql log, I have this message:
2007-04-27 14:15:05 EDT user database WARNING: 25P01: there is no
transaction in progress

This is just a warning, which most likely is there only because somebody
typed COMMIT or ABORT unnecessarily. What problem are you actually having?

I forget to add, it's PGSQL version 8.1 . Thank you!

8.1.what?

regards, tom lane

#4DNS
letanloc@gmail.com
In reply to: Tom Lane (#3)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

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 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.

I forget to add, it's PGSQL version 8.1 . Thank you!

8.1.what?

It' 8.1.8

regards, tom lane

Regards,

#5Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: DNS (#4)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

DNS escribi�:

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 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.

#6DNS
letanloc@gmail.com
In reply to: Alvaro Herrera (#5)
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,

Show quoted text

On 2 mai, 10:02, alvhe...@commandprompt.com (Alvaro Herrera) wrote:

DNS escribió:

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 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.

#7Heikki Linnakangas
heikki.linnakangas@enterprisedb.com
In reply to: DNS (#6)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

DNS wrote:

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 ?

You could put log_statement = all to your postgresql.conf. That'll log
every statement sent to the server to the log file.

There's no other way to see past statements from the server side.
There's no such thing as a queue of transactions.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

#8Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: DNS (#6)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

DNS escribi�:

Even desactivate Auto-vacuum didn't fix my issue.

I don't think anybody ever suggested that autovacuum had something to do
with it.

Is there any place
where I can see past transactions or transactions in queue that hasn't
been processed ?

Why are you bothering with investigating transactions when the message
states perfectly clearly that there is no transaction involved?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

#9DNS
letanloc@gmail.com
In reply to: Heikki Linnakangas (#7)
Re: PGSQL - WARNING: 25P01: there is no transaction in progress

Thanks alot, log_statement = all shows where come the errors.

Show quoted text

On 4 mai, 10:49, hei...@enterprisedb.com (Heikki Linnakangas) wrote:

DNS wrote:

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 ?

You could put log_statement = all to your postgresql.conf. That'll log
every statement sent to the server to the log file.

There's no other way to see past statements from the server side.
There's no such thing as a queue of transactions.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com