Very frequent "Too many clients" eventually crashes postmaster

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: Very frequent "Too many clients" eventually crashes postmaster
Date: 2020-05-03 14:28:48
Message-ID: 210ed63ba2814d99971e43000d9c3c4b@phx-exmbprd-01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-05-03 14:36:50 Re: Very frequent "Too many clients" eventually crashes postmaster
Previous Message Tom Lane 2020-05-03 14:26:50 Re: Compiling C Extension Functions against PostgreSQL 12