topic Re: FATAL: sorry, too many clients already in ArcGIS Workflow Manager Questions

FATAL: sorry, too many clients already

Ranga_Tolapi — Sun, 30 Jul 2023 11:25:35 GMT

ArcGIS Workflow Manager: Version 10.9.1
High-Availability Enabled: Yes (2 Nodes)
OS: Windows Server 2022

Noticed below messages in the Hosted ArcGIS Server logs.

Hosted/workflow_8c15153a74f749328ba775b2bc9ae837/FeatureServer: FATAL: remaining connection slots are reserved for non-replication superuser connections.

Hosted/workflow_8c15153a74f749328ba775b2bc9ae837/FeatureServer: FATAL: sorry, too many clients already.

Workflow Manager becomes unstable once encountered these errors. What need to be done to resolve this?

@JFarmer requesting for your valuable response please.

Re: FATAL: sorry, too many clients already

Ranga_Tolapi — Mon, 31 Jul 2023 15:39:09 GMT

Hi @JFarmer

For now, increased the Maximum connections property of ArcGIS Data Store from default 150 to 300 using changedbproperties tool.

Fingers crossed.

Can you throw some light on this please.

Re: FATAL: sorry, too many clients already

JENNIFERHIGGS — Wed, 27 Mar 2024 17:07:47 GMT

Did this solve the problem for you? We are running into the issue as well and it is making our hosting server unstable. We have only seen these issues since starting to work with Workflow Manager.