#How to sync/fix out of date database

1 messages · Page 1 of 1 (latest)

velvet forge
#

I had a file system failure 3 weeks ago that caused my db backups to stop. During that time when I was not aware of the failure, I continued to sync 20 or so photos to immich via the mobile app.

I have now had to restore my postgres and everything works as expected, but the 20 or so photos I took during that time are now missing from the server webUI. On my phone, it sees a "blank" entry for the photo it synced, and also shows the photo itself with the cloud/checkmark icon showing it is backed up. Unfortunately the server seems to have lost the db entry for these photos as it is unable to do anything with them. When I try to trash or delete the "blank" photo or the "real" one, it simply says "error occurred".

A couple of photos from the time in question do exist in the server webUI timeline, but the majority are missing.

Is there any way to resolve/remove these missing entries?

sturdy gullBOT
#

:wave: Hey @velvet forge,

Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich immich.

References

#

Checklist

I have...

  1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: read applicable release notes.
  3. :ballot_box_with_check: reviewed the FAQs for known issues.
  4. :ballot_box_with_check: reviewed Github for known issues.
  5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
  6. :blue_square: uploaded the relevant information (see below).
  7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

Information

In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:

  • Your docker-compose.yml and .env files.
  • Logs from all the containers and their status (see above).
  • All the troubleshooting steps you've tried so far.
  • Any recent changes you've made to Immich or your system.
  • Details about your system (both software/OS and hardware).
  • Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
  • The version of the Immich server, mobile app, and other relevant pieces.
  • Any other information that you think might be relevant.

Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

hard sapphire
#

you can sign out and sign back in on the mobile app

velvet forge
#

I'm such an idiot.

#

Thanks. Disappointed in myself for not trying that.

#

/closed