Prisma: Can't reach database server

nnevenPRO

a year 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

a year 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

a year ago

c4aab2e0-3c93-4c07-b086-ac5d458bd1b1


nnevenPRO

a year 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

a year ago

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


nnevenPRO

a year ago

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


a year ago

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


nnevenPRO

a year ago

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


nnevenPRO

a year ago

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


a year ago

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


nnevenPRO

a year 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

a year ago

I have a dev instance of my Railway project


nnevenPRO

a year ago

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


nnevenPRO

a year ago

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


a year ago

sounds good


nnevenPRO

a year ago

ok, ty for fast response as always!


nnevenPRO

a year ago

appreciate it


a year ago

no problem


lucasgarcia98HOBBY

a year ago

My project sometimes has the same problem


a year 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

a year ago

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


nnevenPRO

a year ago

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


nnevenPRO

a year ago

vs


nnevenPRO

a year ago

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


a year ago

where are you vpn'ing to?


nnevenPRO

a year ago

back to US


a year ago

does your vpn have a Singapore region?


nnevenPRO

a year ago

yeah it does,


nnevenPRO

a year ago

want me to test?


a year ago

yes please


nnevenPRO

a year ago

also works fine it seems


nnevenPRO

a year ago

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


nnevenPRO

a year ago

turned VPN off and it immediately freezes up + times out


nnevenPRO

a year ago

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


nnevenPRO

a year ago

rather than connect back to US from Asia


nnevenPRO

a year ago

idk I'm not a network expert lol


a year ago

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


nnevenPRO

a year ago

currently Indonesia


nnevenPRO

a year ago

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


nnevenPRO

a year ago

(and Railway region)


a year ago

can you send the specific nc command you used?


nnevenPRO

a year ago

nc -zv 35.213.135.65 40050


a year ago

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


a year ago

helo


a year ago

1265511594352185300


nnevenPRO

a year ago

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


a year ago

novpn


nnevenPRO

a year ago

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


a year ago

what hotel are you in bro


a year ago

check your isp rq

1265511772312305700


nnevenPRO

a year ago

1265511948032803000


a year ago

What the hell


nnevenPRO

a year ago

idk what any of this means lol


nnevenPRO

a year ago

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


a year ago

hotel firewall is a big possibility


a year ago

alex, you are staying at a residential house right?


a year ago

yeah


a year ago

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


a year ago

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


nnevenPRO

a year 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

a year ago

then we can mark issue resolved 🙂


a year ago

use singapore imo


a year ago

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


a year ago

i usually use the closest server that works


a year ago

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


nnevenPRO

a year ago

bet


nnevenPRO

a year ago

thanks yall


a year ago

@bebop btw what bpm are you using


a year ago

Vpn *


nnevenPRO

a year ago

proton


a year ago

Based


nnevenPRO

a year ago

switching to mulvad when my subscription ends lol


a year ago

Even more based


nnevenPRO

a year ago


a year ago

Buy it through a reseller like tailsvwle


a year ago

Then you get more utility for your lonely


a year ago

Money*


a year ago

Although I guess that defeats the purpose of using mullvad


nnevenPRO

a year ago

idk how to mark this as solved


nnevenPRO

a year ago

but yeah, thanks again


nnevenPRO

a year ago

appreciate the fast responses as always


a year ago

no problem!


nnevenPRO

a year ago

QQ while I have you


nnevenPRO

a year ago

I am starting to get SOC-2 compliance


nnevenPRO

a year ago

I really love Railway and have been long time user


nnevenPRO

a year ago

is your infra gonna be okay with compliance?


nnevenPRO

a year ago

or am I gonna have to migrate some 😭


nnevenPRO

a year ago

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


a year ago

you're pro right?


nnevenPRO

a year ago

yes


nnevenPRO

a year ago

and gonna start using Vanta to help get compliant


nnevenPRO

a year ago

still early in process


nnevenPRO

a year ago

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


nnevenPRO

a year ago

I hope I can stay and make it work 🤞


a year 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

a year ago

gotcha okay


nnevenPRO

a year ago

I will kick the can down the road for now


nnevenPRO

a year 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

a year ago

just some friendly customer feedback 😅


a year 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