#Database restore seems to have failed

1 messages · Page 1 of 1 (latest)

karmic hollow
#

First of all, Thanks for any help.
I followed the steps located here since i wanted to use docker instead of podman: https://immich.app/docs/administration/backup-and-restore/
I also moved from using podman to docker
Linux Version: Fedora 39 server
My steps were:
Backup DB
removed podman containers
removed podman
installed docker and docker-compose
Followed the restore proceedure in the link.

I got these errors when restoring the db.

ERROR: extension "vectors" must be installed in schema "vectors"
ERROR: extension "vectors" does not exist

ERROR: type "public.vector" does not exist
LINE 4: embedding public.vector(512) NOT NULL,
^
ERROR: relation "public.asset_faces" does not exist

ERROR: relation "public.asset_faces" does not exist

A bunch of these:
invalid command \N

ERROR: syntax error at or near "3"
LINE 1: 3a3f7412-2187-4590-87d1-207619b0023d
^
invalid command .
ERROR: syntax error at or near "AD"
LINE 1: AD.06 Sant Julià de Loria
^
invalid command .
ERROR: syntax error at or near "AE"
LINE 1: AE.01.101 Abu Dhabi Municipality
^
invalid command \N
invalid command .
ERROR: syntax error at or near "2432857"
LINE 1: 2432857c-f77d-441f-9d13-b2909d65104b Default Library 387271e...
^
invalid command .
ERROR: syntax error at or near "1"
LINE 1: 1 1645130759468 CreateUserTable1645130759468
^
invalid command .

ERROR: relation "public.smart_search" does not exist
invalid command .
ERROR: syntax error at or near "3"
LINE 1: 3a3f7412-2187-4590-87d1-207619b0023d [-0.03934731, 0.0353784...
^
invalid command .

ERROR: relation "public.asset_faces" does not exist
ERROR: relation "public.smart_search" does not exist
ERROR: insert or update on table "smart_info" violates foreign key constraint "FK_5e3753aadd956110bf3ec0244ac"
DETAIL: Key (assetId)=(3a3f7412-2187-4590-87d1-207619b0023d) is not present in table "assets".

I do not know where to do grom here.

summer jasperBOT
#

:wave: Hey @karmic hollow,

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 using the buttons below or the /upload command.
  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.

strong delta
#

What version are you coming from and to?

karmic hollow
#

At first i tried going from 1.93.3. to 1.101 then i set my .env file to pull 1.93.3 thinking that might hav ebeen the issue but same resultes.

#

Working on uploading logs now

strong delta
#

That is the issue

#

For 1.93 you need pg vectors 0.1.11 not 0.2.0

#

Then follow the instructions in 1.95 release notes to upgrade to 0.2.0

karmic hollow
#

Thanks, will look into that and let you know.

karmic hollow
#

Zeus, Thanks for the info, got everything back up and running on 1.101.0