Log Message: ----------- Fix an old bug in multixact and two-phase commit. Prepared transactions can be part of multixacts, so allocate a slot for each prepared transaction in the "oldest member" array in multixact.c. On PREPARE TRANSACTION, transfer the oldest member value from the current backends slot to the prepared xact slot. Also save and recover the value from the 2pc state file.
The symptom of the bug was that after a transaction prepared, a shared lock still held by the prepared transaction was sometimes ignored by other transactions. Fix back to 8.1, where both 2PC and multixact were introduced. Tags: ---- REL8_4_STABLE Modified Files: -------------- pgsql/src/backend/access/transam: multixact.c (r1.31 -> r1.31.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/multixact.c?r1=1.31&r2=1.31.2.1) twophase.c (r1.54 -> r1.54.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase.c?r1=1.54&r2=1.54.2.1) twophase_rmgr.c (r1.8 -> r1.8.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase_rmgr.c?r1=1.8&r2=1.8.2.1) xact.c (r1.274 -> r1.274.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c?r1=1.274&r2=1.274.2.1) pgsql/src/include/access: multixact.h (r1.14 -> r1.14.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/multixact.h?r1=1.14&r2=1.14.2.1) twophase.h (r1.11 -> r1.11.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/twophase.h?r1=1.11&r2=1.11.2.1) twophase_rmgr.h (r1.7 -> r1.7.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/twophase_rmgr.h?r1=1.7&r2=1.7.2.1) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers