nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Failed to purge nodes.

ashwini

Hello All ,

Everynight around 21:00 alfresco throws below exception:

2012-09-02 21:00:17,076  ERROR [node.db.DeletedNodeCleanupWorker] [DefaultScheduler_Worker-9] 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: 1344020400060
   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_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_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_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
; SQL []; Cannot delete or update a parent row: a foreign key constraint fails (`alfresco`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_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_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))‍‍‍‍‍‍‍‍‍‍

How I can resolve this issuee , issue seams to be with some deleted nodes , whoes entry is still exist somewhere, resulting foreign key constraint fails.

Find more posts tagged with

Comments

mitpatoliya

I think this is because the OOTB schedular which runs at that time and try to purge the deleted nodes where one of the entry is missing.
If you are using the enterprise version then I guess you can try full re indexing.

ashwini

No I am using community edition, and I tried full indexing but it throws exception for some nodes, I thinks its because of the same nodes.

You can see the exception in post
https://forums.alfresco.com/en/viewtopic.php?f=8&t=46213

Is there any other way to get rid of this.

t_sato

Hi,

What about tracing SQL to figure out which record is actually making the violation, at least to move next?

JDBC option:

profileSQL=true‍

mitpatoliya

Hi Ashwini,
Even for the community versions there is problem of solr license.
check out this .
https://forums.alfresco.com/en/viewtopic.php?f=2&t=45940

ashwini

but I am not using Solr , I have configured my system to run with Mysql database and Lucene indexing.

mitpatoliya

Could you once try lucene full reindexing?
i.e. add the entry

index.recovery.mode=FULL

in you alfresco-global.properties file and restart the server.

ashwini

Ya I have already done that and got below exceptions :

https://forums.alfresco.com/en/viewtopic.php?f=8&t=46213

heiko_robert

and if someone googles this thread: solution is also here:
https://forums.alfresco.com/en/viewtopic.php?f=8&t=46213

niketapatel

We also faced same issue and here I have given detailed steps to resolve it!!!

http://niketa-alfresco3.blogspot.in/2013/09/failed-to-purge-nodes.html