Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
In Umbraco 8.4.0, I am working with large data sets. When I try and empty the recycle bin (probably 30,000 records) it never seems to complete.
Is there raw SQL for doing such operations?
The reason I want to empty the recycle bin is that is seems to be causing issues for me sometimes when updating my Document Type definitions - I presume because it is trying to update all records of that type in the recycle bin?
Thanks for any help anyone can be.
Try to increase operations timeout for sql queries.
I had tried that. Maybe I should have gone for a longer time. In the end I just switched to a clean database and started again.
While the empty recycle bin command still times out nowadays, there is a workaround. If you navigate to click the recycle bin node in the navigation, it will take you to a list view that can be used to delete the nodes in batches. This can still run into timeout errors, but will make it clear what node is the problem. Generally I've found that timeout errors happen when a node has too many versions, as umbraco has to delete all of those too when deleting a node. The plugin UnVersion can be used to clear out the unwanted versions once configured. For reference, here is how I configured the unVersion.config file.
<add maxCount="5" />
With this configuration, unversion will delete all revisions except for the 5 most recent when a node is published.
Do note that this will not change the history in the info tab, as that information is pulled from entries in the umbracoLog table, which are not deleted when a version is deleted. Clicking the rollback button and opening the versions there will show that it deleted the old versions successfully.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted