<div dir="ltr">+1</div><div class="gmail_extra"><br><div class="gmail_quote">On 1 March 2016 at 18:36, Bill Burke <span dir="ltr"><<a href="mailto:bburke@redhat.com" target="_blank">bburke@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">My favorite kind of email :)<br>
<div class="HOEnZb"><div class="h5"><br>
On 3/1/2016 7:26 AM, Edgar Vonk - Info.nl wrote:<br>
> Hi,<br>
><br>
> Never mind about this. It was our fault. Nothing to do with Keycloak. :-)<br>
><br>
><br>
><br>
>> On 01 Mar 2016, at 10:14, Edgar Vonk - Info.nl <<a href="mailto:Edgar@info.nl">Edgar@info.nl</a>> wrote:<br>
>><br>
>> Hi,<br>
>><br>
>> Since upgrading to Keycloak 1.9.0 Final (I think) we get a lot of database related errors. E.g.:<br>
>><br>
>> [0m [33m09:03:25,648 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) SQL Error: 942, SQLState: 42000<br>
>> [0m [31m09:03:25,649 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-2) ORA-00942: table or view does not exist<br>
>><br>
>> [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<br>
>> [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<br>
>> at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)<br>
>> at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:51)<br>
>> at com.sun.proxy.$Proxy64.find(Unknown Source)<br>
>> at org.keycloak.models.jpa.JpaRealmProvider.getRealm(JpaRealmProvider.java:86)<br>
>> at org.keycloak.models.cache.infinispan.RealmAdapter.getDelegateForUpdate(RealmAdapter.java:56)<br>
>> at org.keycloak.models.cache.infinispan.RealmAdapter.updateUserFederationProvider(RealmAdapter.java:734)<br>
>> at org.keycloak.services.managers.UsersSyncManager$6.run(UsersSyncManager.java:248)<br>
>> at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:280)<br>
>> at org.keycloak.services.managers.UsersSyncManager.updateLastSyncInterval(UsersSyncManager.java:237)<br>
>> at org.keycloak.services.managers.UsersSyncManager.access$100(UsersSyncManager.java:44)<br>
>> at org.keycloak.services.managers.UsersSyncManager$3$1.call(UsersSyncManager.java:138)<br>
>> at org.keycloak.services.managers.UsersSyncManager$3$1.call(UsersSyncManager.java:130)<br>
>> at org.keycloak.cluster.infinispan.InfinispanClusterProvider.executeIfNotExecuted(InfinispanClusterProvider.java:90)<br>
>> at org.keycloak.services.managers.UsersSyncManager$3.run(UsersSyncManager.java:130)<br>
>> at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:280)<br>
>> at org.keycloak.services.managers.UsersSyncManager.syncChangedUsers(UsersSyncManager.java:120)<br>
>> at org.keycloak.services.managers.UsersSyncManager$5.run(UsersSyncManager.java:200)<br>
>> at org.keycloak.timer.basic.BasicTimerProvider$1.run(BasicTimerProvider.java:46)<br>
>> at java.util.TimerThread.mainLoop(Timer.java:555)<br>
>> at java.util.TimerThread.run(Timer.java:505)<br>
>><br>
>> Any ideas on what could cause this?<br>
>><br>
>> cheers<br>
>> _______________________________________________<br>
>> keycloak-user mailing list<br>
>> <a href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a><br>
>> <a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br>
><br>
> _______________________________________________<br>
> keycloak-user mailing list<br>
> <a href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Bill Burke<br>
JBoss, a division of Red Hat<br>
<a href="http://bill.burkecentral.com" rel="noreferrer" target="_blank">http://bill.burkecentral.com</a><br>
</font></span><div class="HOEnZb"><div class="h5"><br>
_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br>
</div></div></blockquote></div><br></div>