Re: [keycloak-dev] Database script for manual migration?

This is related to renaming of 'audit' to 'events', which was done after 1.0-beta-4 and affect db schema. I've checked that there are no more major changes to db schema and these 3 commands helped to migrate my MySQL 5 from beta-4 to 1.0.4.Final: rename table REALM_AUDIT_LISTENERS to REALM_EVENTS_LISTENERS; alter table REALM change AUDIT_ENABLED EVENTS_ENABLED bit(1); alter table REALM change AUDIT_EXPIRATION EVENTS_EXPIRATION bigint(20); However not sure if same commands work for other databases. Marek On 12.12.2014 12:27, Matthias Wessendorf wrote: > I *think* I tracked it down to this commit: > > https://github.com/keycloak/keycloak/commit/3bfe3d256ed0c292fbb040fa2276c... > > 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(a)apache.org <mailto:matzew@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(a)redhat.com <mailto:mposolda@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 >> <tel: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(a)lists.jboss.org <mailto:keycloak-dev@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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-dev