pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash
2+ messages / 2 participants
[nested] [flat]
* BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash
@ 2025-09-15 20:00 PG Bug reporting form <noreply@postgresql.org>
2025-09-15 20:30 ` Re: BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2025-09-15 20:00 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: sibowu@amazon.com
The following bug has been logged on the website:
Bug reference: 19054
Logged by: sibo wu
Email address: sibowu@amazon.com
PostgreSQL version: 17.6
Operating system: mac
Description:
PostgreSQL's array implementation can lead to server crashes due to
uncontrolled memory consumption during array operations. When performing
continuous array modifications within a loop, the server eventually exhausts
available memory and crashes, affecting all connected sessions.
psql (17.6)
Type "help" for help.
DO
$$
DECLARE
a_1 text[];
a text;
i bigint default 1;
BEGIN
a := repeat('A',pow(2,29)::int);
while true
loop
a_1[i] := a;
i := i + 1;
END LOOP;
END
$$;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?> quit
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash
2025-09-15 20:00 BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash PG Bug reporting form <noreply@postgresql.org>
@ 2025-09-15 20:30 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2025-09-15 20:30 UTC (permalink / raw)
To: sibowu@amazon.com; pgsql-bugs@lists.postgresql.org
On Mon, 2025-09-15 at 20:00 +0000, PG Bug reporting form wrote:
> PostgreSQL's array implementation can lead to server crashes due to
> uncontrolled memory consumption during array operations. When performing
> continuous array modifications within a loop, the server eventually exhausts
> available memory and crashes, affecting all connected sessions.
That's not a bug, that's a user error.
For reliable operation, you have to disable Linux' memory overcommit.
Then the kernel won't kill the database, but your query will receive an
"out of memory" error and fail without any crashes.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-09-15 20:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-09-15 20:00 BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash PG Bug reporting form <noreply@postgresql.org>
2025-09-15 20:30 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox