<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
this is actually expected. I've added new test for fix syncing
bugs with duplicated username or email. Test asserts that user is
not synced from LDAP if there is already other user with same
username or email in Keycloak database. And the test also asserts
that just the syncing of "duplicated" user fails but other users
are successfully synced (not whole sync transaction is broken as
it was in 1.3.1 ). <br>
<br>
As I can see in your log, it works as expected and the test is
passing, is it correct?<br>
<br>
Yesterday I've added some more fixes (now there is not
ConstraintException thrown from DB but there is check for
duplications triggered earlier from Keycloak). So I suggest to
update to latest master and try it now. Please let me know if
still seeing issues.<br>
<br>
I will do a bit more testing and will add the LDAP example today,
so there might be still some changes, but I hope that not much.<br>
<br>
Thanks,<br>
Marek<br>
<br>
<br>
On 8.7.2015 18:26, Nair, Rajat wrote:<br>
</div>
<blockquote
cite="mid:E8E85ED231DB984CA315C4439410229A1F031469@G9W0758.americas.hpqcorp.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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]-->
<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,
<a class="moz-txt-link-abbreviated" href="mailto:serverPrincipal=HTTP/localhost@KEYCLOAK.ORG">serverPrincipal=HTTP/localhost@KEYCLOAK.ORG</a>,
usernameLDAPAttribute=null,
allowKerberosAuthentication=false,
useKerberosForPasswordAuthentication=false,
rdnLDAPAttribute=null,
keyTab=/home/USER/apps/keycloak/testsuite/integration/target/test-classes/kerberos/http.keytab,
batchSizeForSync=3, connectionUrl=<a class="moz-txt-link-freetext" href="ldap://localhost:10389">ldap://localhost:10389</a>,
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', '<a class="moz-txt-link-abbreviated" href="mailto:user7@email.org">user7@email.org</a>', 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', '<a class="moz-txt-link-abbreviated" href="mailto:user7@email.org">user7@email.org</a>', 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', '<a class="moz-txt-link-abbreviated" href="mailto:user7@email.org">user7@email.org</a>', 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', '<a class="moz-txt-link-abbreviated" href="mailto:user7@email.org">user7@email.org</a>', 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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
</body>
</html>