[keycloak-user] Database errors since Keycloak 1.9.0.Final (?)
Edgar Vonk - Info.nl
Edgar at info.nl
Tue Mar 1 04:14:52 EST 2016
Hi,
Since upgrading to Keycloak 1.9.0 Final (I think) we get a lot of database related errors. E.g.:
[0m[33m09:03:25,648 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) SQL Error: 942, SQLState: 42000
[0m[31m09:03:25,649 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) ORA-00942: table or view does not exist
[0m[0m09:03:25,656 INFO [org.hibernate.event.internal.DefaultLoadEventListener] (Timer-2) HHH000327: Error performing load command : org.hibernate.exception.SQLGrammarException: could not extract ResultSet
[0m[31m09:03:25,666 ERROR [org.keycloak.services] (Timer-2) KC-SERVICES0062: Error occurred during sync of changed users: org.keycloak.models.ModelException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)
at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:51)
at com.sun.proxy.$Proxy64.find(Unknown Source)
at org.keycloak.models.jpa.JpaRealmProvider.getRealm(JpaRealmProvider.java:86)
at org.keycloak.models.cache.infinispan.RealmAdapter.getDelegateForUpdate(RealmAdapter.java:56)
at org.keycloak.models.cache.infinispan.RealmAdapter.updateUserFederationProvider(RealmAdapter.java:734)
at org.keycloak.services.managers.UsersSyncManager$6.run(UsersSyncManager.java:248)
at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:280)
at org.keycloak.services.managers.UsersSyncManager.updateLastSyncInterval(UsersSyncManager.java:237)
at org.keycloak.services.managers.UsersSyncManager.access$100(UsersSyncManager.java:44)
at org.keycloak.services.managers.UsersSyncManager$3$1.call(UsersSyncManager.java:138)
at org.keycloak.services.managers.UsersSyncManager$3$1.call(UsersSyncManager.java:130)
at org.keycloak.cluster.infinispan.InfinispanClusterProvider.executeIfNotExecuted(InfinispanClusterProvider.java:90)
at org.keycloak.services.managers.UsersSyncManager$3.run(UsersSyncManager.java:130)
at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:280)
at org.keycloak.services.managers.UsersSyncManager.syncChangedUsers(UsersSyncManager.java:120)
at org.keycloak.services.managers.UsersSyncManager$5.run(UsersSyncManager.java:200)
at org.keycloak.timer.basic.BasicTimerProvider$1.run(BasicTimerProvider.java:46)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Any ideas on what could cause this?
cheers
More information about the keycloak-user
mailing list