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

[Andrej Prievalsky]

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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20151221/d143caf8/attachment.html