[keycloak-dev] Database script for manual migration?

[Matthias Wessendorf]

Marek helped me already - PR against UPS is pending :)

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


-- 
Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-dev/attachments/20141215/966cb365/attachment-0001.html