Got IJ000453: Unable to get managed connection while navigating the active users at admin console - show sessions

316 views

Skip to first unread message

Tim Chiu

unread,

Oct 24, 2021, 11:41:36 AM10/24/21

to Keycloak User

We recently have ungraded to KeyCloak 13.0.1 from 3.4.3.final and experienced some error responses while navigating the “Show Sessions” at KeyCloak admin console. One of examples is:

1. Login to Keycloak admin console

2. Navigate to interesting realm and Manage/Sessions

3. Click on interesting client

4. Click on Show Sessions

5. Click Next Page serval times and successfully show the active Users

6. Eventually got a red error message “Error! No response from server”

Following are the detail log :

======================================================================

2021-10-24 12:34:01,641 WARN [com.arjuna.ats.arjuna] (default task-243) ARJUNA012141: Multiple last resources have been added to the current transaction. This is transactionally unsafe and should not be relied upon. Current resource is LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@1f37ac87[connectionListener=74e856c6 connectionManager=2a065246 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac1c0558:544f4429:616ad444:124373, node_name=1, branch_uid=0:ffffac1c0558:544f4429:616ad444:124377, subordinatenodename=null, eis_name=java:jboss/datasources/UserDS > productName=PostgreSQL productVersion=12.7 jndiName=java:jboss/datasources/UserDS]))

2021-10-24 12:34:01,645 WARN [com.arjuna.ats.arjuna] (default task-243) ARJUNA012141: Multiple last resources have been added to the current transaction. This is transactionally unsafe and should not be relied upon. Current resource is LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@546ee1ea[connectionListener=44098a1e connectionManager=293e6221 warned=false currentXid=null productName=PostgreSQL productVersion=12.7 jndiName=java:jboss/datasources/KeycloakDS]))

2021-10-24 12:34:02,805 WARN [com.arjuna.ats.arjuna] (default task-243) ARJUNA012141: Multiple last resources have been added to the current transaction. This is transactionally unsafe and should not be relied upon. Current resource is LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@4507b63c[connectionListener=3ee7f2a3 connectionManager=2a065246 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac1c0558:544f4429:616ad444:12437d, node_name=1, branch_uid=0:ffffac1c0558:544f4429:616ad444:124381, subordinatenodename=null, eis_name=java:jboss/datasources/UserDS > productName=PostgreSQL productVersion=12.7 jndiName=java:jboss/datasources/UserDS]))

2021-10-24 12:34:32,809 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ForkJoinPool.commonPool-worker-6) SQL Error: 0, SQLState: null

2021-10-24 12:34:32,809 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ForkJoinPool.commonPool-worker-6) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDS

2021-10-24 12:34:32,809 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-243) Uncaught server error: com.fasterxml.jackson.databind.JsonMappingException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

…….

Caused by: javax.persistence.PersistenceException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

…….

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection

…….

Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDS

……

Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDS

==================================================================

We have two DBs setup: one is keycloak local db and the other is external user db for the User Storage SPI.

Some users of the client at keycloak local db and some users are from external user db. The users from both dbs have active sessions.

Need help for the root of cause

Thanks

Tim

Reply all

Reply to author

Forward

0 new messages