[keycloak-user] Issue during Import of Realm via startup in domain mode

Stian Thorgersen sthorger at redhat.com
Mon Dec 21 09:28:52 EST 2015 

You should only run import on one server. Otherwise both servers will
independently try to recreate everything in the import file.

On 21 December 2015 at 15:09, Andrej Prievalsky <ado.boj.83 at gmail.com>
wrote:

> My environment: keycloak-demo-1.7.0.Final running in domain mode with main
> server group: server-one and server-two
> OracleLinux 7 (Java version 1.8.0_45) machine connect with Oracle
> Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With
> the Partitioning, OLAP, Advanced Analytics and Real Application Testing
> options
> and Oracle JDBC driver 11.2.0.3.0
>
>
> After import Realm during keycloak startup in console:
> ./domain.sh -Dkeycloak.migration.action=import
> -Dkeycloak.migration.provider=singleFile
> -Dkeycloak.migration.file=/opt/keycloak-1.7.0.Final/export_demo.json
>
> I got only on server-two this ERROR, server-one is OK:
> *[Server:server-two] 14:25:30,037 ERROR
> [org.keycloak.exportimport.ExportImportManager] (ServerService Thread Pool
> -- 64) Error during export/import: org.keycloak.models.ModelException:
> javax.persistence.OptimisticLockException: Batch update returned unexpected
> row count from update [0]; actual row count: 0; expected: 1*
> *[Server:server-two]     at
> org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:44)*
> *[Server:server-two]     at
> org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:34)*
> *[Server:server-two]     at com.sun.proxy.$Proxy117.flush(Unknown Source)*
> *[Server:server-two]     at
> org.keycloak.models.jpa.JpaRealmProvider.removeRealm(JpaRealmProvider.java:114)*
> *[Server:server-two]     at
> org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.removeRealm(DefaultCacheRealmProvider.java:221)*
> *[Server:server-two]     at
> org.keycloak.exportimport.util.ImportUtils.importRealm(ImportUtils.java:76)*
> *[Server:server-two]     at
> org.keycloak.exportimport.util.ImportUtils.importRealms(ImportUtils.java:45)*
> *[Server:server-two]     at
> org.keycloak.exportimport.singlefile.SingleFileImportProvider$1.runExportImportTask(SingleFileImportProvider.java:45)*
> *[Server:server-two]     at
> org.keycloak.exportimport.util.ExportImportSessionTask.run(ExportImportSessionTask.java:18)*
> *[Server:server-two]     at
> org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:264)*
> *[Server:server-two]     at
> org.keycloak.exportimport.singlefile.SingleFileImportProvider.importModel(SingleFileImportProvider.java:41)*
> *[Server:server-two]     at
> org.keycloak.exportimport.ExportImportManager.checkExportImport(ExportImportManager.java:67)*
> *[Server:server-two]     at
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:86)*
> *[Server:server-two]     at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)*
> *[Server:server-two]     at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)*
> *[Server:server-two]     at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)*
> *[Server:server-two]     at
> java.lang.reflect.Constructor.newInstance(Constructor.java:422)*
> *[Server:server-two]     at
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:148)*
> *[Server:server-two]     at
> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2211)*
> *[Server:server-two]     at
> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:295)*
> *[Server:server-two]     at
> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:236)*
> *[Server:server-two]     at
> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:112)*
> *[Server:server-two]     at
> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)*
> *[Server:server-two]     at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)*
> *[Server:server-two]     at
> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)*
> *[Server:server-two]     at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)*
> *[Server:server-two]     at
> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:230)*
> *[Server:server-two]     at
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:131)*
> *[Server:server-two]     at
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:511)*
> *[Server:server-two]     at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)*
> *[Server:server-two]     at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)*
> *[Server:server-two]     at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)*
> *[Server:server-two]     at
> java.util.concurrent.FutureTask.run(FutureTask.java:266)*
> *[Server:server-two]     at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)*
> *[Server:server-two]     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)*
> *[Server:server-two]     at java.lang.Thread.run(Thread.java:745)*
> *[Server:server-two]     at
> org.jboss.threads.JBossThread.run(JBossThread.java:320)*
> *[Server:server-two] Caused by: javax.persistence.OptimisticLockException:
> Batch update returned unexpected row count from update [0]; actual row
> count: 0; expected: 1*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.wrapStaleStateException(AbstractEntityManagerImpl.java:1800)*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1705)*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338)*
> *[Server:server-two]     at
> sun.reflect.GeneratedMethodAccessor278.invoke(Unknown Source)*
> *[Server:server-two]     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
> *[Server:server-two]     at
> java.lang.reflect.Method.invoke(Method.java:497)*
> *[Server:server-two]     at
> org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:32)*
> *[Server:server-two]     ... 35 more*
> *[Server:server-two] Caused by: org.hibernate.StaleStateException: Batch
> update returned unexpected row count from update [0]; actual row count: 0;
> expected: 1*
> *[Server:server-two]     at
> org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:81)*
> *[Server:server-two]     at
> org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:73)*
> *[Server:server-two]     at
> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:63)*
> *[Server:server-two]     at
> org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3400)*
> *[Server:server-two]     at
> org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3630)*
> *[Server:server-two]     at
> org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:114)*
> *[Server:server-two]     at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)*
> *[Server:server-two]     at
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)*
> *[Server:server-two]     at
> org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)*
> *[Server:server-two]     at
> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)*
> *[Server:server-two]     at
> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)*
> *[Server:server-two]     at
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)*
> *[Server:server-two]     ... 39 more*
>
>
>
>
>
>
>
> _______________________________________________
> 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/20151221/b4052a2d/attachment-0001.html

More information about the keycloak-user mailing list