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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.com

There's also a comment here:

Which points to:

Anything I can do to help you reproduce this?

Thanks,
--
Amadeo Gallardo
mobile: 786.961.0106

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18266: Restore process request way too many archive log files via pgbackrest
Следующее
От: Artur Zakirov
Дата:
Сообщение: Re: Out of the box, full text search feature suggestion for postgresql