6.3 spurious transaction aborted problem - Mailing list pgsql-hackers

From Erik Rantapaa
Subject 6.3 spurious transaction aborted problem
Date
Msg-id Pine.GSO.3.95q.990708131348.20719C-100000@scarlet
Whole thread Raw
List pgsql-hackers
Hello,

I have a product which uses Postgres 6.3.  I believe it really is 6.3 and
not 6.3.1 or 6.3.2.  I know this version is over a year old, and I've
tried to convince the other developers to upgrade, but they hadn't any
problems at all with the database and didn't want to introduce any new
variables.

A problem I've seen recently are "spurious" transaction aborted errors.
The exact message is: transaction aborted -- queries ignored until END.
I don't why they are happening, and I haven't yet been able to track down
what part of the code is emitting them.  They seem to happen randomly
and not all that frequently, so they are hard to reproduce. Is it possible
that multiple processes accessing the database could trigger this message?

Another quick question while I have your attention: several places in our
client code there are commits being done "early" with comments like
"clear read locks".  It seems, though, that you can never get blocked by a
transaction you started yourself, so I'm trying to figure out why the
previous set of developers felt it necessary to perform all of these
early commits.  For the most part our Postgres instance only has one
client, so the need to clear read locks is puzzling.

Any help with these issues would be greatly appreciated!

Erik Rantapaa
erantapa@securecomputing.com



pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [Fwd: [HACKERS] Re: Postgresql 6.5-1 rpms on RedHat 6.0]
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Arbitrary tuple size