Postgres 16.1 - Bug: cache entry already complete
От | Amadeo Gallardo |
---|---|
Тема | Postgres 16.1 - Bug: cache entry already complete |
Дата | |
Msg-id | CADFREbW-BLJd7-a5J+5wjVumeFG1ByXiSOFzMtkmY_SDWckTxw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Postgres 16.1 - Bug: cache entry already complete
|
Список | 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:
https://www.postgresql.org/message-id/CAApHDvrkXT%2Bzhrusz7xdRBS3jZR%3DkB32AgBc4cnFCtxTaxQHvA%40mail.gmail.comThere's also a comment here:
Which points to:
Anything I can do to help you reproduce this?
В списке pgsql-bugs по дате отправления: