Help! Prod PostgreSQL crashes suddenly.
The database suddenly started to issue such messages, there were no new commits, the load did not grow before that for 2 months everything worked fine.
Logs:
WHERE generations.tg_id = $1::VARCHAR AND (generations.status = $2::VARCHAR OR generations.status = $3::VARCHAR OR generations.status = $4::VARCHAR OR generations.status = $5::VARCHAR)
2024-07-05 16:32:41.106 UTC [294] ERROR: could not resize shared memory segment "/PostgreSQL.2946584502" to 184928 bytes: No space left on deviceSolution:Jump to solution
- set the service to the legacy runtime
- set a service variable
RAILWAY_SHM_SIZE_BYTES=134217728...3 Replies