Re: subscriptionCheck failures on nightjar - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: subscriptionCheck failures on nightjar
Date
Msg-id 20190920220620.GA5214@alvherre.pgsql
Whole thread Raw
In response to Re: subscriptionCheck failures on nightjar  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: subscriptionCheck failures on nightjar
Re: subscriptionCheck failures on nightjar
List pgsql-hackers
On 2019-Sep-20, Tom Lane wrote:

> Actually, what I did was as attached [1], and I am getting traces like
> [2].  The problem seems to occur only when there are two or three
> processes concurrently creating the same snapshot file.  It's not
> obvious from the debug trace, but the snapshot file *does* exist
> after the music stops.

Uh .. I didn't think it was possible that we would build the same
snapshot file more than once.  Isn't that a waste of time anyway?  Maybe
we can fix the symptom by just not doing that in the first place?
I don't have a strategy to do that, but seems worth considering before
retiring the bf animals.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: subscriptionCheck failures on nightjar
Next
From: Andres Freund
Date:
Subject: Re: subscriptionCheck failures on nightjar