diff options
Diffstat (limited to 'app/workers/prune_old_events_worker.rb')
-rw-r--r-- | app/workers/prune_old_events_worker.rb | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/app/workers/prune_old_events_worker.rb b/app/workers/prune_old_events_worker.rb index d75083f9ab1..5883cafe1d1 100644 --- a/app/workers/prune_old_events_worker.rb +++ b/app/workers/prune_old_events_worker.rb @@ -2,7 +2,16 @@ class PruneOldEventsWorker include Sidekiq::Worker def perform - # Contribution calendar shows maximum 12 months of events - Event.delete(Event.unscoped.where('created_at < ?', (12.months + 1.day).ago).limit(10_000).pluck(:id)) + # Contribution calendar shows maximum 12 months of events. + # Double nested query is used because MySQL doesn't allow DELETE subqueries + # on the same table. + Event.unscoped.where( + '(id IN (SELECT id FROM (?) ids_to_remove))', + Event.unscoped.where( + 'created_at < ?', + (12.months + 1.day).ago). + select(:id). + limit(10_000)). + delete_all end end |