#Possibly Corrupted Postgres database

1 messages · Page 1 of 1 (latest)

narrow bridge
#

Hi, I've been using immich normally on TrueNAS Scale for a few months now and been using the normal TrueNAS update as well as the apps update button. Recently, immich refused to start. Looking at the Postgres logs shows this:

invalid resource manager ID in primary checkpoint record
could not locate a valid checkpoint record

Googling shows that it could be a Postgres issue. There's a pgBackup folder under the TrueNAS app and I think it's a weekly (?) backup of the databse. Could someone please guide me through on how to safely restore the database?

Thank you!

eager cryptBOT
#

:wave: Hey @narrow bridge,

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

References

Checklist

  1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: I have read applicable release notes.
  3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
  4. :ballot_box_with_check: I have reviewed Github for known issues.
  5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
  6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.
  7. :ballot_box_with_check: I have 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)

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