You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Keycloak error while connected to Oracle database
#10758
I’m using Keycloak version 15 connect with Oracle 12c, driver ojdbc8. Server have worked for a few month, but now it’s can’t connect to DB. Here is the error log:
12:35:43,405 WARN [org.jboss.as.ejb3.remote] (ClusterTopologyRegistrar - 1) WFLYEJB0509: Clustered Jakarta Enterprise Beans in Node: keycloak1 are bound to INADDR_ANY(0.0.0.0). Either use a non-wildcard server bind address or add client-mapping entries to the relevant socket-binding for the Remoting connector 12:35:46,255 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-3) SQL Error: 17410, SQLState: 08000 12:35:46,256 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-3) No more data to read from socket 12:35:46,278 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-3) Uncaught server error: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet at org.hibernate@5.3.20.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1575) at org.hibernate@5.3.20.Final//org.hibernate.query.Query.getResultList(Query.java:132) at org.keycloak.keycloak-model-jpa@15.0.0//org.keycloak.models.jpa.JpaRealmProvider.getClientByClientId(JpaRealmProvider.java:694) at org.keycloak.keycloak-services@15.0.0//org.keycloak.storage.ClientStorageManager.getClientByClientId(ClientStorageManager.java:144) at org.keycloak.keycloak-model-infinispan@15.0.0//org.keycloak.models.cache.infinispan.RealmCacheSession.getClientByClientId(RealmCacheSession.java:1190) at org.keycloak.keycloak-model-infinispan@15.0.0//org.keycloak.models.cache.infinispan.RealmAdapter.getClientByClientId(RealmAdapter.java:820) at org.keycloak.keycloak-services@15.0.0//org.keycloak.services.resources.account.AccountLoader.getAccountManagementClient(AccountLoader.java:161) at org.keycloak.keycloak-services@15.0.0//org.keycloak.services.resources.account.AccountLoader.getAccountService(AccountLoader.java:72) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.createResource(ResourceLocatorInvoker.java:73) at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:109) ....
I really appreciate any idea about what is happening. Thanks you guys a lot!
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
I’m using Keycloak version 15 connect with Oracle 12c, driver ojdbc8. Server have worked for a few month, but now it’s can’t connect to DB. Here is the error log:
12:35:43,405 WARN [org.jboss.as.ejb3.remote] (ClusterTopologyRegistrar - 1) WFLYEJB0509: Clustered Jakarta Enterprise Beans in Node: keycloak1 are bound to INADDR_ANY(0.0.0.0). Either use a non-wildcard server bind address or add client-mapping entries to the relevant socket-binding for the Remoting connector 12:35:46,255 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-3) SQL Error: 17410, SQLState: 08000 12:35:46,256 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-3) No more data to read from socket 12:35:46,278 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-3) Uncaught server error: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet at org.hibernate@5.3.20.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1575) at org.hibernate@5.3.20.Final//org.hibernate.query.Query.getResultList(Query.java:132) at org.keycloak.keycloak-model-jpa@15.0.0//org.keycloak.models.jpa.JpaRealmProvider.getClientByClientId(JpaRealmProvider.java:694) at org.keycloak.keycloak-services@15.0.0//org.keycloak.storage.ClientStorageManager.getClientByClientId(ClientStorageManager.java:144) at org.keycloak.keycloak-model-infinispan@15.0.0//org.keycloak.models.cache.infinispan.RealmCacheSession.getClientByClientId(RealmCacheSession.java:1190) at org.keycloak.keycloak-model-infinispan@15.0.0//org.keycloak.models.cache.infinispan.RealmAdapter.getClientByClientId(RealmAdapter.java:820) at org.keycloak.keycloak-services@15.0.0//org.keycloak.services.resources.account.AccountLoader.getAccountManagementClient(AccountLoader.java:161) at org.keycloak.keycloak-services@15.0.0//org.keycloak.services.resources.account.AccountLoader.getAccountService(AccountLoader.java:72) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.createResource(ResourceLocatorInvoker.java:73) at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:109) ....I really appreciate any idea about what is happening. Thanks you guys a lot!
All reactions