Re: Intermittent test plan change in "privileges" test on BF animal prion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Intermittent test plan change in "privileges" test on BF animal prion
Date: 2020-06-09 05:22:57
Message-ID: 2191684.1591680177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> I'm trying to reproduce this now, but it's sounding pretty plausible.

Yeah, that's definitely it. I was able to reproduce the failure semi
reliably (every two or three tries) after adding -DRELCACHE_FORCE_RELEASE
-DCATCACHE_FORCE_RELEASE and inserting a "pg_sleep(1)" just after the
manual vacuum in privileges.sql; and as you'd guessed, the stats arrays
were just normal size in the failing runs. After disabling autovac on
the table, the failure went away.

Thanks for the insight!

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2020-06-09 05:47:08 Re: Add -Wold-style-definition to CFLAGS?
Previous Message Andy Fan 2020-06-09 05:09:45 Re: A wrong index choose issue because of inaccurate statistics