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

Stian Thorgersen stian at redhat.com
Tue Sep 2 10:41:14 EDT 2014 

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 at zwift.com>
> To: keycloak-user at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user

More information about the keycloak-user mailing list