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

From: DNS <letanloc(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PGSQL - WARNING: 25P01: there is no transaction in progress
Date: 2007-04-27 18:23:29
Message-ID: 1177698209.504621.224560@c18g2000prb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message DNS 2007-04-27 18:26:12 Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Previous Message Tom Lane 2007-04-27 16:22:24 Re: [BUGS] BUG #3244: problem with PREPARE