Very frequent "Too many clients" eventually crashes postmaster

Поиск
Список
Период
Сортировка
От Abraham, Danny
Тема Very frequent "Too many clients" eventually crashes postmaster
Дата
Msg-id 210ed63ba2814d99971e43000d9c3c4b@phx-exmbprd-01.adprod.bmc.com
обсуждение исходный текст
Ответы Re: Very frequent "Too many clients" eventually crashes postmaster
Re: Very frequent "Too many clients" eventually crashes postmaster
Список pgsql-general
Is there a way to eliminate postmaster crash/core ?

A surge in short-term connections eventually crashes PG on  "no free slots in PMChildFlags array".

Happens on AIX 7.2

=>grep "2020-05-02 08:16" * | grep clients | wc -l
       0
=>grep "2020-05-02 08:17" * | grep clients | wc -l
       0
=>grep "2020-05-02 08:18" * | grep clients | wc -l
     309
=>grep "2020-05-02 08:19" * | grep clients | wc -l
     603
=>grep "2020-05-02 08:20" * | grep clients | wc -l
     288
=>grep "2020-05-02 08:21" * | grep clients | wc -l
     230

2020-05-02 08:21:27.653 CDTFATAL:  no free slots in PMChildFlags array




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Compiling C Extension Functions against PostgreSQL 12
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Very frequent "Too many clients" eventually crashes postmaster