Error "FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute" during WCC startup

Products

• Autosys Workload Automation

Issue/Introduction

Workload Control Center (WCC) fails to start properly after installation using an external PostgreSQL database. The application logs indicate a connection pool failure.​​​​​​​

ERROR MESSAGE: "SEVERE: Unable to create initial connections of pool. org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute"

SYMPTOMS:

• WCC services do not start

• WCC logs (wcc.log) show JDBC pool creation errors

• Database connection is rejected

CONTEXT: This occurs when the PostgreSQL database has reached its maximum limit for standard client connections.

IMPACT: Users cannot access the WCC console.

Environment

 

• OS: Linux

• Database: PostgreSQL (External)

• AutoSys: 24.X

 

Cause

The PostgreSQL database has reached its configured maximum limit for client connections.
PostgreSQL reserves a small number of slots (defined by 'superuser_reserved_connections') for superusers, which triggers the specific "reserved for roles with the SUPERUSER attribute" error when standard slots are exhausted.

Resolution

1. ANALYZE WCC LOGS

   Path: $CA_WCC_INSTALL_LOCATION/log/wcc.log

   Search for the following error sequence: "FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute"

   EXPECTED: Error confirms the database connection limit is reached.

2. ENGAGE DATABASE ADMINISTRATOR

   Contact your PostgreSQL Database Administrator to review the 'max_connections' setting on the database server.

   NOTE: PostgreSQL reserves specific connection slots for superusers to allow administrative access during heavy load.

3. INCREASE CONNECTION LIMIT

   Request the Database Administrator to increase the maximum number of allowed connections for the WCC database user.

   EXPECTED: The database accepts new connections from the WCC application.

4. RESTART WCC

   Restart the WCC services to re-establish the connection pool.

   EXPECTED: WCC starts without error.

VERIFY SUCCESS:

• WCC login page is accessible

• wcc.log shows successful connection to "jdbc:postgresql://..."

Additional Information

Installation Consideration for PostgreSQL