<div dir="ltr">Marek helped me already - PR against UPS is pending :)</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 15, 2014 at 10:39 AM, Stian Thorgersen <span dir="ltr"><<a href="mailto:stian@redhat.com" target="_blank">stian@redhat.com</a>></span> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">We can sort out something for you guys. When do you need it?<br>
<span class=""><br>
----- Original Message -----<br>
> From: "Matthias Wessendorf" <<a href="mailto:matzew@apache.org">matzew@apache.org</a>><br>
> To: "Marek Posolda" <<a href="mailto:mposolda@redhat.com">mposolda@redhat.com</a>><br>
> Cc: <a href="mailto:keycloak-dev@lists.jboss.org">keycloak-dev@lists.jboss.org</a><br>
> Sent: Friday, 12 December, 2014 12:27:11 PM<br>
> Subject: Re: [keycloak-dev] Database script for manual migration?<br>
><br>
> I *think* I tracked it down to this commit:<br>
><br>
> <a href="https://github.com/keycloak/keycloak/commit/3bfe3d256ed0c292fbb040fa2276c737c3798864" target="_blank">https://github.com/keycloak/keycloak/commit/3bfe3d256ed0c292fbb040fa2276c737c3798864</a><br>
><br>
</span>> the ' org.keycloak.models.jpa. entities.RealmEntity. eventsEnabled' field is<br>
<div class="HOEnZb"><div class="h5">> present in KC 1.0.Final, but not in the 1.0-beta-4.<br>
><br>
><br>
><br>
><br>
> On Fri, Dec 12, 2014 at 11:50 AM, Matthias Wessendorf < <a href="mailto:matzew@apache.org">matzew@apache.org</a> ><br>
> wrote:<br>
><br>
><br>
> Hi Marek,<br>
><br>
> any chance to get a script to get that kinda migration done manually? I think<br>
> this is now blocking us from upgrading to 1.0.4.Final (from 1.0-beta-4,<br>
> which we used in our 1.0.0.Final)<br>
><br>
> thanks,<br>
> Matthias<br>
><br>
> On Fri, Dec 12, 2014 at 10:32 AM, Marek Posolda < <a href="mailto:mposolda@redhat.com">mposolda@redhat.com</a> ><br>
> wrote:<br>
><br>
><br>
> Unfortunately I don't think that we have this. We have automatic migration<br>
> available with liquibase, but this is from 1.0.0.Final (or newer) to 1.1.0.X<br>
> .<br>
><br>
> Marek<br>
><br>
><br>
> On 11.12.2014 16:50, Matthias Wessendorf wrote:<br>
><br>
><br>
><br>
> Hi,<br>
><br>
> I am wondering do you guys have a .sql script for going from '1.0-beta-4' to<br>
> '1.0.4.Final' ?<br>
><br>
> My motivation is updating the an instance of UPS 1.0.0.Final (was using<br>
> Keycloak-1.0-beta-4) to latest stable release candidate (1.0.3-SNAPSHOT,<br>
> which is using Keycloak-1.0.4.Final)<br>
><br>
> Deploying the new auth-server (that we build ourselfs), is giving me this<br>
> (with Postgres and MySQL)<br>
><br>
><br>
><br>
><br>
> 13:32:29,191 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-15)<br>
> MSC000001: Failed to start service<br>
> jboss.undertow.deployment.default-server.default-host./auth:<br>
> org.jboss.msc.service.StartException in service<br>
> jboss.undertow.deployment.default-server.default-host./auth: Failed to start<br>
> service<br>
> at<br>
> org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1904)<br>
> [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<br>
> at<br>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br>
> [rt.jar:1.7.0_65]<br>
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65]<br>
> Caused by: java.lang.RuntimeException: Failed to construct public<br>
> org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)<br>
> at<br>
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:160)<br>
> at<br>
> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2211)<br>
> at<br>
> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:295)<br>
> at<br>
> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:236)<br>
> at<br>
> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:112)<br>
> at<br>
> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)<br>
> at<br>
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)<br>
> at<br>
> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:79)<br>
> at<br>
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)<br>
> at<br>
> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:220)<br>
> at<br>
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:125)<br>
> at<br>
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:508)<br>
> at<br>
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:88)<br>
> at<br>
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)<br>
> at<br>
> org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)<br>
> [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<br>
> at<br>
> org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)<br>
> [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<br>
> ... 3 more<br>
> Caused by: org.keycloak.models.ModelException:<br>
> javax.persistence.PersistenceException:<br>
> org.hibernate.PropertyAccessException: Null value was assigned to a property<br>
> of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> at<br>
> org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:44)<br>
> at<br>
> org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:34)<br>
> at com.sun.proxy.$Proxy128.find(Unknown Source)<br>
> at<br>
> org.keycloak.models.jpa.JpaRealmProvider.getRealm(JpaRealmProvider.java:51)<br>
> at<br>
> org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:173)<br>
> at<br>
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:42)<br>
> at<br>
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:33)<br>
> at<br>
> org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:137)<br>
> at<br>
> org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.setupDefaultRealm(UpsKeycloakApplication.java:40)<br>
> at<br>
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:86)<br>
> at<br>
> org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.<init>(UpsKeycloakApplication.java:35)<br>
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<br>
> [rt.jar:1.7.0_65]<br>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148)<br>
> ... 18 more<br>
> Caused by: javax.persistence.PersistenceException:<br>
> org.hibernate.PropertyAccessException: Null value was assigned to a property<br>
> of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> at<br>
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)<br>
> at<br>
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:<br>
> 1694 )<br>
> at<br>
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1141)<br>
> at<br>
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1068)<br>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
> [rt.jar:1.7.0_65]<br>
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_65]<br>
> at<br>
> org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:32)<br>
> ... 32 more<br>
> Caused by: org.hibernate.PropertyAccessException: Null value was assigned to<br>
> a property of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> at<br>
> org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:126)<br>
> at<br>
> org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:713)<br>
> at<br>
> org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:362)<br>
> at<br>
> org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4718)<br>
> at<br>
> org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:188)<br>
> at<br>
> org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:144)<br>
> at<br>
> org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.performTwoPhaseLoad(AbstractRowReader.java:244)<br>
> at<br>
> org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.finishUp(AbstractRowReader.java:215)<br>
> at<br>
> org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:140)<br>
> at<br>
> org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:138)<br>
> at<br>
> org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102)<br>
> at<br>
> org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186)<br>
> at<br>
> org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126)<br>
> at<br>
> org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)<br>
> at<br>
> org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468)<br>
> at<br>
> org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213)<br>
> at<br>
> org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275)<br>
> at<br>
> org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151)<br>
> at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1070)<br>
> at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:176)<br>
> at<br>
> org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2551)<br>
> at org.hibernate.internal.SessionImpl.get(SessionImpl.java:955)<br>
> at<br>
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1110)<br>
> ... 38 more<br>
> Caused by: java.lang.IllegalArgumentException: Can not set boolean field<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled to null value<br>
> at<br>
> sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:164)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:168)<br>
> [rt.jar:1.7.0_65]<br>
> at<br>
> sun.reflect.UnsafeBooleanFieldAccessorImpl.set(UnsafeBooleanFieldAccessorImpl.java:80)<br>
> [rt.jar:1.7.0_65]<br>
> at java.lang.reflect.Field.set(Field.java:741) [rt.jar:1.7.0_65]<br>
> at<br>
> org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:122)<br>
> ... 60 more<br>
><br>
> 13:32:29,205 ERROR [org.jboss.as.controller.management-operation] (Controller<br>
> Boot Thread) JBAS014613: Operation ("deploy") failed - address:<br>
> ([("deployment" => "auth-server.war")]) - failure description: {"JBAS014671:<br>
> Failed services" =><br>
> {"jboss.undertow.deployment.default-server.default-host./auth" =><br>
> "org.jboss.msc.service.StartException in service<br>
> jboss.undertow.deployment.default-server.default-host./auth: Failed to start<br>
> service<br>
> Caused by: java.lang.RuntimeException: Failed to construct public<br>
> org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)<br>
> Caused by: org.keycloak.models.ModelException:<br>
> javax.persistence.PersistenceException:<br>
> org.hibernate.PropertyAccessException: Null value was assigned to a property<br>
> of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> Caused by: javax.persistence.PersistenceException:<br>
> org.hibernate.PropertyAccessException: Null value was assigned to a property<br>
> of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> Caused by: org.hibernate.PropertyAccessException: Null value was assigned to<br>
> a property of primitive type setter of<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled<br>
> Caused by: java.lang.IllegalArgumentException: Can not set boolean field<br>
> org.keycloak.models.jpa.entities.RealmEntity.eventsEnabled to null value"}}<br>
><br>
><br>
> Thanks,<br>
> Matthias<br>
><br>
> --<br>
> Matthias Wessendorf<br>
><br>
> blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>
> sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>
> twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a><br>
><br>
><br>
> _______________________________________________<br>
> keycloak-dev mailing list <a href="mailto:keycloak-dev@lists.jboss.org">keycloak-dev@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/keycloak-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-dev</a><br>
><br>
><br>
><br>
> --<br>
> Matthias Wessendorf<br>
><br>
> blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>
> sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>
> twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a><br>
><br>
><br>
> --<br>
> Matthias Wessendorf<br>
><br>
> blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>
> sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>
> twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a><br>
><br>
> _______________________________________________<br>
> keycloak-dev mailing list<br>
> <a href="mailto:keycloak-dev@lists.jboss.org">keycloak-dev@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/keycloak-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-dev</a><br>
</div></div></blockquote></div><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div>