Error: P1001: Can't reach database server at xxxx, Please make sure your database server ... | Railway | Page 1

pale glacier Jul 12, 2023, 10:03 AM

#

I'm using PostgreSQL

Basically, every time I deploy my application (a simple express app using Prisma), this error is triggered. Sometimes it takes two to three minutes to successfully connect, and other times it continues until the application crashes. I've already switched databases once, but the issue remains the same. It's incredibly frustrating. (I'm writing this post now because half an hour has passed, and I still haven't successfully deployed.)

I have several applications deployed on Railway, but this is the first time I've encountered this problem.

Previously, I had a Developer plan account, but now it has been changed to Hobby. I'm not sure if that is related to the issue.

Here is my ServiceID: b5e0ccd6-5868-4f37-aefa-01fa0a8dda6b.

heavy roostBOT Jul 12, 2023, 10:03 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

west vigilBOT Jul 12, 2023, 10:03 AM

#

Project ID: b5e0ccd6-5868-4f37-aefa-01fa0a8dda6b

tall wadi Jul 12, 2023, 10:06 AM

#

Looks like it has connected successfully now?

pale glacier Jul 12, 2023, 10:07 AM

#

tall wadi Looks like it has connected successfully now?

Yeah, finally. But the point is, each time when I deploy the application, I'll suffer this error...

#

I'm not sure when it will be deployed successfully.

#

maybe you can check how many times I restarted😂

tall wadi Jul 12, 2023, 10:10 AM

#

Wanna deploy again for me? I want to see the error while it happens.

#

Because I don't think it's from our side as your DB seems fine.

pale glacier Jul 12, 2023, 10:11 AM

#

Okay, redeploying

tall wadi Jul 12, 2023, 10:14 AM

#

So I see the error in your logs but the database is fine.

#

You can validate this yourself by connecting directly to the DB.

pale glacier Jul 12, 2023, 10:15 AM

#

tall wadi So I see the error in your logs but the database is fine.

So the problem is why Can't reach database server, because of the network between the application server and the database?

tall wadi Jul 12, 2023, 10:16 AM

#

I am not sure, I'd imagine it's an application issue.

pale glacier Jul 12, 2023, 10:17 AM

#

Okay, I'll take a look... I hope it is an application issue so that I can solve it by myself

#

Btw, how can I change my plan? I can only cancel my plan in 'Manage Plan'

tall wadi Jul 12, 2023, 10:36 AM

#

pale glacier Btw, how can I change my plan? I can only cancel my plan in 'Manage Plan'

What do you want to change it to?

#

You're already on the Hobby plan.

pale glacier Jul 12, 2023, 10:39 AM

#

Pro. Once the regions feature goes live

tall wadi Jul 12, 2023, 10:41 AM

#

pale glacier Pro. Once the regions feature goes live

We're working on improving that flow this month. For now though, you can create a new team and sign up for the pro plan.

#

If you click on your avatar on the top right, you'll see the "Create a Team" option.

full helm Oct 6, 2023, 11:53 PM

#

@pale glacier did you figure out the fix? im having the exact same issue

full helm Oct 9, 2023, 11:54 AM

#

fix here:
https://discord.com/channels/713503345364697088/1159975463389761638

deft sigil Oct 11, 2023, 5:07 AM

#

Having the same here from yesterday!
I've tried multiple times, even migrations ran successfully and i was able to connect the Db when running the web server locally.
Is everything OK from railway side?

Project ID: 091bd9c2-1eea-4e89-a6a6-a71528d9ca60

#Error: P1001: Can't reach database server at xxxx, Please make sure your database server ...