> Question: do you have any leftover files in $PGDATA/pg_twophase ?
>
> I'm wondering why the log contains no warning messages about stale
> two-phase state files. It looks to me like the system should have
> found the two-phase file still there upon restart, but the transaction
> should have been marked already committed.
>
> BTW, can you tell whether the failing transactions actually were committed
> --- are their effects still visible in the database?
>
> regards, tom lane
Tom,
Thanks for your continuous support, I appreciate a lot.
The failing transaction is visible in the database after restart, I have
checked three of the last inserts, e.g.
2007-04-21 18:06:18.921 20160 LOG: execute <unnamed>: insert into
CHECKRESULT (COMMENT, POSITIONINCHAIN, MDSD_OPT_LOCK, MDSD_CLASS, ID) values
($1, $2, $3, 'CheckResult', $4)
2007-04-21 18:06:18.921 20160 DETAIL: parameters: $1 = 'geht schon', $2 =
'2', $3 = '2007-04-21 18:06:18.64', $4 = '4046'
is visible. I can tell from the application, that this record will never be
updated later on and always has the current timestamp.
I have no leftover file in $PGDATA/pg_twophase, it is empty.
Best Regards
-- Michel