Re: BUG #18514: Encountering an error invalid DSA memory alloc request size 1811939328 when executing script
| От | David G. Johnston |
|---|---|
| Тема | Re: BUG #18514: Encountering an error invalid DSA memory alloc request size 1811939328 when executing script |
| Дата | |
| Msg-id | CAKFQuwZ4XUhB1N=+QhLV3t1Qjpk0ZnDxW67d7EbKkEo2UtFKow@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #18514: Encountering an error invalid DSA memory alloc request size 1811939328 when executing script (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
Re: BUG #18514: Encountering an error invalid DSA memory alloc request size 1811939328 when executing script
|
| Список | pgsql-bugs |
On Mon, Jun 17, 2024 at 1:14 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 18514
Logged by: iwebcas
Email address: iwebcas@gmail.com
PostgreSQL version: 16.3
Operating system: Debian 8.3.0-6 (PostgreSQL 16.3)
Description:
Issue Report: Invalid DSA Memory Allocation Request Size
Summary:
Encountering an error invalid DSA memory alloc request size 1811939328 when
executing a prepared statement after multiple runs. The error occurs due to
a different execution plan being chosen on the 6th attempt.
[...]
Version on which the error is not reproduced: "PostgreSQL 16.2 (Debian
16.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6)
8.3.0, 64-bit"
If this is indeed a regression from 16.2 odds are good you will need to work around the bug. Namely by ensuring that a generic plan for that query is never chosen. See: plan_cache_mode
David J.
В списке pgsql-bugs по дате отправления: