Only public instead of private database URL is working

Hey, I have a problem, that the private url ${{Postgres.DATABASE_PRIVATE_URL}} could not be resolved any more, instead only ${{Postgres.DATABASE_URL}} is working as a reference to connect to the database. When using the private URL, the following error is reported:
could not translate host name "postgres.railway.internal" to address: Name or service not known
could not translate host name "postgres.railway.internal" to address: Name or service not known
Before my last deployment this we could use the PRIVATE_URL without any issues. I have seen some other issues which required to add a sleep at the beginning of the execution of the application, could this help?
28 Replies
Percy
Percy6mo ago
Project ID: 531444d2-18a9-4eed-88ec-772659191e1f
Brody
Brody6mo ago
yes please add the sleep 3
trust!NICKOL
trust!NICKOL6mo ago
it does not work
Brody
Brody6mo ago
please show me your new start command
trust!NICKOL
trust!NICKOL6mo ago
i have added it in the docker entrypoint
#!/bin/bash -e

sleep 3

# If running the rails server then create or migrate existing database
if [ "${1}" == "./bin/rails" ] && [ "${2}" == "server" ]; then
./bin/rails db:prepare
fi

exec "${@}"
#!/bin/bash -e

sleep 3

# If running the rails server then create or migrate existing database
if [ "${1}" == "./bin/rails" ] && [ "${2}" == "server" ]; then
./bin/rails db:prepare
fi

exec "${@}"
Brody
Brody6mo ago
let's see your dockerfile please
trust!NICKOL
trust!NICKOL6mo ago
it is 90 % the default rails dockerfile i only have to copy more files because i have to use some vendor gems
Brody
Brody6mo ago
is rails able to look up ipv6 addresses?
trust!NICKOL
trust!NICKOL6mo ago
good question ...
/usr/local/lib/ruby/3.2.0/socket.rb:231:in `getaddrinfo'

/usr/local/lib/ruby/3.2.0/socket.rb:231:in `foreach'

/usr/local/lib/ruby/3.2.0/socket.rb:635:in `tcp'
/usr/local/lib/ruby/3.2.0/socket.rb:231:in `getaddrinfo'

/usr/local/lib/ruby/3.2.0/socket.rb:231:in `foreach'

/usr/local/lib/ruby/3.2.0/socket.rb:635:in `tcp'
` this is where the error comes from, so nothing rails related but maybe ruby related i don't think this could be a problem, this is the latest release of ruby, the std library shows several methods for ipv6
Brody
Brody6mo ago
does your database have a volume
trust!NICKOL
trust!NICKOL6mo ago
yes should i restart the db?
Brody
Brody6mo ago
is private networking enabled can't hurt
trust!NICKOL
trust!NICKOL6mo ago
Ready to talk privately · it is saying i had to restart redis, postgres and my applications; it seems to work now again with private networking.
Brody
Brody6mo ago
awesome
trust!NICKOL
trust!NICKOL6mo ago
does not work again ... a restart does not help either additional the performance is now much worse than before my app is at least 10x slower now ... to be honest this is a total disaster for my business
dkrusenstrahle
dkrusenstrahle6mo ago
Same for me
Pepijn
Pepijn6mo ago
+1
Ray
Ray6mo ago
We're currently experiencing intermittent networking issues impacti...
We're currently experiencing intermittent networking issues impacting some services in europe-west4 - Incident details - Railway Status
Ray
Ray6mo ago
@Pepijn could you share a link to your impacted service please? @trust!NICKOL ^ too
trust!NICKOL
trust!NICKOL6mo ago
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
trust!NICKOL
trust!NICKOL6mo ago
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
trust!NICKOL
trust!NICKOL6mo ago
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
trust!NICKOL
trust!NICKOL6mo ago
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
Yoginth
Yoginth6mo ago
this is happening for me too from yesterdaym using public url for now which adds up 100ms delay 🙈
trust!NICKOL
trust!NICKOL6mo ago
sql which usually took 0.2 ms are at 20-30 ms now
JustJake
JustJake6mo ago
Hey y'all. We've rolled out a fix for the private networking issue (our DNS server didn't land on that new box for some reason) The public networking one we're in the process of rolling back. Please see the incident for updates
dkrusenstrahle
dkrusenstrahle6mo ago
ok