Postgress DB turned faulty?
After updating to 139.4 my next backup failed. The issue is in the pg_dumpall step. Does this mean I need to restore from backup or can this be salvaged?
Pure chance this happened after the backup or is anyone facing the same issue?
docker exec immich_postgres sh -c \ 'pg_dumpall --clean --if-exists --username=postgres > /tmp/immich.sql'
pg_dump: WARNING: page verification failed, calculated checksum 51456 but expected 24139 pg_dump: error: Dumping the contents of table "smart_search" failed: PQgetResult() failed. pg_dump: error: Error message from server: ERROR: invalid page in block 1104 of relation base/16384/17309 pg_dump: error: The command was: COPY public.smart_search ("assetId", embedding) TO stdout; pg_dumpall: error: pg_dump failed on database "immich", exiting
Pure chance this happened after the backup or is anyone facing the same issue?
docker exec immich_postgres sh -c \ 'pg_dumpall --clean --if-exists --username=postgres > /tmp/immich.sql'
pg_dump: WARNING: page verification failed, calculated checksum 51456 but expected 24139 pg_dump: error: Dumping the contents of table "smart_search" failed: PQgetResult() failed. pg_dump: error: Error message from server: ERROR: invalid page in block 1104 of relation base/16384/17309 pg_dump: error: The command was: COPY public.smart_search ("assetId", embedding) TO stdout; pg_dumpall: error: pg_dump failed on database "immich", exiting
