Getting PSQLException in server log due to memory issue .

Solution Verified - Updated -

Issue

  • Configured postgresql datasource , and getting below error .
2023-07-04T04:46:40.313130697Z Caused by: org.postgresql.util.PSQLException: FATAL: Connection rejected. Memory usage is too close to the memory cap
2023-07-04T04:46:40.313130697Z   Hint: Wait for queries on other connections to finish and then retry
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:463)
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:203)
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:201)
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.Driver.makeConnection(Driver.java:454)
2023-07-04T04:46:40.313130697Z  at org.postgresql@42.2.3//org.postgresql.Driver.connect(Driver.java:256)
2023-07-04T04:46:40.313130697Z  at org.jboss.ironjacamar.jdbcadapters@1.4.27.Final-redhat-00001//org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
2023-07-04T04:46:40.313130697Z  ... 115 more

Environment

  • Red Hat Single Sign-On (SSO)
    • 7.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content