[keycloak-user] Database errors since Keycloak 1.9.0.Final (?)

[Stian Thorgersen]

+1

On 1 March 2016 at 18:36, Bill Burke <bburke at redhat.com> wrote:

> 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 at info.nl> 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 at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/keycloak-user
> >
> > _______________________________________________
> > keycloak-user mailing list
> > keycloak-user at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160301/7abdcde1/attachment.html