Possible premature SNAPBUILD_CONSISTENT with DB-specific running_xacts - Mailing list pgsql-hackers

From SATYANARAYANA NARLAPURAM
Subject Possible premature SNAPBUILD_CONSISTENT with DB-specific running_xacts
Date
Msg-id CAHg+QDcQak4jx_6X2_Ws98rzG=xBARLjqm_=56wTRUtNsY4DZQ@mail.gmail.com
Whole thread
Responses Re: Possible premature SNAPBUILD_CONSISTENT with DB-specific running_xacts
List pgsql-hackers
Hi hackers,

A cluster-wide decoder must never have its snapshot-builder state changed
by a database-specific running_xacts record. Adding a check to return it early.
I think otherwise a cluster wide decoder can potentially go to 
SNAPSHOT_CONSISTENT state immediately even though transactions older
than nextXid are still in progress on a different DB (not tracked by running_xact
record). This race is now possible with cluster wide decoders and Repack
concurrently run.


Attached a patch to fix this. Thoughts?

Thanks
Satya
Attachment

pgsql-hackers by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: SQL:2011 Application Time Update & Delete
Next
From: Alexander Lakhin
Date:
Subject: Re: Typos in the code and README