Re: Incorrect visibility test function assigned to snapshot
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@lists.postgresql.org,Antonin Houska <ah@cybertec.at>,Alvaro
Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2018-05-30T13:49:44Z
Lists: pgsql-hackers
On May 30, 2018 9:45:32 AM EDT, Antonin Houska <ah@cybertec.at> wrote: >Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > >> On 2018-May-30, Antonin Houska wrote: >> >> > In the header comment, SnapBuildInitialSnapshot() claims to set >> > snapshot->satisfies to the HeapTupleSatisfiesMVCC test function, >and indeed it >> > converts the "xid" array to match its semantics (i.e. the xid items >eventually >> > represent running transactions as opposed to the committed ones). >However the >> > test function remains HeapTupleSatisfiesHistoricMVCC as set by >> > SnapBuildBuildSnapshot(). >> >> Interesting. While this sounds like an oversight that should have >> horrible consequences, it's seems not to because the current callers >> don't seem to care about the ->satisfies function. Are you able to >come >> up with some scenario in which it causes an actual problem? > >Right, the current callers in the core do not seem to use that >function. I hit >the issue when doing and testing some changes in an extension >(pg_squeeze). What is that extension doing with that snapshot? Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Commits
-
Mark correctly initial slot snapshots with MVCC type when built
- 2ad57e9e9faf 9.4.22 landed
- 03cd99a8e802 9.5.17 landed
- f131889519ad 9.6.13 landed
- a80f5c279bd5 10.8 landed
- 7ed9285c6950 11.3 landed
- 56fadbedbd2f 12.0 landed