Postgres 16.1 - Bug: cache entry already complete

From: Amadeo Gallardo <amadeo(at)ruddr(dot)io>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Postgres 16.1 - Bug: cache entry already complete
Date: 2024-01-02 15:36:11
Message-ID: CADFREbW-BLJd7-a5J+5wjVumeFG1ByXiSOFzMtkmY_SDWckTxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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:
https://www.postgresql.org/about/news/postgresql-weekly-news-may-23-2021-2217/

Which points to:
https://www.postgresql.org/message-id/CAOxo6X+dy-V58iEPFgst8ahPKEU+38NZzUuc+a7wDBZd4TrHMQ@mail.gmail.com

Anything I can do to help you reproduce this?

Thanks,
--
*Amadeo Gallardo*
email: amadeo(at)ruddr(dot)io
mobile: 786.961.0106
web: www.ruddr.io

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Artur Zakirov 2024-01-02 17:20:51 Re: Out of the box, full text search feature suggestion for postgresql
Previous Message PG Bug reporting form 2024-01-02 13:38:31 BUG #18266: Restore process request way too many archive log files via pgbackrest