Re: What is happening on buildfarm member dugong

Tom Lane wrote:
> Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
>> It seems to me last run
>> (http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=dugong&dt=2007-09-11%2016:05:01)
>> points to problem with hash implementation.
>
>> SELECT to_tsvector('thesaurus_tst', 'one postgres one two one two three one');
>> + NOTICE: thesaurus word-sample "the" is recognized as stop-word, assign any
>> stop-word (rule 8)
>
>> At this place of tsdicts test dictionary thesaurus should be already loaded and
>> initialized, but this NOTICE points that thesaurus was initialized here.
>
> I just realized what that probably is actually from: there was a cache
> invalidation event sometime between when thesaurus was initially loaded
> and when this statement tried to use it, so the ts_cache entry had to
> be reloaded. The parallel regression tests are quite capable of
> provoking sinval queue overflows (and ensuing cache resets) at fairly
> random places.
>
> It is not good design to have any user-visible behavior that occurs during
> a cache load, because you can't predict when those will happen. Perhaps
> this NOTICE should not be emitted, or should be emitted from some other
> place.
>
> (In fact, this test ought to be failing right now on whichever buildfarm
> machine is supposed to be testing CLOBBER_CACHE_ALWAYS. Which animal
> was that again?)

fwiw - I managed to trigger that exact same regression failure during my
testing of the pltcl patch on quagga too ...

Stefan