Hi, new self-hosting here. I've bulk-uploaded two different sets of images, one from iCloud and another from Google Photos. I checked randomly through my photos after ALL the queues were finished, and there were a handful of photos where the context menus did not show the full options (especially including re-running facial recognition). Thus I can't simply refresh faces and solve this problem, the issue seems to run deeper and the images are "stuck" without any of the metadata controls. I'm unfamiliar with how the data is stored that might solve the issue.
1. Re-running "missing" for the face detection job queue doesn't solve things
2. Deleting and re-uploading the individual photo does solve the problem, but I would like to find how to identify ALL the ones with this issue
3. I haven't re-done bulk uploads but I imagine this could fix the problem
What are the conditions that make a photo get stuck like this?
What steps can I do, short of doing a new batch upload of the whole set?
Are there any database queries I could try in order to identify all the photos that have this problem so I could, for example, put them all in a special album programmatically so I can delete and re-upload just the needed ones?