Re: BUG #18514: Encountering an error invalid DSA memory alloc request size 1811939328 when executing script

On Mon, Jun 17, 2024 at 1:14 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18514
> Logged by: iwebcas
> Email address: iwebcas(at)gmail(dot)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

https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-PLAN-CACHE-MODE

David J.