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.
5 Replies
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
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
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?
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