Prisma: Can't reach database server

nnevenPRO

9 months ago

Hi, I am using Prisma + Next.js deployed on Vercel, and communicating over public network with my Railway SQL database. This has been working fine for me, however I started traveling overseas and now I am having a hard time developing or communicating with the database at all because I constantly receive Can't reach database server at '[roundhouse.proxy.rlwy.net](roundhouse.proxy.rlwy.net)': 40050. I have already looked through this Discord for solutions and implemented what was suggested here: https://stackoverflow.com/questions/68476229/m1-related-prisma-cant-reach-database-server-at-database5432, which helped a little bit but still inconsistent with my ability to connect + query. I believe this issue is very common for me now as I am in Asia and communicating with my db that is located in US East. How can I resolve or fix this? Is there something else I can do with Prisma to remedy this issue? My belief and reason for this post is that the issue is coming from Railway's ability to handle and serve requests that are across the globe and not near the region where most of my usage normally happens. Any help <@539512869780455445> would be greatly appreciated, thank you!

0 Replies

9 months ago

Railway is very good at handling requests from around the globe as they use edge proxies, you being in Asia means your request is handled by the edge proxy in Singapore and then routed internally to the us-east region.

but you can try to move the database to the Singapore region to reduce latency even further.


nnevenPRO

9 months ago

c4aab2e0-3c93-4c07-b086-ac5d458bd1b1


nnevenPRO

9 months ago

most of my customers are in US and east coast so that wouldn't make sense as solution, I just need to figure out how to connect + query consistently with Prisma when I am working abroad for the next few weeks


nnevenPRO

9 months ago

hmm okay, so you think this is specific to Prisma then?


nnevenPRO

9 months ago

tomorrow I could try interacting with the db directly outside of Prisma and see how performance/reliability is


9 months ago

it could be an issue with the network with your internet?


nnevenPRO

9 months ago

just wondering if seen others run into this issue before (specifically with Prisma) and there is a common fix


nnevenPRO

9 months ago

ok yeah it's getting late here so I will do a bit more testing tmrw


9 months ago

the only issues I've seen in this regard would be networking issues on the users side of things


nnevenPRO

9 months ago

but generally unable to develop my Next.js project because db connections fail consistently, but network wise I am able to take Zoom calls etc no problem


nnevenPRO

9 months ago

I have a dev instance of my Railway project


nnevenPRO

9 months ago

I will migrate that and see if it makes a noticeable difference


nnevenPRO

9 months ago

If it does though that would confirm its a Railway issue and nothing with my personal network or Prisma


9 months ago

sounds good


nnevenPRO

9 months ago

ok, ty for fast response as always!


nnevenPRO

9 months ago

appreciate it


9 months ago

no problem


lucasgarcia98HOBBY

9 months ago

My project sometimes has the same problem


9 months ago

to clarify, are you receiving this error when connecting to the database from your nextjs deployment (on railway) or from your development server (on your computer)


nnevenPRO

9 months ago

I tried running nc command with both VPN off and on, seems to make a difference and works when its on


nnevenPRO

9 months ago

nc: connectx to 35.213.135.65 port 40050 (tcp) failed: Operation timed out


nnevenPRO

9 months ago

vs


nnevenPRO

9 months ago

Connection to 35.213.135.65 port 40050 [tcp/*] succeeded!


9 months ago

where are you vpn'ing to?


nnevenPRO

9 months ago

back to US


9 months ago

does your vpn have a Singapore region?


nnevenPRO

9 months ago

yeah it does,


nnevenPRO

9 months ago

want me to test?


9 months ago

yes please


nnevenPRO

9 months ago

also works fine it seems


nnevenPRO

9 months ago

Connection to 35.213.135.65 port 40050 [tcp/*] succeeded!


nnevenPRO

9 months ago

turned VPN off and it immediately freezes up + times out


nnevenPRO

9 months ago

I guess its better for me to stay on Singpapore and let railway edge handle it for me?


nnevenPRO

9 months ago

rather than connect back to US from Asia


nnevenPRO

9 months ago

idk I'm not a network expert lol


9 months ago

i know you said youre in asia, but if its all right with you could you be a little more specific?


nnevenPRO

9 months ago

currently Indonesia


nnevenPRO

9 months ago

and will be going to Japan soon, before going back to US east where my company is based


nnevenPRO

9 months ago

(and Railway region)


9 months ago

can you send the specific nc command you used?


nnevenPRO

9 months ago

nc -zv 35.213.135.65 40050


9 months ago

@alex - are you still in Indonesia, can you run that command for me? without a VPN


9 months ago

helo


9 months ago

1265511594352185300


nnevenPRO

9 months ago

@Brody any recommendations on what setup I should be using for best performance while in Asia? ie VPN to Singapore or US etc


9 months ago

novpn


nnevenPRO

9 months ago

I guess we determined its something with my hotel network I assume


9 months ago

what hotel are you in bro


9 months ago

check your isp rq

1265511772312305700


nnevenPRO

9 months ago

1265511948032803000


9 months ago

What the hell


nnevenPRO

9 months ago

idk what any of this means lol


nnevenPRO

9 months ago

I just want to have smooth experience when devving while abroad 🙂


9 months ago

hotel firewall is a big possibility


9 months ago

alex, you are staying at a residential house right?


9 months ago

yeah


9 months ago

our internet goes through a different pipe than the hotel, I believe


9 months ago

I can try hotel wifi but that means i have to go downstairs


nnevenPRO

9 months ago

ok but while I'm here and need VPN to fix, should I just connect to any local asia location and let railway edge handle requests? or connect back to US servers


nnevenPRO

9 months ago

then we can mark issue resolved 🙂


9 months ago

use singapore imo


9 months ago

use the closest server to yourself to make the internet experience more bearable


9 months ago

i usually use the closest server that works


9 months ago

yeah id go with that too, google's continental datacenter connection is likely faster than your vpn


nnevenPRO

9 months ago

bet


nnevenPRO

9 months ago

thanks yall


9 months ago

@bebop btw what bpm are you using


9 months ago

Vpn *


nnevenPRO

9 months ago

proton


9 months ago

Based


nnevenPRO

9 months ago

switching to mulvad when my subscription ends lol


9 months ago

Even more based


nnevenPRO

9 months ago


9 months ago

Buy it through a reseller like tailsvwle


9 months ago

Then you get more utility for your lonely


9 months ago

Money*


9 months ago

Although I guess that defeats the purpose of using mullvad


nnevenPRO

9 months ago

idk how to mark this as solved


nnevenPRO

9 months ago

but yeah, thanks again


nnevenPRO

9 months ago

appreciate the fast responses as always


9 months ago

no problem!


nnevenPRO

9 months ago

QQ while I have you


nnevenPRO

9 months ago

I am starting to get SOC-2 compliance


nnevenPRO

9 months ago

I really love Railway and have been long time user


nnevenPRO

9 months ago

is your infra gonna be okay with compliance?


nnevenPRO

9 months ago

or am I gonna have to migrate some 😭


nnevenPRO

9 months ago

its not pressing but inevitable for my company as we deal with financial data


9 months ago

you're pro right?


nnevenPRO

9 months ago

yes


nnevenPRO

9 months ago

and gonna start using Vanta to help get compliant


nnevenPRO

9 months ago

still early in process


nnevenPRO

9 months ago

jw if other customers of urs have been able to get compliant etc without needing to migrate


nnevenPRO

9 months ago

I hope I can stay and make it work 🤞


9 months ago

theres this that was posted 4 months ago -
> Compliance Trust Center
>
> Because we were busy setting up our on-prem locations, currently we manually provide documents and bridge reports to customers needing to fulfill their SOC2 obligations. We are now pursuing our audit in earnest, and while we work to meet our auditors standard- we plan to make more of our security posture and architecture to our Business Class customers in an improved fashion.

with the wording used you may need to be on their enterprise plan, you can ask for more info by opening a private thread here -


nnevenPRO

9 months ago

gotcha okay


nnevenPRO

9 months ago

I will kick the can down the road for now


nnevenPRO

9 months ago

def something to take care of Railway's end, if you want to support real business + enterprise customers outside of projects etc I think its a non-negotiable


nnevenPRO

9 months ago

just some friendly customer feedback 😅


9 months ago

its just at a bit of an odd time right now with the transfer to bare metal, but be sure to open that private thread so you can talk to the team about it


Prisma: Can't reach database server - Railway Help Station