Re: There's some sort of race condition with the new FSM stuff - Mailing list pgsql-hackers

From Tom Lane
Subject Re: There's some sort of race condition with the new FSM stuff
Date
Msg-id 14994.1224017574@sss.pgh.pa.us
Whole thread Raw
In response to Re: There's some sort of race condition with the new FSM stuff  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> The bug only affected fsync/forget requests that are forwarded from 
> backends, not the ones that bgwriter puts into the hash table itself.

Oh, of course.  So the actual sequence of events was:
* bgwriter queues an fsync request for a FSM fork, after  writing a dirty FSM buffer.* backend drops table, sends
forgetrequest for FSM fork,  which the bug converts into an extra forget for the main fork.* at checkpoint, we got
trouble.

> I noted that kudu has a small shared_buffers setting, 5.6 MB, compared to 
> most buildfarm members, which might explain different behavior wrt. 
> which buffers are written by backends and which are written by bgwriter.

Yup, that must have been the determining factor.  That would also
explain a certain amount of nondeterminism in the bug's manifestation,
which also squares with the buildfarm observations.

Okay, I feel better now.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: spoonbill is failing citext test
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: spoonbill is failing citext test