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:
/message-id/CAApHDvrkXT%2Bzhrusz7xdRBS3jZR%3DkB32AgBc4cnFCtxTaxQHvA%40mail.gmail.com
There's also a comment here:
/about/news/postgresql-weekly-news-may-23-2021-2217/
Which points to:
/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
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 |