Prisma: Can't reach database server
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': 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 @Brody would be greatly appreciated, thank you!Stack Overflow
M1 Related! - Prisma: Can't reach database server at
database:5432Since I have moved to the new Apple Silicon architecture my docker setup with nextjs and postgres is not working anymore. The database inside the docker cannot be found by the nextjs server where I...
56 Replies
Project ID:
c4aab2e0-3c93-4c07-b086-ac5d458bd1b1Railway 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.
c4aab2e0-3c93-4c07-b086-ac5d458bd1b1
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
hmm okay, so you think this is specific to Prisma then?
tomorrow I could try interacting with the db directly outside of Prisma and see how performance/reliability is
it could be an issue with the network with your internet?
just wondering if seen others run into this issue before (specifically with Prisma) and there is a common fix
ok yeah it's getting late here so I will do a bit more testing tmrw
the only issues I've seen in this regard would be networking issues on the users side of things
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
I have a dev instance of my Railway project
I will migrate that and see if it makes a noticeable difference
If it does though that would confirm its a Railway issue and nothing with my personal network or Prisma
sounds good
ok, ty for fast response as always!
appreciate it
no problem
My project sometimes has the same problem
I tried running
nc command with both VPN off and on, seems to make a difference and works when its on
nc: connectx to 35.213.135.65 port 40050 (tcp) failed: Operation timed out
vs
Connection to 35.213.135.65 port 40050 [tcp/*] succeeded!where are you vpn'ing to?
back to US
does your vpn have a Singapore region?
yeah it does,
want me to test?
yes please
also works fine it seems
Connection to 35.213.135.65 port 40050 [tcp/*] succeeded!
turned VPN off and it immediately freezes up + times out
I guess its better for me to stay on Singpapore and let railway edge handle it for me?
rather than connect back to US from Asia
idk I'm not a network expert loli know you said youre in asia, but if its all right with you could you be a little more specific?
currently Indonesia
and will be going to Japan soon, before going back to US east where my company is based
(and Railway region)
can you send the specific nc command you used?
nc -zv 35.213.135.65 40050@alex - are you still in Indonesia, can you run that command for me? without a VPN
helo
@Brody any recommendations on what setup I should be using for best performance while in Asia? ie VPN to Singapore or US etc
novpn
I guess we determined its something with my hotel network I assume
what hotel are you in bro
check your isp rq
What the hell
idk what any of this means lol
I just want to have smooth experience when devving while abroad 🙂
Solution
hotel firewall is a big possibility
alex, you are staying at a residential house right?
yeah
our internet goes through a different pipe than the hotel, I believe
I can try hotel wifi but that means i have to go downstairs
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
then we can mark issue resolved 🙂
use singapore imo
use the closest server to yourself to make the internet experience more bearable
i usually use the closest server that works
yeah id go with that too, google's continental datacenter connection is likely faster than your vpn
bet
thanks yall
@bebop btw what bpm are you using
Vpn *
proton
Based
switching to mulvad when my subscription ends lol
Even more based
:spongevibe:
Buy it through a reseller like tailsvwle
Then you get more utility for your lonely
Money*
Although I guess that defeats the purpose of using mullvad
idk how to mark this as solved
but yeah, thanks again
appreciate the fast responses as always
no problem!
QQ while I have you
I am starting to get SOC-2 compliance
I really love Railway and have been long time user
is your infra gonna be okay with compliance?
or am I gonna have to migrate some ðŸ˜
its not pressing but inevitable for my company as we deal with financial data
you're pro right?
yes
and gonna start using Vanta to help get compliant
still early in process
jw if other customers of urs have been able to get compliant etc without needing to migrate
I hope I can stay and make it work 🤞
theres this that was posted 4 months ago - https://help.railway.app/feedback/2024-q2-provisional-roadmap-6cdae7dc
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 - https://help.railway.app/questions
gotcha okay
I will kick the can down the road for now
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
just some friendly customer feedback 😅
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