<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Consolas;
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas">During LDAP integration with Keycloak (v1.3.1), we get to see a “<i>Unique index or primary key violation”
</i>exception while trying to login with an LDAP using on Keycloak’s account service site. I setup latest Keycloak source (from Github) to debug this issue. During build, I saw the same error when LDAP integration tests were running. Here are the logs –
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:24,624 INFO [org.keycloak.testsuite.KeycloakServer] Imported realm test<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:24,709 INFO [org.keycloak.federation.ldap.LDAPIdentityStoreRegistry] Creating new LDAP based partition manager for the Federation provider: test-ldap, LDAP Configuration: {bindDn=uid=admin,ou=system,
userObjectClasses=null, baseDn=dc=keycloak,dc=org, usersDn=ou=People,dc=keycloak,dc=org, vendor=other, kerberosRealm=KEYCLOAK.ORG, syncRegistrations=false, userAccountControlsAfterPasswordUpdate=false, debug=true, connectionPooling=true, serverPrincipal=HTTP/localhost@KEYCLOAK.ORG,
usernameLDAPAttribute=null, allowKerberosAuthentication=false, useKerberosForPasswordAuthentication=false, rdnLDAPAttribute=null, keyTab=/home/USER/apps/keycloak/testsuite/integration/target/test-classes/kerberos/http.keytab, batchSizeForSync=3, connectionUrl=ldap://localhost:10389,
allowPasswordAuthentication=true, editMode=WRITABLE, updateProfileFirstLogin=true, pagination=true}<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:25,790 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users from LDAP to local store: realm: test, federation provider: test-ldap<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:25,845 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users finished: 5 imported users, 0 updated users, 0 removed users<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,862 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync changed users from LDAP to local store: realm: test, federation provider: test-ldap, last sync time:
Wed Jul 08 21:40:25 IST 2015<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,900 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync changed users finished: 1 imported users, 1 updated users, 0 removed users<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,920 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users from LDAP to local store: realm: test, federation provider: test-ldap<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,962 WARN [org.keycloak.federation.ldap.LDAPFederationProviderFactory] User 'user7' is not updated during sync as he already exists in Keycloak database but is not linked to
federation provider 'test-ldap'<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,969 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users finished: 0 imported users, 6 updated users, 0 removed users, 1 users failed sync! See
server log for more details<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:26,981 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users from LDAP to local store: realm: test, federation provider: test-ldap<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:27,054 ERROR [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Failed during import user from LDAP<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">org.keycloak.models.ModelDuplicateException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Unique index or primary key violation: "UK_DYKN684SL8UP1CRFEI6ECKHD7_INDEX_D
ON PUBLIC.USER_ENTITY(REALM_ID, EMAIL_CONSTRAINT) VALUES ('test', 'user7@email.org', 21)"; SQL statement:<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">update USER_ENTITY set CREATED_TIMESTAMP=?, EMAIL=?, EMAIL_CONSTRAINT=?, EMAIL_VERIFIED=?, ENABLED=?, federation_link=?, FIRST_NAME=?, LAST_NAME=?, REALM_ID=?, TOTP=?, USERNAME=? where
ID=? [23505-187]<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:40)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.connections.jpa.JpaKeycloakTransaction.commit(JpaKeycloakTransaction.java:30)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:58)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:247)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.federation.ldap.LDAPFederationProviderFactory.importLdapUsers(LDAPFederationProviderFactory.java:286)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.federation.ldap.LDAPFederationProviderFactory.syncImpl(LDAPFederationProviderFactory.java:241)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.federation.ldap.LDAPFederationProviderFactory.syncAllUsers(LDAPFederationProviderFactory.java:200)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.services.managers.UsersSyncManager.syncAllUsers(UsersSyncManager.java:50)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.testsuite.federation.SyncProvidersTest.test02duplicateUsernameSync(SyncProvidersTest.java:200)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at java.lang.reflect.Method.invoke(Method.java:606)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:48)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:48)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.rules.RunRules.evaluate(RunRules.java:20)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.junit.runners.ParentRunner.run(ParentRunner.java:363)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Unique index or primary key violation: "UK_DYKN684SL8UP1CRFEI6ECKHD7_INDEX_D
ON PUBLIC.USER_ENTITY(REALM_ID, EMAIL_CONSTRAINT) VALUES ('test', 'user7@email.org', 21)"; SQL statement:<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">update USER_ENTITY set CREATED_TIMESTAMP=?, EMAIL=?, EMAIL_CONSTRAINT=?, EMAIL_VERIFIED=?, ENABLED=?, federation_link=?, FIRST_NAME=?, LAST_NAME=?, REALM_ID=?, TOTP=?, USERNAME=? where
ID=? [23505-187]<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:78)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.keycloak.connections.jpa.JpaKeycloakTransaction.commit(JpaKeycloakTransaction.java:28)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> ... 33 more<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">Caused by: org.hibernate.exception.ConstraintViolationException: Unique index or primary key violation: "UK_DYKN684SL8UP1CRFEI6ECKHD7_INDEX_D ON PUBLIC.USER_ENTITY(REALM_ID, EMAIL_CONSTRAINT)
VALUES ('test', 'user7@email.org', 21)"; SQL statement:<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">update USER_ENTITY set CREATED_TIMESTAMP=?, EMAIL=?, EMAIL_CONSTRAINT=?, EMAIL_VERIFIED=?, ENABLED=?, federation_link=?, FIRST_NAME=?, LAST_NAME=?, REALM_ID=?, TOTP=?, USERNAME=? where
ID=? [23505-187]<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at com.sun.proxy.$Proxy54.executeUpdate(Unknown Source)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3006)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2908)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3237)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:113)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:264)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:187)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:315)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:73)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> ... 34 more<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_DYKN684SL8UP1CRFEI6ECKHD7_INDEX_D ON PUBLIC.USER_ENTITY(REALM_ID, EMAIL_CONSTRAINT) VALUES ('test',
'user7@email.org', 21)"; SQL statement:<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">update USER_ENTITY set CREATED_TIMESTAMP=?, EMAIL=?, EMAIL_CONSTRAINT=?, EMAIL_VERIFIED=?, ENABLED=?, federation_link=?, FIRST_NAME=?, LAST_NAME=?, REALM_ID=?, TOTP=?, USERNAME=? where
ID=? [23505-187]<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.message.DbException.get(DbException.java:179)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.message.DbException.get(DbException.java:155)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:102)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:233)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:191)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.mvstore.db.MVTable.addRow(MVTable.java:638)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.table.Table.updateRows(Table.java:478)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.command.dml.Update.update(Update.java:145)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.command.CommandContainer.update(CommandContainer.java:78)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.command.Command.executeUpdate(Command.java:254)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at sun.reflect.GeneratedMethodAccessor261.invoke(Unknown Source)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at java.lang.reflect.Method.invoke(Method.java:606)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas"> ... 51 more<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:27,103 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users finished: 1 imported users, 6 updated users, 0 removed users, 1 users failed sync! See
server log for more details<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:27,110 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users from LDAP to local store: realm: test, federation provider: test-ldap<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:27,167 INFO [org.keycloak.federation.ldap.LDAPFederationProviderFactory] Sync all users finished: 1 imported users, 6 updated users, 0 removed users<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:Consolas">21:40:28,175 INFO [org.keycloak.testsuite.DummyUserFederationProviderFactory] syncChangedUsers invoked<o:p></o:p></span></i></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas">Is this a known issue?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Consolas">-- Rajat<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>