Closed PotatoPTT closed 1 month ago
I am also experiencing this issue
Same issue on micro services and postgres
Same issue on micro services and postgres
microservices it's no longer required release notes
This is not a bug. You are using running the DB without checksum. So do not use the new test.
You can however, backup the DB, then create a new one with the new env POSTGRES_INITDB_ARGS: '--data-checksums'. Then restore the DB.
You database will be recreated with checksum enabled and the new healthcheck will work.
This is not a bug. You are using running the DB without checksum. So do not use the new test.
You can however, backup the DB, then create a new one with the new env POSTGRES_INITDB_ARGS: '--data-checksums'. Then restore the DB.
You database will be recreated with checksum enabled and the new healthcheck will work.
How should we backup the DB, create a new one and restore it? Does anyone have a step by step guide?
This seems to work (backed up and restore) and the health check doesn't fail https://immich.app/docs/administration/backup-and-restore/#:~:text=The%20recommended%20way%20to%20backup,to%20use%20the%20pg_dumpall%20command.
This is not a bug. You are using running the DB without checksum. So do not use the new test.
You can however, backup the DB, then create a new one with the new env POSTGRES_INITDB_ARGS: '--data-checksums'. Then restore the DB.
You database will be recreated with checksum enabled and the new healthcheck will work.
I think this should be fixed. The health check shouldn’t report Postgres as unhealthy unless it has a reason to think it is. Adding a COALESCE would make it more elegant for existing databases (and generally for users who disable checksums).
It is written in the documentation FAQ I agree it deserves more visibility
https://immich.app/docs/FAQ#how-can-i-verify-the-integrity-of-my-database
The bug
In the latest dockercompose was added a healthcheck but in immich_postgres
SELECT SUM(checksum_failures) FROM pg_stat_database
returns NULL not 0, so the healthcheck fails every time For a temporary solution i just changed toSELECT COALESCE(SUM(checksum_failures), 0) FROM pg_stat_database
The OS that Immich Server is running on
Docker/Non Relatable
Version of Immich Server
v1.106.1
Version of Immich Mobile App
v1.106.1
Platform with the issue
Your docker-compose.yml content
Your .env content
Reproduction steps
Relevant log output
No response
Additional information
No response