Orphaned (?) Files In Upload

[rh8056]

I was doing some server space management and was surprised to see that my upload folder is 15G. I have a storage template defined and I triggered the storage template migration job but nothing moved (I verified with du on the directory before and after). If I grab one of the photos from the upload path, I can find it (I think it's it at least) in my library, and it says it's saved according to my template. I browse the server and I see the file is in fact at the template location. The files in the upload folder structure are of course named with UUIDs, is there a way to search the database by that UUID to see why these are sitting in the upload path still? EDIT: Found in the docs the steps to query the database. I did: sudo -u postgres psql -d immich -c "Select * from asset where id = '8ac67394-85c9-4b71-bd0c-00edfe784f38';" but this returned 0 rows

When I browse in the web (by folders), I see one file that's listed as in the upload directory. When I find that file, all that it is in the directory is the xmp file:

root@nas:/mnt/nas/export/immich/upload/29c78208-ca0a-42c4-a0b5-a8fb53fb7c2c/8a/c6# ls -all
total 60
drwx------ 2 100999 100996   3 Sep 13 08:48 .
drwx------ 9 100999 100996   9 Sep 15 10:41 ..
-rw------- 1 100999 100996 695 Sep 11 12:28 8ac67394-85c9-4b71-bd0c-00edfe784f38.jpg.xmp

If I look in the templated location, I see the actual JPG file:

root@nas:# ls -all ../../../../library/user/2018/2018-03-09/IMG_20180309_180727.jpg 
-rw------- 1 100999 100996 3499852 Sep 11 08:31 IMG_20180309_180727.jpg

I guess my question is two fold:

1. How can I verify the 15G sitting in my upload folder is duplicated data?
2. Why do I have one xmp file that is "stuck" and not moving to the actual user template directory?

All of the other discussions I found on files stuck in upload pointed to the migration job - but I've already run that when I changed my upload path a few days ago and when I run it now, nothing new moves. Thanks!