Search Postgresql Archives

Very frequent "Too many clients" eventually crashes postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux