FATAL: sorry, too many clients already

Question

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.

JENNIFERHIGGS · Answer

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.

Ranga_Tolapi · Answer

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.