Athletic Awards Database Prepared Transaction Audit Before Season Imports
An athletic awards database prepared transaction audit is the step of checking PostgreSQL’s pg_prepared_xacts system view — and its equivalents in other databases — before running a new season import, to confirm that no in-doubt two-phase commit transactions are holding locks or blocking storage reclamation against the recognition tables. A prepared transaction is a transaction that has been written to disk and detached from its session, waiting for an external transaction coordinator to issue the final commit or rollback signal. Finding one in an awards database before a season import does not mean something has gone wrong, but it does mean the import team needs to understand who owns that transaction and whether it is safe to proceed.
Read More
