Services backed by PostgreSQL fail or stop responding
When the number of connections between the CDP services and the PostgreSQL database
exceeds the preset connection limit, it is possible that a new connection fails, Cloudera
Manager stops responding, and you cannot log into Hue. The logs show a “FATAL:
remaining connection slots are reserved for non-replication superuser
connections
”
error.
The number of connections between the CDP services and the PostgreSQL database is
governed by the max_connections
setting. By default, the maximum
number of available connections to your PostgreSQL database is 115. 15 connections
are reserved for the superuser to maintain the state and integrity of your database,
and 100 connections are available for CDP and other
services.
-
Check the number of available and idle connections:
-
If most connections are idle and the
max_connections
value is less than 100, then increase themax_connections
value in thepostgresql.conf
file: