@simon - I ended up doing some manual deletion, I was responding to a messy removal request (mixture of threads, optimized images and original images). So wanted to process it asap. I did not scrub out the originals for optimized urls and vice versa manually. It seems that those loose ends did end up being removed, just took ~2 days or more.
But I imagine that makes sense, if the job runs once every 24hrs i.e. if the posts are deleted soon after the last purge. They won’t be removed in the next purge, but the following one + processing time.
Though there is one weird case. The file itself has been removed (manually). When I use this query as described here here i.e.
u = Upload.find_by_sha1('c35ab963fb22f8612697923ebc98d341693cfa1d')
puts u.url
u.optimized_images.each do |oi|
puts oi.url
end
I get a result like:
id: 12345,
user_id: 12345,
original_filename: “imagename.jpg",
filesize: 122146,
width: 1136,
height: 640,
url:
"/uploads/default/original/3X/c/9/c35ab963fb22f8612697923ebc98d341693cfa1d",
created_at: Sat, 12 Oct 2019 05:03:23 UTC +00:00,
updated_at: Sat, 12 Oct 2019 05:03:23 UTC +00:00,
sha1: "c35ab963fb22f8612697923ebc98d341693cfa1d",
origin: nil,
retain_hours: nil,
extension: "jpeg",
thumbnail_width: 690,
thumbnail_height: 388,
etag: nil,
secure: false,
access_control_post_id: nil,
original_sha1: nil,
verification_status: 1,
animated: nil>
Not sure what it is. But seems that the user has been deleted when I try find them using: Find users by ID - #2 by zogstrip
discourse.example.com/admin/users/12345/-
My best guess would be a Profile Header or User Background Card, from the dimensions.