simple_heap_update problem

From: nmueller(at)cs(dot)wisc(dot)edu
To: pgsql-hackers(at)postgresql(dot)org
Subject: simple_heap_update problem
Date: 2003-08-10 20:29:32
Message-ID: 200308102029.PAA29081@norm.cs.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For the last few weeks (still haven't figure out what changed before
this started) one of our apps has been generating this error message on
the backend one or two times a day. I'm pretty sure it's not an
application error since it can be successfully re-run with the same
inputs. The application does several queries and I'm not sure which one
causes the error. I searched the web and found this error being caused
by concurrent ANALYZE commands, but that's not happening here.

Aug 7 13:23:30 calchas postgres[27794]: [3] ERROR: simple_heap_update:
tuple concurrently updated Aug 7 13:23:30 calchas postgres[27794]: [4]
WARNING: AbortTransaction and not in in-progress state

Any ideas? I realize this isn't too much information -- what can I do
(besides logging queries, which I just started) to get more?

--Nate

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message nmueller 2003-08-10 20:30:00 Re: simple_heap_update problem
Previous Message Tom Lane 2003-08-10 19:50:06 Re: 7.4Beta1 hang?