On 01 Mar 2016, at 10:14, Edgar Vonk - Info.nl <Edgar(a)info.nl&gt; wrote: Hi, Since upgrading to Keycloak 1.9.0 Final (I think) we get a lot of database related errors. E.g.: [0m09:03:25,648 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) SQL Error: 942, SQLState: 42000 09:03:25,649 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) ORA-00942: table or view does not exist 09:03:25,656 INFO [org.hibernate.event.internal.DefaultLoadEventListener] (Timer-2) HHH000327: Error performing load command : org.hibernate.exception.SQLGrammarException: could not extract ResultSet 09: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 _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user

My favorite kind of email :) On 3/1/2016 7:26 AM, Edgar Vonk - Info.nl wrote: > Hi, > > Never mind about this. It was our fault. Nothing to do with Keycloak. :-) > > > >> On 01 Mar 2016, at 10:14, Edgar Vonk - Info.nl <Edgar(a)info.nl&gt; wrote: >> >> 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 >> _______________________________________________ >> keycloak-user mailing list >> keycloak-user(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/keycloak-user > > _______________________________________________ > keycloak-user mailing list > keycloak-user(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/keycloak-user -- Bill Burke JBoss, a division of Red Hat http://bill.burkecentral.com _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user