Any remote person or system using Mitto’s database opens a new connection, also any Mitto job that uses Mitto’s internal database opens a connection. If there are lots of jobs running at the same time and/or a lot of people on your team using the database, or a service like Tableau is using it as a datasource it is possible to max out the allowed number of connections.
When that happens you might see an error like:
FATAL: sorry, too many clients already
To see details about the connections in your database client (datagrip, for example), connect to the mitto database and try the following queries:
-- see the number of connections by user at a summary level SELECT * FROM pg_stat_database; -- See the connection details SELECT * FROM pg_stat_activity;
If this is an ongoing issue and Zuar is hosting your Mitto, contact Zuar Support for assistance in changing the limit.