AnsweredAssumed Answered

ERROR [org.alfresco.repo.node.db.DeletedNodeCleanupWorker]

Question asked by thanthtoozin on Jan 29, 2014
Latest reply on Feb 11, 2014 by tinlinnnsoe
In alfresco log I see some background processing error



21:00:05,328 ERROR [org.alfresco.repo.node.db.DeletedNodeCleanupWorker] Failed to purge nodes.  If the purgable set is too large for the available DB resources
   then the nodes can be purged manually as well.
   Set log level to WARN for this class to get exception log:
   Max commit time: 1386763200095
   Error:   

## Error updating database. Cause: org.postgresql.util.Update of PSQLException:ERROR: table "alf_node" or the deletion violates outside key to table "alf_child_assoc" limitation "fk_alf_cass_pnode" Detailed l: key (id)=(6385) is still referred to by table "alf_child_assoc"




Please explain me why this error occur and how I can solve this.
Alfresco Version : 4.0 d
Database : postgres 8.4

Thank you very much.

Outcomes