After upgrading from ACE 8.5.0 to 8.6.0 (or later), approximately 50% of requests fail with the following error:
Authentication verification error (500): Could not lookup stored client data for …: SequelizeConnectionError: too many connections for role “…”
According to the Postgres metrics, the issue appears to be on the application side, as there are sufficient free connections available in the database. Additionally, no changes were made to the connection pool settings.
Could you provide guidance on how to resolve this?
Note: With ACE 8.6.0, the “remote backend for Forge” capability was introduced, which adds a new RDBMS table (InstallationClientKeys). Could this new feature be affecting connection handling?