topic Re: Receiving Duplicate error on alf_child_assoc in Alfresco Forum

Receiving Duplicate error on alf_child_assoc

michaelc — Thu, 09 Aug 2018 18:42:59 GMT

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: Duplica

Re: Receiving Duplicate error on alf_child_assoc

afaust — Fri, 10 Aug 2018 10:23:40 GMT

The issue is not with the parent_node_Id column, but with the unique index of the same name on that column and a slew of other colums. Some of the dashes in the '637884-33-3698713139-feedbacksummary_0dba58dd-8681-4a0a-99e0-159' key value link the values of different columns. So you have parent_node_id 637884, type_qname_id 33, child_node_name_crc 3698713139, child_node_name feedbacksummary_0dba58dd-8681-4a0a-99e0-159. Somehow you have a conflict with another row in the alf_child_assoc table with the same values for these columns.

Re: Receiving Duplicate error on alf_child_assoc

martinsc — Thu, 06 Sep 2018 05:40:59 GMT

Good Morning,

I have the same issue since 27.Aug.2018 02:55:56 ...

And I just cannot explain how this could happen.

The system runs now for more than a year without any error message.

The error came all of a sudden and repeats from since every some 5 minutes.

Any idea how I can get rid of it?

Thanks for helping,

Martin

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ERROR: duplicate key value violates unique constraint "parent_node_id"
DETAIL: Key (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)=(12673, 35, 274358454, ay9_a003060.sirslt) already exists.
STATEMENT: insert into alf_child_assoc
(
id, 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
(
$1, $2, $3, $4, $5,
$6, $7,
$8, $9, $10,
$11, $12
)

Re: Receiving Duplicate error on alf_child_assoc

michaelc — Fri, 07 Sep 2018 01:35:48 GMT

I never really resolved this, I changed the id number, thus it was unique and the error stopped.
never figured out why I got it or what it's was trying to get.

Re: Receiving Duplicate error on alf_child_assoc

martinsc — Mon, 10 Sep 2018 06:00:35 GMT

Thanks for helping.

I just wanted to change this specific data set, but then I found out, that the error has suddenly stopped without any input.

It has gone like it has been appearing ...

Martin