From: | SZŰCS Gábor <surrano(at)mailbox(dot)hu> |
---|---|
To: | "PGH" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | simple_heap_update: tuple concurrently updated -- during INSERT |
Date: | 2004-06-09 08:31:20 |
Message-ID: | 00a101c44dfc$26afcf90$0403a8c0@fejleszt4 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear Gurus,
I tried to shuffle through the archives but was lost in the technical
details. Please feel free to tell me a search keyword suitable for my case
if there's any.
QUESTION1: is this error _always_ harmless (other than transaction
rollback)?
QUESTION2: is this reported exactly like other errors? i.e. in psql, through
psqlodbc, etc.
As you can see below, this came during an INSERT. I don't really understand
the warning.
QUESTION3: May I assume that the transaction aborted even before it began?
QUESTION4: If that's so, does it rule out triggers and such?
QUESTION5: May it be a problem in 7.3.x that's fixed in 7.4.y?
System: PostgreSQL 7.3.4, Dual Xeon HT
Log:
ERROR: simple_heap_update: tuple concurrently updatedog.
LOG: statement: INSERT INTO pakolas_cikktetel
(cikk, minoseg, helyrol, mennyi, pakolas, sorszam, helyre) VALUES
(102165, 1, 1488, '25', 68615, 1, 1338)
DEBUG: AbortCurrentTransaction
WARNING: AbortTransaction and not in in-progress state
I read in an earlier post that turning on statement logging and duration may
help. If we can reproduce this error, I will. So far this is the only
occurence.
G.
%----------------------- cut here -----------------------%
\end
From | Date | Subject | |
---|---|---|---|
Next Message | Tommi Maekitalo | 2004-06-09 08:39:33 | Re: Question regarding dynamic_library_path |
Previous Message | Thomas Hallgren | 2004-06-09 07:57:07 | Re: Question regarding dynamic_library_path |