AnsweredAssumed Answered

Failed to purge nodes @ 21.00 with mysql

Question asked by loftux Moderator on Nov 30, 2011
Latest reply on Nov 19, 2012 by ashwini
I have seen this error with 2 clients, one is running 3.4.d, the other 4.0.c.
21:00:07,073 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: 1319745600050
   Error:      
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`alf_node_aspects`, CONSTRAINT `fk_alf_nasp_n` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`))
### The error may involve alfresco.node.delete_NodesByTxnCommitTime-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`alf_node_aspects`, CONSTRAINT `fk_alf_nasp_n` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`))
; SQL []; Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`alf_node_aspects`, CONSTRAINT `fk_alf_nasp_n` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`alf_node_aspects`, CONSTRAINT `fk_alf_nasp_n` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`))
The version of mysql in this case is 5.1.52.
Anyone knows what could cause this error? I have tuned my.cnf to increase resources/memory for mysql, but maybe there is a specific setting that could help in this case as it complains about resources.
The job that runs at 21 is nodeServiceCleanupJobDetail, but what does it do and what effects will it have when it fails? I haven't got any reports of any effects from this, but it may pop up later.

Outcomes