Corrupted database

❓Question🗄️Server☑️Ready

Hello. Today, I was planning to move to a new domain and setup NAT etc, but I noticed Immich is not running. Checking the containers, database hangs at startup. Looking at the log file, I get:

2026-01-14 05:15:38.769 UTC [1] LOG:  starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2026-01-14 05:15:38.771 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-01-14 05:15:38.774 UTC [28] LOG:  database system was shut down at 2026-01-14 05:14:59 UTC
2026-01-14 05:15:38.780 UTC [1] LOG:  database system is ready to accept connections
2026-01-14 05:15:41.240 UTC [38] ERROR:  missing chunk number 1 for toast value 28576 in pg_toast_17551
2026-01-14 05:15:41.240 UTC [38] STATEMENT:  ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[]
2026-01-14 05:15:41.326 UTC [37] LOG:  unexpected EOF on client connection with an open transaction

2026-01-14 05:15:38.769 UTC [1] LOG:  starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2026-01-14 05:15:38.771 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-01-14 05:15:38.774 UTC [28] LOG:  database system was shut down at 2026-01-14 05:14:59 UTC
2026-01-14 05:15:38.780 UTC [1] LOG:  database system is ready to accept connections
2026-01-14 05:15:41.240 UTC [38] ERROR:  missing chunk number 1 for toast value 28576 in pg_toast_17551
2026-01-14 05:15:41.240 UTC [38] STATEMENT:  ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[]
2026-01-14 05:15:41.326 UTC [37] LOG:  unexpected EOF on client connection with an open transaction

I don't know for how long is it in the state like that, but last time I did anything with my NAS was I did "shutdown now" 4 days ago. Dunno if that can corrupt databases?

Sadly, my last backup in the upload folder is from august. I don't know why. But as for now, I can only ask if somebody have any ideas, or... start over.

Thank you very much for your time!

Corrupted database

❓Question🗄️Server☑️Ready

Hello. Today, I was planning to move to a new domain and setup NAT etc, but I noticed Immich is not running. Checking the containers, database hangs at startup. Looking at the log file, I get:

2026-01-14 05:15:38.769 UTC [1] LOG:  starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2026-01-14 05:15:38.771 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-01-14 05:15:38.774 UTC [28] LOG:  database system was shut down at 2026-01-14 05:14:59 UTC
2026-01-14 05:15:38.780 UTC [1] LOG:  database system is ready to accept connections
2026-01-14 05:15:41.240 UTC [38] ERROR:  missing chunk number 1 for toast value 28576 in pg_toast_17551
2026-01-14 05:15:41.240 UTC [38] STATEMENT:  ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[]
2026-01-14 05:15:41.326 UTC [37] LOG:  unexpected EOF on client connection with an open transaction

2026-01-14 05:15:38.769 UTC [1] LOG:  starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2026-01-14 05:15:38.769 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2026-01-14 05:15:38.771 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-01-14 05:15:38.774 UTC [28] LOG:  database system was shut down at 2026-01-14 05:14:59 UTC
2026-01-14 05:15:38.780 UTC [1] LOG:  database system is ready to accept connections
2026-01-14 05:15:41.240 UTC [38] ERROR:  missing chunk number 1 for toast value 28576 in pg_toast_17551
2026-01-14 05:15:41.240 UTC [38] STATEMENT:  ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[]
2026-01-14 05:15:41.326 UTC [37] LOG:  unexpected EOF on client connection with an open transaction

Corrupted database

Similar Threads

Corrupted database

Similar Threads

Similar Threads

Similar Threads