I'm coming up to speed with Syncope, so this could be a newbie mistake, and
I'm not sure how to fully trace/debug what's happening. Please let me know
what extra relevant information I can provide.
v208
Maven
MariaDB 10.2.11
ApacheDS 2.0.0-M24
I have the LDAP connector wired up, and a singular instance for managing
users and groups; this is the only external resource I have.
I can create groups and users with no problem.
If I connect them to the LDAP resource, they populate in DS. I can edit
values, and they are propagated to DS.
However, the core.log fills up with repeated errors about a duplicate
entry. If I don't connect the user/group to LDAP, there are no errors in
the log. If I disconnect the user/group from LDAP, the log entries stop.
This happens even on the first entry, so there's no chance there's actually
a pre-existing entry.
Thank you in advance for your assistance.
Log Snippets:
03:20:02.358 ERROR
org.apache.syncope.core.provisioning.api.pushpull.SyncopeResultHandler -
Could not create GROUP 72221ad0-d819-42f3-a0bb-1d21162866b1
org.apache.openjpa.persistence.PersistenceException: The transaction has
been rolled back. See the nested exceptions for details on the errors that
occurred.
at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
~[openjpa-kernel-2.4.2.jar:2.4.2]
.....
Caused by: org.apache.openjpa.persistence.EntityExistsException:
(conn=1464) Duplicate entry 'abvc' for key 'U_SYNCGRP_NAME' {prepstmnt
1442070129 INSERT INTO SyncopeGroup (id, creationDate, creator,
lastChangeDate, lastModifier, status, workflowId, name, REALM_ID,
GROUPOWNER_ID, USEROWNER_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?)} [code=1062, state=23000]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4988)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
....
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn=1464)
Duplicate entry 'abvc' for key 'U_SYNCGRP_NAME' {prepstmnt 1442070129
INSERT INTO SyncopeGroup (id, creationDate, creator, lastChangeDate,
lastModifier, status, workflowId, name, REALM_ID, GROUPOWNER_ID,
USEROWNER_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
[code=1062, state=23000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:194)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1133)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
~[openjpa-lib-2.4.2.jar:2.4.2]
