Horton

Followup fixes for transaction_timeout

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: bf82f43790a675dd1b9522a7799357e61e7aa635
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-02-16T01:36:38Z
Releases: 17.0 
Followup fixes for transaction_timeout

Don't deal with transaction timeout in PostgresMain().  Instead, release
transaction timeout activated by StartTransaction() in
CommitTransaction()/AbortTransaction()/PrepareTransaction().  Deal with both
enabling and disabling transaction timeout in assign_transaction_timeout().

Also, remove potentially flaky timeouts-long isolation test, which has no
guarantees to pass on slow/busy machines.

Reported-by: Andres Freund
Discussion: https://postgr.es/m/20240215230856.pc6k57tqxt7fhldm%40awork3.anarazel.de

Files

PathChange+/−
src/backend/access/transam/xact.c modified +12 −0
src/backend/tcop/postgres.c modified +11 −20
src/test/isolation/isolation_schedule modified +0 −1
src/test/isolation/specs/timeouts-long.spec deleted +0 −35

Discussion