Re: simple_heap_update problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nmueller(at)cs(dot)wisc(dot)edu
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: simple_heap_update problem
Date: 2003-08-11 15:49:39
Message-ID: 2989.1060616979@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

nmueller(at)cs(dot)wisc(dot)edu writes:
> Aug 7 13:23:30 calchas postgres[27794]: [3] ERROR: simple_heap_update:
> tuple concurrently updated

The only case of this I'm aware of is the concurrent-ANALYZE issue,
which is pretty harmless. But you say it's not that. I'd suggest
turning on log_statement and log_duration so that you can determine
(a) what query is reporting this failure and (b) what was running
concurrently with it. When you have that info for a few occurrences,
send it along and we'll try to figure out what's happening.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-08-11 15:54:39 Re: Windows on SuSE? 7.4
Previous Message Tom Lane 2003-08-11 15:45:53 Re: Farewell