Postgres 16.1 - Bug: cache entry already complete - Mailing list pgsql-bugs

Hi,

Upgrading from Postgres 14 to Postgres 16.1 introduced the following error when running a query:

nativeError: error: select "date", coalesce(sum(hours), 0) as "hours" from "allocation_date" where "allocation_date"."project_id" = $1 and "allocation_date"."date" > $2 and "allocation_date"."hours" > $3 group by "date" order by "date" asc - cache entry already complete

Note that `allocation_date` is a fairly complex view. Not quite sure what causes the "cache entry already complete", but it consistently failed in both the MacOS and Windows installations.

Maybe it's a regression of:

There's also a comment here:

Which points to:

Anything I can do to help you reproduce this?

Thanks,
--