Postgres crashed
gma-asia
HOBBYOP

3 months ago

Postgress always moved to "crashed" even though I have restarted and rredeployed it:

2025-09-11 16:11:10.358 UTC [2] LOG: starting PostgreSQL 16.10 (Debian 16.10-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit

2025-09-11 16:11:10.358 UTC [2] LOG: listening on IPv4 address "0.0.0.0", port 5432

2025-09-11 16:11:10.358 UTC [2] LOG: listening on IPv6 address "::", port 5432

2025-09-11 16:11:10.391 UTC [2] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

2025-09-11 16:11:10.439 UTC [25] LOG: database system was interrupted while in recovery at 2025-09-11 16:11:01 UTC

2025-09-11 16:11:10.439 UTC [25] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.

2025-09-11 16:11:10.958 UTC [25] LOG: database system was not properly shut down; automatic recovery in progress

2025-09-11 16:11:10.965 UTC [25] LOG: redo starts at 0/32CC1498

2025-09-11 16:11:15.002 UTC [25] LOG: redo done at 0/37FFE7C8 system usage: CPU: user: 0.07 s, system: 0.13 s, elapsed: 4.03 s

2025-09-11 16:11:15.045 UTC [25] FATAL: could not write to file "pg_wal/xlogtemp.25": No space left on device

2025-09-11 16:11:15.051 UTC [2] LOG: startup process (PID 25) exited with exit code 1

2025-09-11 16:11:15.051 UTC [2] LOG: terminating any other active server processes

2025-09-11 16:11:15.052 UTC [2] LOG: shutting down due to startup process failure

2025-09-11 16:11:15.062 UTC [2] LOG: database system is shut down

Solved

2 Replies

Railway
BOT

3 months ago



Status changed to Awaiting User Response Railway 3 months ago


Railway
BOT

2 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 2 months ago


Loading...