bhargav kamineni writes:
>> So ... how many is "a bunch"?
> more than 85
Hm. That doesn't seem like it'd be enough to trigger the problem;
you'd need about max_connections excess connections (that are shortly
going to be rejected) to run into this problem, and you said you
had max_connections =
Thanks Tom Lane for detailing the issue.
>So ... how many is "a bunch"?
more than 85
>Looking at the code, it seems like it'd be possible for a sufficiently
>aggressive spawner of incoming connections to reach the
>MaxLivePostmasterChildren limit. While the postmaster would correctly
>reject addi
On 2019-Oct-03, bhargav kamineni wrote:
> bhargav kamineni writes:
> > Postgres was rejecting a bunch of connections from a user who is having a
> > connection limit set. that was the the FATAL error that i could see in log
> > file.
> > FATAL,53300,"too many connections for role ""user_app"""
>
bhargav kamineni writes:
>> What was the database doing just before the FATAL line?
> Postgres was rejecting a bunch of connections from a user who is having a
> connection limit set. that was the the FATAL error that i could see in log
> file.
> FATAL,53300,"too many connections for role ""user
bhargav kamineni writes:
> Postgres was rejecting a bunch of connections from a user who is having a
> connection limit set. that was the the FATAL error that i could see in log
> file.
> FATAL,53300,"too many connections for role ""user_app"""
> db=\du user_app
>List
bhargav kamineni writes:
> Postgres was rejecting a bunch of connections from a user who is having a
> connection limit set. that was the the FATAL error that i could see in log
> file.
> FATAL,53300,"too many connections for role ""user_app"""
> db=\du user_app
>List
> Hi,
>
> Observed below errors in logfile
>
> 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07
> 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags
array",""
> 2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,
On 10/3/19 3:57 AM, bhargav kamineni wrote:
Hi,
Observed below errors in logfile
2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07
04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array",""
2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8
Any suggestions on this ?
On Thu, 3 Oct 2019 at 16:27, bhargav kamineni
wrote:
> Hi,
>
> Observed below errors in logfile
>
> 2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07
> 04:21:14 UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array",,
Hi,
Observed below errors in logfile
2019-09-20 02:00:24.504 UTC,,,99779,,5d73303a.185c3,73,,2019-09-07 04:21:14
UTC,,0,FATAL,XX000,"no free slots in PMChildFlags array",""
2019-09-20 02:00:24.505 UTC,,,109949,,5d8432b8.1ad7d,1,,2019-09-20 02:00:24
UTC,,0,ERROR,5
10 matches
Mail list logo
