21 days ago
Hello Railway Support Team,
I am experiencing a critical issue with my PostgreSQL service (Image: ghcr.io/railwayapp-templates/postgres-ssl:16.11).
Context: My environment consists of an Evolution API (WhatsApp bridge) connected to this Postgres instance. Earlier today, the Evolution API started reporting Connection Closed and conflict: replaced errors (Baileys/Socket error). Upon investigation, I found the Postgres service had reached its connection limit (99 active sessions).
Current Status:
I have successfully terminated the zombie sessions using
pg_terminate_backend.However, the Postgres service is now stuck. When I try to redeploy or restart, it stays in the "Processing" or "Building" state indefinitely without generating new logs.
I suspect a Volume Lock or a stuck
postmaster.pidfile on the persistent storage, but I cannot "Detach" the volume or force a clean boot without risking data loss.I have already corrected the environment variables (DATABASE_URL) and cleared the build cache, but the service remains unresponsive.
Attachments
0 Replies