#Cannot restore any backup

1 messages · Page 1 of 1 (latest)

solid yew
#

I recently bought a new mini-pc which I wish to use as a server

Before I hosted immich on my old laptop.

On the new pc I downloaded the new docker-compose.yml and did not touch it
In .env I used new folder locations for postgres and library

I rsync-ed all the library content from my old laptop to my new pc over ssh which took one night
The library size seems to match so I hope the files transferred correctly
After that I created a backup on my old server and downloaded to my main pc from where I uploaded it into the immich maintenance mode

All the entries on the "restore your library" page have green checks on them, however I cannot restore any backup
In the web ui it just stops at 100% and then rollbacks after which I have a box with "null" in it (see picture)
In logs I get

immich_postgres          | 2026-02-16 19:09:58.046 UTC [87] FATAL:  terminating connection due to administrator command

I tried restoring it via a command
In this case I get a bunch of logs and one error in the end

CREATE INDEX
ERROR:  failed to parse options: TOML parse error at line 1, column 1
  |
1 |
  | ^
image.png
peak rapidsBOT
#

:wave: Hey @solid yew,

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. :ballot_box_with_check: uploaded the relevant information (see below).
  7. :ballot_box_with_check: 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.

peak rapidsBOT
solid yew
#

Discord hates me so here is what did not fit

Here is docker ps -a

sudo docker ps -a
CONTAINER ID   IMAGE                                                            COMMAND                  CREATED         STATUS                     PORTS                                         NAMES
d8792d691a49   ghcr.io/immich-app/immich-server:release                         "tini -- /bin/bash -…"   6 minutes ago   Up 6 minutes (unhealthy)   0.0.0.0:2283->2283/tcp, [::]:2283->2283/tcp   immich_server
7d8d4e12b91d   ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0   "/usr/local/bin/immi…"   6 minutes ago   Up 6 minutes (healthy)     5432/tcp                                      immich_postgres
b11dcbe735bb   ghcr.io/immich-app/immich-machine-learning:release               "tini -- python -m i…"   6 minutes ago   Up 6 minutes (healthy)                                                   immich_machine_learning
011d62fe8d5c   valkey/valkey:9                                                  "docker-entrypoint.s…"   6 minutes ago   Up 6 minutes (healthy)     6379/tcp                                      immich_redis

here is .env (comments removed)

UPLOAD_LOCATION=/home/gospodin/immich/library
DB_DATA_LOCATION=/home/gospodin/immich/postgres

IMMICH_VERSION=release

DB_PASSWORD='<I removed it but its there>'

DB_USERNAME=postgres
DB_DATABASE_NAME=immich

docker-compose.yml is just as it came from wget so I did not share it

#

and again discord message length limit

sudo fdisk -l
Disk /dev/nvme0n1: 1,86 TiB, 2048408248320 bytes, 4000797360 sectors
Disk model: CUSU CV3500Q 2TB
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 8B2035C1-868F-4934-8AEB-8834C55D9135

Device           Start        End    Sectors  Size Type
/dev/nvme0n1p1    4096    4198399    4194304    2G EFI System
/dev/nvme0n1p2 4198400 4000797293 3996598894  1,9T Linux filesystem

df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/nvme0n1p2  1,9T  108G  1,7T   7% /
devtmpfs        4,0M     0  4,0M   0% /dev
tmpfs            11G     0   11G   0% /dev/shm
efivarfs        128K  8,9K  115K   8% /sys/firmware/efi/efivars
tmpfs           4,3G  4,2M  4,3G   1% /run
none            1,0M     0  1,0M   0% /run/credentials/systemd-journald.service
tmpfs            11G     0   11G   0% /tmp
/dev/nvme0n1p1  2,0G  328K  2,0G   1% /boot/efi
none            1,0M     0  1,0M   0% /run/credentials/[email protected]
tmpfs           2,2G  8,0K  2,2G   1% /run/user/1000

Please help me figure it out...

#

Oh and the pc specs are 24G RAM and R7 6800H so they should not cause any problems probably

The OS is EndeavourOS

sweet dew
#

It's failing on a vector index create in the restore sql; can you unpack the file and look for that line, and then post that piece of the document?

#

Also, across the move did you change anything about the version of the immich-server or postgres image you're using?

solid yew
sweet dew
#

Yes exactly

solid yew
#

Okay I did some greps
Here is every CREATE INDEX with "vec" somewhere close

CREATE INDEX clip_index ON public.smart_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='
        residual_quantization = false
        [build.internal]
        lists = [1]
        spherical_centroids = true
        build_threads = 4
        sampling_factor = 1024
        ');


--
-- Name: face_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX face_index ON public.face_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='^M
        residual_quantization = false^M
        [build.internal]^M
        lists = [1]^M
        spherical_centroids = true^M
        build_threads = 4^M
        sampling_factor = 1024^M
        ');
thick girder
#

H^M^M^M^M 🤔

solid yew
#

not sure whats up with this ^M

sweet dew
#

^M
There's the problem.

#

Has the file been touched by a windows system?

solid yew
sweet dew
#

Although even then it shouldn't be (only) there tbh

#

I have no idea where those would've come from then, pretty odd

#

but removing them should fix it

solid yew
#

Ok working on it
I'll let you know if it works

thick girder
#

Try easy mode first with: dos2unix dump.sql

solid yew
#

oh ok

#

It did not work through web interface but it did succeed from the terminal command
Thank you so much

How did you know it was a vector index create?

#

and on the same note
how do I mark this as solved?

thick girder
#

From the 'CREATE INDEX' snippet 😛

#

just /close 🙂

solid yew
#

and he knew it were vectors before I sent the ^M^M^M