Re: [keycloak-user] Problem starting up 1.0-rc-2 using 1.0-rc-1 compatible SQL schema

From: "Alarik Myrin" <alarik(a)zwift.com&gt; To: "Stian Thorgersen" <stian(a)redhat.com&gt; Cc: keycloak-user(a)lists.jboss.org Sent: Tuesday, 2 September, 2014 4:42:23 PM Subject: Re: [keycloak-user] Problem starting up 1.0-rc-2 using 1.0-rc-1 compatible SQL schema OK. That's what I figured. Any idea when rc-2 will be in maven? On Tue, Sep 2, 2014 at 10:41 AM, Stian Thorgersen <stian(a)redhat.com&gt; wrote: > I'm afraid the database schema changed again from rc-1 to rc-2 (I forgot > to mention it in the migration guide). > > For now you'll have to clear the db, after 1.0.final is released we'll > support upgrading the database between versions. > > ----- Original Message ----- > > From: "Alarik Myrin" <alarik(a)zwift.com&gt; > > To: keycloak-user(a)lists.jboss.org > > Sent: Tuesday, 2 September, 2014 4:14:04 PM > > Subject: [keycloak-user] Problem starting up 1.0-rc-2 using 1.0-rc-1 > compatible SQL schema > > > > I am using Wildfly 8.0.0-Final and Postgres 9.3.5. When I try to start up > > 1.0-rc-2 and point to a schema that worked with 1.0-rc-1, I get the > > following: > > > > > > > > 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.$Proxy53.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.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:86) > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > [rt.jar:1.8.0_05] > > > > at > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > > [rt.jar:1.8.0_05] > > > > at > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > [rt.jar:1.8.0_05] > > > > at java.lang.reflect.Constructor.newInstance(Constructor.java:408) > > [rt.jar:1.8.0_05] > > > > at > > > org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148) > > > > ... 15 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.8.0_05] > > > > at > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > > [rt.jar:1.8.0_05] > > > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > [rt.jar:1.8.0_05] > > > > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0_05] > > > > at > > > org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:32) > > > > ... 27 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:4712) > > > > 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:4120) > > > > at > > > org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:502) > > > > at > > > org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:467) > > > > at > > > org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:212) > > > > at > > > org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:274) > > > > at > > > org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:150) > > > > at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1066) > > > > at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:176) > > > > at > > > org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2540) > > > > at org.hibernate.internal.SessionImpl.get(SessionImpl.java:951) > > > > at > > > org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1110) > > > > ... 33 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:167) > > [rt.jar:1.8.0_05] > > > > at > > > sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171) > > [rt.jar:1.8.0_05] > > > > at > > > sun.reflect.UnsafeBooleanFieldAccessorImpl.set(UnsafeBooleanFieldAccessorImpl.java:80) > > [rt.jar:1.8.0_05] > > > > at java.lang.reflect.Field.set(Field.java:758) [rt.jar:1.8.0_05] > > > > at > > > org.hibernate.property.DirectPropertyAccessor$DirectSetter.set(DirectPropertyAccessor.java:122) > > > > ... 55 more > > > > > > > > > > If I start from an empty schema, I don't see this problem. This isn't a > > killer for me for now, but just thought I would bring it up. > > > > > > > > > > Alarik > > > > > > > > _______________________________________________ > > keycloak-user mailing list > > keycloak-user(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/keycloak-user >