topic Re: What to do when DeleteNodeClean job is failing everyday ? in Alfresco Archive

What to do when DeleteNodeClean job is failing everyday ?

cesarista — Wed, 28 Dec 2016 10:01:10 GMT

Hi:I am working in an Alfresco instance that is having problems when executing the DeleteNodeClean Job at 21:00 everyday. Did you find it sometime ? What to do in these situations ? Any recommendation for a non-DBA?The log mentions that "If the purgable set is too large for the available DB resource

Re: What to do when DeleteNodeClean job is failing everyday ?

kaynezhang — Wed, 28 Dec 2016 14:46:22 GMT

You error is caused by . Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_node" violates foreign key constraint "fk_alf_cass_pnode" on table "alf_child_assoc"

Detail: Key (id)=(82010420) is still referenced from table "alf_child_assoc".

So you can execute following sql manully
delete FROM `alfresco`.`alf_child_assoc` where parent_node_id=82010420

Re: What to do when DeleteNodeClean job is failing everyday ?

cesarista — Wed, 28 Dec 2016 15:40:30 GMT

Thank you very much ‌, I'll try.

Regards.

--C.

Re: What to do when DeleteNodeClean job is failing everyday ?

afaust — Thu, 29 Dec 2016 11:29:20 GMT

Please note that this way you might end up with orphaned nodes in the DB that do not have any parent. You should identify the child associations first via a simple select instead of blindly deleting them. Normally when a node is deleted all child associations should be automatically deleted as well. This occurs days or weeks before the DeletedNodeCleanupWorker even considers the node for cleanup. It should not be possible to create new child associations for a deleted node, so it is very interesting to find out how this entry was created.

Re: What to do when DeleteNodeClean job is failing everyday ?

cesarista — Thu, 29 Dec 2016 16:11:15 GMT

Thanks for the clarification Axel Faust.

Regards.

--C.