Re: -1/0 virtualtransaction - Mailing list pgsql-general

From Mike Beachy
Subject Re: -1/0 virtualtransaction
Date
Msg-id CAEoC5=Hk+DP689K4ydsErzYN7a6tycq4-7dDfRx_C9ATGwpHzg@mail.gmail.com
Whole thread Raw
In response to Re: -1/0 virtualtransaction  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, Apr 26, 2021 at 6:16 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Hmm, that's an invalid VXID, which would ordinarily mean that nothing
is holding the lock.  There is a passing mention in mvcc.sgml that
SIRead locks sometimes need to be held past transaction end, so maybe
what you're looking at is such a lock that is no longer associated
with a specific transaction.  I have to disclaim knowing much of
anything about the SSI code, though.

Hmm, yeah. I had seen discussion of this "held past transaction end" but didn't know what to make of it.

The "Serializable Snapshot Isolation in PostgreSQL" paper (https://drkp.net/papers/ssi-vldb12.pdf) makes me think this is a reasonable line of inquiry.

Thanks,
Mike

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: -1/0 virtualtransaction
Next
From: Durgamahesh Manne
Date:
Subject: About to find all foreign tables are being used by sproc and view and function