gistfile1.txt

2024-05-31 05:00:43.827 ERROR 821 --- [pool-50-thread-1] py.com.cast.srv.ExceptionsRecordService  : ERROR in saveExceptionRecord method: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[DataSourceUtils.class:5.1.6.RELEASE]
        at py.com.cast.srv.ExceptionsRecordService.saveExceptionRecord(ExceptionsRecordService.java:103) [ExceptionsRecordService.class:na]
        at py.com.cast.srv.ExceptionsRecordService.generateExceptionRecordForMessageGenerator(ExceptionsRecordService.java:37) [ExceptionsRecordService.class:na]
        at py.com.cast.thread.threadpool.MessageReplicaThreadPool.executeMessageGenerator(MessageReplicaThreadPool.java:170) [MessageReplicaThreadPool.class:na]
        at py.com.cast.thread.threadpool.MessageReplicaThreadPool.access$000(MessageReplicaThreadPool.java:37) [MessageReplicaThreadPool.class:na]
        at py.com.cast.thread.threadpool.MessageReplicaThreadPool$1.run(MessageReplicaThreadPool.java:98) [MessageReplicaThreadPool$1.class:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_212]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_212]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212]
Caused by: org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[QueryExecutorImpl.class:42.2.5]
        at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2559) ~[QueryExecutorImpl.class:42.2.5]
        at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:133) ~[QueryExecutorImpl.class:42.2.5]
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:250) ~[ConnectionFactoryImpl.class:42.2.5]
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[ConnectionFactory.class:42.2.5]
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[PgConnection.class:42.2.5]
        at org.postgresql.Driver.makeConnection(Driver.java:454) ~[Driver.class:42.2.5]
        at org.postgresql.Driver.connect(Driver.java:256) ~[Driver.class:42.2.5]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319) ~[PooledConnection.class:na]
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212) ~[PooledConnection.class:na]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:739) ~[ConnectionPool.class:na]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:671) ~[ConnectionPool.class:na]
        at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) ~[ConnectionPool.class:na]
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) ~[DataSourceProxy.class:na]
        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) ~[DataSourceUtils.class:5.1.6.RELEASE]
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[DataSourceUtils.class:5.1.6.RELEASE]
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[DataSourceUtils.class:5.1.6.RELEASE]
        ... 8 common frames omitted