topic Re: Failed to purge nodes. in Alfresco Archive

Failed to purge nodes.

ashwini — Tue, 04 Sep 2012 15:13:17 GMT

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.

Re: Failed to purge nodes.

mitpatoliya — Wed, 05 Sep 2012 08:24:18 GMT

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.

Re: Failed to purge nodes.

ashwini — Wed, 05 Sep 2012 08:28:17 GMT

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.

Re: Failed to purge nodes.

t_sato — Thu, 06 Sep 2012 08:41:11 GMT

Hi,

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

JDBC option:

profileSQL=true‍

Re: Failed to purge nodes.

mitpatoliya — Thu, 06 Sep 2012 11:58:14 GMT

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

Re: Failed to purge nodes.

ashwini — Thu, 06 Sep 2012 12:21:37 GMT

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

Re: Failed to purge nodes.

mitpatoliya — Mon, 10 Sep 2012 08:49:37 GMT

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.

Re: Failed to purge nodes.

ashwini — Mon, 10 Sep 2012 10:47:19 GMT

Ya I have already done that and got below exceptions :

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

Re: Failed to purge nodes.

heiko_robert — Fri, 23 Aug 2013 16:20:03 GMT

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

Re: Failed to purge nodes.

niketapatel — Fri, 27 Sep 2013 05:51:07 GMT

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