Database Restore Failure with error reported as null
🚧Setup❓Question🗄️Server☑️Ready
Hello, I've been migrating to a new machine and decided to set up a fresh Immich v2.5.5 and run automatic restore with database backup from v2.2.1 instance. It fails
I've also attached full log.
Thank you in advance!
Database Restore FailureDatabase Restore Failurenullnullinstallation
Debian 13, installed as a podman pod.env file
IMMICH_LOG_LEVEL=debug
DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
POSTGRES_USER=postgres
DB_DATABASE_NAME=immich
POSTGRES_DB=immich
REDIS_HOSTNAME=immich_redis
IMMICH_MACHINE_LEARNING_URL=http://immich_machine_learning:3003IMMICH_LOG_LEVEL=debug
DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
POSTGRES_USER=postgres
DB_DATABASE_NAME=immich
POSTGRES_DB=immich
REDIS_HOSTNAME=immich_redis
IMMICH_MACHINE_LEARNING_URL=http://immich_machine_learning:3003log
immich_server [Nest] 2 - 02/08/2026, 4:25:40 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Database Restore Starting. Database Version: 14
immich_server [Nest] 2 - 02/08/2026, 4:25:40 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 11.04%
immich_postgres 2026-02-08 16:25:40.529 UTC [139] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:25:40.624 UTC [143] ERROR: current user cannot be dropped
immich_postgres 2026-02-08 16:25:40.624 UTC [143] STATEMENT: DROP ROLE IF EXISTS postgres;
immich_postgres 2026-02-08 16:25:40.625 UTC [143] ERROR: role "postgres" already exists
immich_postgres 2026-02-08 16:25:40.625 UTC [143] STATEMENT: CREATE ROLE postgres;
immich_server [Nest] 2 - 02/08/2026, 4:25:41 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 15.05%
...
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 99.31%
immich_server /usr/lib/postgresql/14/bin/psql exited (0)
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Running migrations
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 100.00%
immich_server [Nest] 2 - 02/08/2026, 4:26:37 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Migration "1761755618862-FixColumnNames" succeeded
...
immich_server [Nest] 2 - 02/08/2026, 4:26:37 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Finished running migrations
immich_postgres 2026-02-08 16:26:58.015 UTC [194] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:26:58.017 UTC [204] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:26:58.017 UTC [204] STATEMENT: update "asset_file" set "path" = REGEXP_REPLACE("path", '^/usr/src/app/upload', '/data')
immich_server [Nest] 2 - 02/08/2026, 4:26:58 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 11.09%
...
immich_server [Nest] 2 - 02/08/2026, 4:27:01 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 68.52%
immich_redis 1:M 08 Feb 2026 16:27:02.031 * 100 changes in 300 seconds. Saving...
immich_redis 1:M 08 Feb 2026 16:27:02.033 * Background saving started by pid 63
immich_redis 63:C 08 Feb 2026 16:27:02.036 * DB saved on disk
immich_redis 63:C 08 Feb 2026 16:27:02.037 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
immich_redis 1:M 08 Feb 2026 16:27:02.134 * Background saving terminated with success
immich_server [Nest] 2 - 02/08/2026, 4:27:13 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 73.51%
...
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 100.00%
immich_server /usr/lib/postgresql/14/bin/psql exited (0)
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM ERROR [Maintenance:MaintenanceWorkerService~rqpe5o2n] Database Restore Failure: null
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM ERROR [Maintenance:MaintenanceWorkerService~rqpe5o2n] Encountered error running action: nullimmich_server [Nest] 2 - 02/08/2026, 4:25:40 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Database Restore Starting. Database Version: 14
immich_server [Nest] 2 - 02/08/2026, 4:25:40 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 11.04%
immich_postgres 2026-02-08 16:25:40.529 UTC [139] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:25:40.624 UTC [143] ERROR: current user cannot be dropped
immich_postgres 2026-02-08 16:25:40.624 UTC [143] STATEMENT: DROP ROLE IF EXISTS postgres;
immich_postgres 2026-02-08 16:25:40.625 UTC [143] ERROR: role "postgres" already exists
immich_postgres 2026-02-08 16:25:40.625 UTC [143] STATEMENT: CREATE ROLE postgres;
immich_server [Nest] 2 - 02/08/2026, 4:25:41 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 15.05%
...
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 99.31%
immich_server /usr/lib/postgresql/14/bin/psql exited (0)
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Running migrations
immich_server [Nest] 2 - 02/08/2026, 4:26:24 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Restore progress ~ 100.00%
immich_server [Nest] 2 - 02/08/2026, 4:26:37 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Migration "1761755618862-FixColumnNames" succeeded
...
immich_server [Nest] 2 - 02/08/2026, 4:26:37 PM LOG [Maintenance:DatabaseRepository~rqpe5o2n] Finished running migrations
immich_postgres 2026-02-08 16:26:58.015 UTC [194] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:26:58.017 UTC [204] FATAL: terminating connection due to administrator command
immich_postgres 2026-02-08 16:26:58.017 UTC [204] STATEMENT: update "asset_file" set "path" = REGEXP_REPLACE("path", '^/usr/src/app/upload', '/data')
immich_server [Nest] 2 - 02/08/2026, 4:26:58 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 11.09%
...
immich_server [Nest] 2 - 02/08/2026, 4:27:01 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 68.52%
immich_redis 1:M 08 Feb 2026 16:27:02.031 * 100 changes in 300 seconds. Saving...
immich_redis 1:M 08 Feb 2026 16:27:02.033 * Background saving started by pid 63
immich_redis 63:C 08 Feb 2026 16:27:02.036 * DB saved on disk
immich_redis 63:C 08 Feb 2026 16:27:02.037 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
immich_redis 1:M 08 Feb 2026 16:27:02.134 * Background saving terminated with success
immich_server [Nest] 2 - 02/08/2026, 4:27:13 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 73.51%
...
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM LOG [Maintenance:MaintenanceWorkerService~rqpe5o2n] Rollback progress ~ 100.00%
immich_server /usr/lib/postgresql/14/bin/psql exited (0)
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM ERROR [Maintenance:MaintenanceWorkerService~rqpe5o2n] Database Restore Failure: null
immich_server [Nest] 2 - 02/08/2026, 4:27:30 PM ERROR [Maintenance:MaintenanceWorkerService~rqpe5o2n] Encountered error running action: nullI've also attached full log.
Thank you in advance!
message.txt98.75KB
