Error in CleanUpUnmatchedIPs: timestamp is 2.7M years BC

תמיכה
2

Looks like this is caused by a corrupted last_match_at value in your screened_ip_addresses table.

You can fix it by running the following in the Rails console (./launcher enter app then rails c):

# First, find the problematic record(s)
ScreenedIpAddress.where("last_match_at < '0001-01-01'").each do |sip|
  puts "ID: #{sip.id}, IP: #{sip.ip_address}, last_match_at: #{sip.last_match_at}"
end

# Then either delete it
ScreenedIpAddress.where("last_match_at < '0001-01-01'").destroy_all

# Or fix the timestamp to `NULL` (so it uses `created_at` for the cleanup logic instead)
ScreenedIpAddress.where("last_match_at < '0001-01-01'").update_all(last_match_at: nil)