usbrit_
IImmich
•Created by usbrit_ on 12/10/2024 in #help-desk-support
Unraid-Postgres database failing to start.
A couple of days ago Immich stopped working and I have traced it to a Postrgres 14 issue. logs say:
PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-12-10 11:05:00.153 PST [1] LOG: starting PostgreSQL 14.15 (Debian 14.15-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-12-10 11:05:00.154 PST [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-12-10 11:05:00.155 PST [1] LOG: listening on IPv6 address "::", port 5432
2024-12-10 11:05:00.337 PST [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-12-10 11:05:00.502 PST [25] LOG: database system was shut down at 2024-12-05 03:55:00 PST
2024-12-10 11:05:00.502 PST [25] LOG: invalid primary checkpoint record
2024-12-10 11:05:00.502 PST [25] PANIC: could not locate a valid checkpoint record
2024-12-10 11:05:00.503 PST [1] LOG: startup process (PID 25) was terminated by signal 6: Aborted
2024-12-10 11:05:00.503 PST [1] LOG: aborting startup due to startup process failure
2024-12-10 11:05:00.513 PST [1] LOG: database system is shut down
Any suggestions to recover the database please?
8 replies
IImmich
•Created by usbrit_ on 12/2/2024 in #help-desk-support
unraid database authorization issue
Hi, on compose up I'm getting the following error in the immich_server log:
[Nest] 17 - 12/02/2024, 9:52:39 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)...
error: password authentication failed for user "postgres"
at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Have tried everything i can think of, including different users.
Thanks for the help
26 replies