NOTICE: AbortTransaction and not in in-progress - Mailing list pgsql-hackers

From Kristofer Munn
Subject NOTICE: AbortTransaction and not in in-progress
Date
Msg-id Pine.LNX.4.04.9912011617550.5638-100000@dec.munn.com
Whole thread Raw
Responses Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress
List pgsql-hackers
Hi guys, thanks for all your great work on this system.  I'm really
hammering my copy of Postgres and that's probably the only reason I'm
seeing these errors.

PostgreSQL V6.5.2 on i686-pc-linux-gnu

I occasionally (twice a day) receive the error:
NOTICE: AbortTransaction and not in in-progress

And in the system log I see:
FATAL 1:  transaction commit failed on magnetic diskNOTICE:  AbortTransaction and not in in-progress

The connection to the backend drops.  I'm detecting the fatal error,
reconnecting and re-issuing the command right away and it goes through
fine the second time.

Any suggestions?

- K

Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * ICQ 352499 * www.munn.com



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] When postgres will be faster?
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress