Horton

Re: BUG #18375: requested statistics kind "f" is not yet built for statistics object 16722

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: horst.reiterer@fabasoft.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2024-03-04T17:11:33Z
Lists: pgsql-bugs 
PG Bug reporting form <noreply@postgresql.org> writes:
> Since upgrading from 15.5 to 15.6, the following error occurs once during a
> test run:

>   requested statistics kind "f" is not yet built for statistics object
> 16722
>   mcv.c:577 statext_mcv_load
>   Statement: DELETE FROM test WHERE (col3 IN
> (501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,51]

I could not reproduce this on the basis of the supplied information.
Can you put together a self-contained test case, that is a SQL script
that reproduces the failure starting from an empty database?

			regards, tom lane

Commits

  1. Fix incorrectly reported stats kind in "can't happen" ERROR