Frequent timeouts in the last 24 hours between my backend + Postgres
saarimz
PROOP

8 months ago

Nothing changed on my end, all of a sudden the Postgres seems to not hold connections properly, our backend keeps having 500s, we are a ticketing app and its killing our webhooks and everything else and causing severe reliability issues.

Solved

5 Replies

Railway
BOT

8 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!


8 months ago

For the itm-backend, you're making requests to the VECTOR_DATABASE_URL right?

If so, you're round tripping ALL the way back to GCP's edge, then to our metal edge

Could you replace that public URL (viaduct.rlwy) with a private URL (postgres.railway.internal:5432)? It'll also save you on bandwidth


Status changed to Awaiting User Response Railway 8 months ago


jake

For the itm-backend, you're making requests to the VECTOR_DATABASE_URL right?If so, you're round tripping ALL the way back to GCP's edge, then to our metal edgeCould you replace that public URL (viaduct.rlwy) with a private URL (postgres.railway.internal:5432)? It'll also save you on bandwidth

saarimz
PROOP

8 months ago

hey jake its actually the DATABASE_URL (we don't really use the vector db for critical operations, just as a vector store for some of our LLM stuff). The DATABASE_URL is pointed to ${{Postgres.DATABASE_PRIVATE_URL}}.

here are the connection pool settings (I use Prisma)

https://gist.github.com/saarimz/0a5b27023ffc300fbf2262438114108f

I've been trying to optimize the connection pool to get the errors down but to no avail


Status changed to Awaiting Railway Response Railway 8 months ago


8 months ago

Gotchya. I've re-enabled the GCP region. Please let me know if that works for you!


Status changed to Awaiting User Response Railway 8 months ago


Hey Saarim,

Relaying here as Rahul escalated your ask internally, you still have time with him on the board but wondering if you have gone ahead and migrated back to cloud?


Railway
BOT

7 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 7 months ago


Loading...