Help! Prod PostgreSQL crashes suddenly.
meyiapir
PROOP

a year ago

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 device`

0 Replies

meyiapir
PROOP

a year ago

86420017-534a-40eb-a1c5-2b1f738ee8ce


brody
EMPLOYEE

a year ago

  • set the service to the legacy runtime

  • set a service variable RAILWAY_SHM_SIZE_BYTES=134217728


Loading...