[keycloak-user] Updating Oracle database schema to 1.3.1 fails

Marek Posolda mposolda at redhat.com
Tue Aug 11 10:39:46 EDT 2015 

This issue was reported few days back in different mail 
http://lists.jboss.org/pipermail/keycloak-user/2015-August/002762.html . 
As you can see there is already JIRA 
https://issues.jboss.org/browse/KEYCLOAK-1725, which was fixed in 
keycloak master and will be available in 1.5 release, so upgrading from 
1.1.0 to 1.5 should be hopefully fine.

Marek

On 11.8.2015 16:24, Hipfinger Martin (BCC.ÖBB.TicketShop.MA) wrote:
>
> i have a working setup with keycloak 1.1.0 using Oracle.
>
> When I try to upgrade schema using Keycloak 1.3.1.Final it fails.
>
> Setting in keycloak-server.json
> "connectionsJpa": {
> "default":
>
> { "dataSource": "java:jboss/datasources/myDS", "databaseSchema": 
> "update" }
>
> }
>
> upgrade to 1.2.0:
>
> 15:35:35,309 ERROR 
> [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] 
> (MSC service thread 1-2) Change Set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com 
> failed. Error: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version: 
> liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185)
> at 
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
> at liquibase.Liquibase.update(Liquibase.java:200)
> at liquibase.Liquibase.update(Liquibase.java:181)
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84) 
> [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143) 
> [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35) 
> [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25) 
> [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34) 
> [keycloak-model-jpa-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16) 
> [keycloak-model-jpa-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70) 
> [keycloak-invalidation-cache-model-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163) 
> [keycloak-invalidation-cache-model-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:155) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:86) 
> [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
> Method) [rt.jar:1.8.0_40]
> at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 
> [rt.jar:1.8.0_40]
> at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
> [rt.jar:1.8.0_40]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) 
> [rt.jar:1.8.0_40]
> at 
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2211) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:295) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:236) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:112) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36) 
> [resteasy-jaxrs-3.0.10.Final.jar:]
> at 
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117) 
> [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
> at 
> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:79)
> at 
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103) 
> [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
> at 
> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:220) 
> [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
> at 
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:125) 
> [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
> at 
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:508) 
> [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
> 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)
> at 
> org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
> [rt.jar:1.8.0_40]
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
> [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:43) 
> [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79) 
> [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final]
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178)
> ... 43 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.addDefaultProtocolMappers(JpaUpdate1_2_0_Beta1.java:296) 
> [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final]
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:41) 
> [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final]
> ... 45 more
>
> 15:35:35,344 ERROR [org.jboss.msc.service.fail] (MSC service thread 
> 1-2) 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:1142) 
> [rt.jar:1.8.0_40]
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
> [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: java.lang.RuntimeException: Failed to construct public 
> org.keycloak.services.resources.KeycloakApplication(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: java.lang.RuntimeException: Failed to update database
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31)
> at 
> org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:155)
> at 
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:86)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
> Method) [rt.jar:1.8.0_40]
> at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 
> [rt.jar:1.8.0_40]
> at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
> [rt.jar:1.8.0_40]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) 
> [rt.jar:1.8.0_40]
> at 
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148)
> ... 18 more
> Caused by: liquibase.exception.MigrationFailedException: Migration 
> failed for change set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com:
> Reason: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586)
> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
> at liquibase.Liquibase.update(Liquibase.java:200)
> at liquibase.Liquibase.update(Liquibase.java:181)
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84)
> ... 36 more
> Caused by: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185)
> at 
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
> ... 41 more
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:43)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79)
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178)
> ... 43 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.addDefaultProtocolMappers(JpaUpdate1_2_0_Beta1.java:296)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:41)
> ... 45 more
>
> 15:35:35,366 ERROR [org.jboss.as.controller.management-operation] 
> (Controller Boot Thread) JBAS014613: Operation ("add") failed - 
> address: ([("deployment" => "main-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.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> Caused by: java.lang.RuntimeException: Failed to update database
> Caused by: liquibase.exception.MigrationFailedException: Migration 
> failed for change set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com:
> Reason: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> Caused by: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long"}}
>
> upgrade to 1.3.1:
>
> 14:40:00,682 INFO 
> [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] 
> (ServerService Thread Pool – 61) Updating database
> 14:40:01,905 ERROR 
> [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] 
> (ServerService Thread Pool – 61) Change Set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com 
> failed. Error: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version: 
> liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185)
> at 
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
> at liquibase.Liquibase.update(Liquibase.java:200)
> at liquibase.Liquibase.update(Liquibase.java:181)
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31)
> at 
> org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:157)
> at 
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:87)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
> at 
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148)
> 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:78)
> at 
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
> at 
> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:230)
> at 
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:131)
> at 
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:511)
> at 
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
> at 
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> at org.jboss.threads.JBossThread.run(JBossThread.java:320)
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:43)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79)
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178)
> ... 44 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.addDefaultProtocolMappers(JpaUpdate1_2_0_Beta1.java:296)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:41)
> ... 46 more
>
> 14:40:01,930 ERROR [org.jboss.msc.service.fail] (ServerService Thread 
> Pool – 61) 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: 
> java.lang.RuntimeException: Failed to construct public 
> org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> at 
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> at org.jboss.threads.JBossThread.run(JBossThread.java:320)
> Caused by: java.lang.RuntimeException: Failed to construct public 
> org.keycloak.services.resources.KeycloakApplication(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:78)
> at 
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
> at 
> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:230)
> at 
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:131)
> at 
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:511)
> at 
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
> at 
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
> ... 6 more
> Caused by: java.lang.RuntimeException: Failed to update database
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35)
> at 
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)
> at 
> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)
> at 
> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70)
> at 
> org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40)
> at 
> org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31)
> at 
> org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:157)
> at 
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:87)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
> at 
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148)
> ... 19 more
> Caused by: liquibase.exception.MigrationFailedException: Migration 
> failed for change set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com:
> Reason: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586)
> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
> at liquibase.Liquibase.update(Liquibase.java:200)
> at liquibase.Liquibase.update(Liquibase.java:181)
> at 
> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84)
> ... 37 more
> Caused by: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185)
> at 
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
> ... 42 more
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:43)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79)
> at 
> liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178)
> ... 44 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.addDefaultProtocolMappers(JpaUpdate1_2_0_Beta1.java:296)
> at 
> org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_Beta1.generateStatementsImpl(JpaUpdate1_2_0_Beta1.java:41)
> ... 46 more
>
> 14:40:01,945 ERROR [org.jboss.as.controller.management-operation] 
> (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - 
> address: ([("deployment" => "keycloak-server.war")]) - failure 
> description: {"WFLYCTL0080: 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: 
> java.lang.RuntimeException: Failed to construct public 
> org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> Caused by: java.lang.RuntimeException: Failed to construct public 
> org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> Caused by: java.lang.RuntimeException: Failed to update database
> Caused by: liquibase.exception.MigrationFailedException: Migration 
> failed for change set 
> META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva at redhat.com:
> Reason: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> Caused by: liquibase.exception.UnexpectedLiquibaseException: 
> liquibase.exception.CustomChangeException: Update 1.2.0.Beta1: 
> Exception when updating data from previous version
> Caused by: liquibase.exception.CustomChangeException: Update 
> 1.2.0.Beta1: Exception when updating data from previous version
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot 
> be cast to java.lang.Long"}}
>
> Thx for your help!
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20150811/99eaabe7/attachment-0001.html

More information about the keycloak-user mailing list