AnsweredAssumed Answered

Receiving Duplicate error on alf_child_assoc

Question asked by michaelc on Aug 9, 2018
Latest reply on Sep 10, 2018 by martinsc

Hoping for some input.
in my logs I find this error occurring 100's of times.

; SQL []; Duplicate entry '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' for key 'parent_node_id'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' for key 'parent_node_id'
 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
 at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:421)
 at com.sun.proxy.$Proxy17.insert(Unknown Source)
 at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:254)
 at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.insertChildAssoc(NodeDAOImpl.java:932)
 at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.newChildAssocInsertImpl(AbstractNodeDAOImpl.java:3236)
 ... 64 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' for key 'parent_node_id'

. . .

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' for key 'parent_node_id'
### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
### The error occurred while setting parameters
### SQL: insert into alf_child_assoc         (             version, parent_node_id, child_node_id, type_qname_id,             child_node_name_crc, child_node_name,             qname_ns_id, qname_localname, qname_crc,             is_primary, assoc_index         )         values         (             ?, ?, ?, ?,             ?, ?,             ?, ?, ?,             ?, ?         )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' for key 'parent_node_id'

 

Then I looked into the table, I don't find that key in parent_node_id.
I do find several 637884 but the field is 20 char so this left me confused.

 

any idea what is causing this and how to resolve?
Release Alfresco Content Services started (Community). Current version: 5.2.0

'alfresco-share-services' version 5.2.0.

'org_alfresco_module_wcmquickstart' version 5.2.f.

Regards

Outcomes