currently processing stuck on one photo

[pcripsey]

I have A-Eye running which is stuck on a photo. if i go into a see all photos and i ask it to repurpose say 10 photos it does that but the pending photos around 39000 are stuck. it had processed just over 3000, i did have to stop all docker containers and restarted them. i dont see anything in the logs.

[mahood73]

I have the same issue - I had to reboot the machine Ollama was running on, and A-Eye seems to have 'lost its place'. Ollama is confirmed as reconnected, but nothing is progressing. Also nothing in the logs.

With a little debugging help from its namesake :), it looks like that image was left marked as processing in the DB.
After the container restart, A-Eye did not repopulate the worker queue from the existing pending rows, or retry the 'processing' image. So the app now looks busy, but is actually idle with stale DB state.

I was able to 'unstick' it by:

1. Stop the container
2. Back up the DB
3. Check for 'processing' images.
4. Change state of 'processing' to 'pending'
5. Start container.
6. Wait for it to resume. It didn't.

Command to check for 'processing':

sqlite3 -header -column photo_renamer.db "
select id, original_filename, file_path, status
from images
where status = 'processing';
"

Command to reset status (use the image ID you got from the command above):

sqlite3 photo_renamer.db "
update images
set status = 'pending',
    processed_at = null,
    error_message = null
where id = {imageID}
  and status = 'processing';
"

Unfortunately it won't just resume after this. We need some way to shift 'pending' items back into the queue itself.
I had an agent slap something together which seems to work, but it's obviously a workaround for the root cause. If you want, I can open a PR but I didn't want to without prior agreement.

I love this clever app! It's beavering away adding sidecars to all my Immich files, and thanks for putting it together.

[pcripsey]

if i set the status of in_queue in the database to 1 for those that the status is pending then i can go page for page and reprocess without context but that does 50 at a time.