Awhile back i posted with issues running reports cleanup due to it trying to batch it all up into one transaction and timing out if it took longer than XXX seconds in the rake job.
I’m not seeing the same thing with the facts:cleanup job. I currently have the following count(s)
Running the rake task today took around 6 hours on the first phase.
I then got a Ruby Stack error. It “appears” it tried to delete all facts (by ID) in a single transaction. This transaction is longer than my console output, and i cant even grab it from the slow_query log, as it appears to be hundreds of thousands - of not millions of ID’s in a single query.
Is there a way for this rake task to also “batch up” deletions? Much like reports this may “take longer” but will also probably allow it to finish in scenarios where it will take a while to catch up or process them all?