SUSE Manager 3.1
SUSE Manager 3.2
The SUSE Manager installation has grown and connection limits reached messages are within the logs /var/log/rhn/... for any services connection to the database.
2019-08-09 13:23:36,553 [salt-event-connection-watchdog] ERROR com.suse.manager.reactor.SaltReactor - Unable to connect: com.suse.salt.netapi.exception.SaltException: java.sql.SQLException: Connection Error: Connection refused: localhost/127.0.0.1:5432, retrying in 5 seconds.INFO | jvm 1 | 2019/08/09 13:23:47 | Caused by: java.net.ConnectException: Connection refused (Connection refused)INFO | jvm 1 | 2019/08/09 13:23:47 | at java.net.Socket.connect(Socket.java:666)INFO | jvm 1 | 2019/08/09 13:23:47 | at org.postgresql.core.PGStream.<init>(PGStream.java:61)
INFO | jvm 1 | 2019/08/09 13:23:47 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:120)
Example C:INFO | jvm 1 | 2019/08/09 13:39:30 | WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5c391ca6 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
INFO | jvm 1 | 2019/08/09 13:39:30 | org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
Running following command will show if there is any mismatch between database, apache and tomcat connection settings:
Adjust postgresql max_connections setting in:
Requirements for SUSE Manager have increased and settings needs to be adjusted accordingly due to growth of connected servers or increased api usage.
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.