Is cachedFetchXidStatus provably valid?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Is cachedFetchXidStatus provably valid?
Date: 2012-06-13 17:22:36
Message-ID: CAHyXU0xTrwnFU0MaZ1EsgRihD_f5V9FE2W=Bf2kfgxVpcnCK8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It's probably an academic concern, but what happens if a backend saves
off cachedFetchXidStatus and then sleeps for a very long time. During
that time an xid wraparound happens and the backend wakes up and
happens to read another unhinted tuple with the same xid and a
different commit status. This is obviously incredibly unlikely, but
shouldn't cachedFetchXid be cleared at some appropriate point --
perhaps end of transaction?

merlin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-06-13 17:22:39 Re: uncataloged tables are a vestigial husk
Previous Message Robert Haas 2012-06-13 17:17:39 Re: uncataloged tables are a vestigial husk