Immich•2y ago

Error 500 after update.

I updated the immich instances to the new version and now getting error 500.

immich_postgres          | 2023-06-27 15:57:41.206 UTC [146] ERROR:  column "checksum" of relation "assets" contains null values
immich_postgres          | 2023-06-27 15:57:41.206 UTC [146] STATEMENT:  ALTER TABLE "assets" ALTER COLUMN "checksum" SET NOT NULL
immich_microservices     | [Nest] 8  - 06/27/2023, 3:57:41 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...
immich_microservices     | QueryFailedError: column "checksum" of relation "assets" contains null values
immich_microservices     |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
immich_microservices     |     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
immich_microservices     |     at async RequireChecksumNotNull1684328185099.up (/usr/src/app/dist/infra/migrations/1684328185099-RequireChecksumNotNull.js:10:9)
immich_microservices     |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_microservices     |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:260:35)
immich_microservices     |     at async DataSource.initialize (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:148:17)
immich_postgres          | 2023-06-27 15:57:41.226 UTC [147] ERROR:  column "checksum" of relation "assets" contains null values
immich_postgres          | 2023-06-27 15:57:41.226 UTC [147] STATEMENT:  ALTER TABLE "assets" ALTER COLUMN "checksum" SET NOT NULL
immich_server            | [Nest] 7  - 06/27/2023, 3:57:41 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...

immich_postgres          | 2023-06-27 15:57:41.206 UTC [146] ERROR:  column "checksum" of relation "assets" contains null values
immich_postgres          | 2023-06-27 15:57:41.206 UTC [146] STATEMENT:  ALTER TABLE "assets" ALTER COLUMN "checksum" SET NOT NULL
immich_microservices     | [Nest] 8  - 06/27/2023, 3:57:41 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...
immich_microservices     | QueryFailedError: column "checksum" of relation "assets" contains null values
immich_microservices     |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
immich_microservices     |     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
immich_microservices     |     at async RequireChecksumNotNull1684328185099.up (/usr/src/app/dist/infra/migrations/1684328185099-RequireChecksumNotNull.js:10:9)
immich_microservices     |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_microservices     |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:260:35)
immich_microservices     |     at async DataSource.initialize (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:148:17)
immich_postgres          | 2023-06-27 15:57:41.226 UTC [147] ERROR:  column "checksum" of relation "assets" contains null values
immich_postgres          | 2023-06-27 15:57:41.226 UTC [147] STATEMENT:  ALTER TABLE "assets" ALTER COLUMN "checksum" SET NOT NULL
immich_server            | [Nest] 7  - 06/27/2023, 3:57:41 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...

I have checked this issue: https://github.com/immich-app/immich/issues/2931 But when running the query i get 0 results.

GitHub

[BUG] Postgres database failed to start after 1.63.0 update · Issue...

The bug I updated my docker containers this morning to the latest versions and Immich fails to full start (get a 500 error). There are errors in the logs that it cannot connect to the database. So ...

3 Replies

jrasm91•2y ago

This is a different db update change from a previous release.

Alex Tran•2y ago

You can use this answer to fix the situation https://github.com/immich-app/immich/issues/2590#issuecomment-1566104816

GitHub

[BUG] "Unable to connect to the database" with the latest update 1....

The bug After the installation of the latest update (v1.58.0), my server is stuck in a bootloop. I had updated my compose with the new strings, but nothing works. The problem consists in two contai...

Cyber_StarOP•2y ago

Perfect Thanks! Problem is solved

Gaming

Programming

Error 500 after update.

Did you find this page helpful?