How to implement guide with `find_each` and batch processing in activerecord causing skipped records in ruby on rails 6.1
This might be a silly question, but I'm having trouble with the `find_each` method in ActiveRecord when trying to process records in batches... I recently upgraded to Rails 6.1, and now it seems like some records are being skipped when I run the following code: ```ruby User.find_each(batch_size: 100) do |user| # Processing user data if user.active? && user.last_login.nil? user.update(last_login: Time.current) end end ``` I've checked the database, and I can confirm there are users who meet the criteria but aren't being updated. I thought `find_each` would ensure that every record is processed, but I suspect there might be an scenario with how the query is being optimized or cached. To troubleshoot, I tried running `User.where(active: true, last_login: nil).count` and it returns the correct count of users, indicating they exist. I also tried debugging with `puts user.id` inside the block to see which records are processed, and it looks like around 50% of the records are being skipped. Additionally, I checked for any callbacks that might be interfering with the update, but I don't see anything that would prevent the update from happening. Is there something I might be missing about how `find_each` works in Rails 6.1, or could there be a question with how the query is structured? Any insights would be appreciated! I recently upgraded to Ruby 3.11. Could this be a known issue?