2 months ago
My Postgres service (Postgres-K2ml) in project "thorough-flow" production environment is completely broken: - External proxy: ECONNRESET (trolley.proxy.rlwy.net:44400) - Internal network: ECONNREFUSED (postgres-k2ml.railway.internal:5432) - Railway's own database UI shows "read ECONNRESET" - Restarted services multiple times - no change - Can't connect from app at all Need urgent help - production site is down. All my data is in this database.
8 Replies
2 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
2 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • about 2 months ago
2 months ago
Can you send an image of what you see when you click on the Database tab within the Postgres service?
dev
Can you send an image of what you see when you click on the Database tab within the Postgres service?
2 months ago
Sure
Attachments
2 months ago
Alright thank you, I asked because it can sometimes give useful debug information for database issues but I see it's just experiencing the same ECONNRESET issue
In that case can you check if the Postgres deployment logs hold any clues as to what might be going on?
2 months ago
I found something critical. The Postgres-K2ml service is CORRECTLY configured:
- Source: ghcr.io/railwayapp-templates/postgres-ssl:17 (Railway's PostgreSQL template)
But the Deploy Logs show it's running Next.js instead:
- > model-id-dashboard@0.1.0 start /app - > PORT=3000 next start - ▲ Next.js 15.2.4
The service is configured as PostgreSQL but deploying/running the wrong container. This appears to be a Railway platform bug, the deployment system is running the wrong image/service. Settings screenshots attached.
Attachments
2 months ago
what the helly, that is so weird
where did you deploy that postgres service from? The icon doesn't appear to be the one Railway uses for their Postgres template
Also, does the Postgres database hold any important data? if not then I'd honestly recommend just deploying Postgres directly from Right Click -> Database -> Postgres
dev
what the helly, that is so weirdwhere did you deploy that postgres service from? The icon doesn't appear to be the one Railway uses for their Postgres templateAlso, does the Postgres database hold any important data? if not then I'd honestly recommend just deploying Postgres directly from Right Click -> Database -> Postgres
2 months ago
FIXED!
Problem identified and resolved:
My developer accidentally ran railway redeploy while the Railway CLI was pointed at the Postgres-K2ml service, which overwrote the PostgreSQL container with my Next.js application code.
I redeployed an older deployment that was correctly running the PostgreSQL Docker image (ghcr.io/railwayapp-templates/postgres-ssl). Database is now back online and working correctly. All data intact.
Thanks for your help - apologies for the user error.
Status changed to Solved dev • about 2 months ago