Error 500 after update.
I updated the immich instances to the new version and now getting error 500.
I have checked this issue: https://github.com/immich-app/immich/issues/2931 But when running the query i get 0 results.
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...](https://images-ext-1.discordapp.net/external/9W4VKatiLVEEIQd69ngJyb7gbNAXHxADpeFN4k9K9HE/https/opengraph.githubassets.com/e920af64d5225447554ab89afba734460f48400441e7ad966ae692bac8a0a6e9/immich-app/immich/issues/2931)
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 ...
