X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/22bcfb1240fb3b03613944d8517c100650ab9ad2..6ba51da46e41f2cf9260ef8e0b74a933ae82a362:/script/cleanup

diff --git a/script/cleanup b/script/cleanup
index 270877096..72a6dec9b 100755
--- a/script/cleanup
+++ b/script/cleanup
@@ -2,17 +2,27 @@
 
 require File.dirname(__FILE__) + '/../config/environment'
 
-Session.find(:all, :conditions => ["updated_at < ?", 1.week.ago]).each do |session|
-  begin
-    if session[:user] and User.find(session[:user])
-      session.destroy if session.updated_at < 1.month.ago
-    else
+last_session_id = 0
+
+begin
+  sessions = Session.find(:all,
+                          :conditions => ["updated_at < ? and id > ?", 1.week.ago, last_session_id],
+                          :order => :id, :limit => 1000)
+
+  sessions.each do |session|
+    last_session_id = session.id
+
+    begin
+      if session[:user] and User.find(session[:user])
+        session.destroy if session.updated_at < 1.month.ago
+      else
+        session.destroy
+      end
+    rescue Exception => ex
+      puts "Invalid session #{session.session_id}: #{ex.to_s}"
       session.destroy
     end
-  rescue Exception => ex
-    puts "Invalid session #{session.session_id}: #{ex.to_s}"
-    session.destroy
   end
-end
+end while sessions.length > 0
 
 UserToken.delete_all("expiry < NOW()")