> 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
