Cannot connect to new database after migration
project id: 6fbf03b2-6e85-491d-bda7-591922fe9dd7
The database's logs:
However, I cannot connect to it from my local mac or my railway app.
16 Replies
Project ID:
6fbf03b2-6e85-491d-bda7-591922fe9dd7
have you tried re-deploying the database?
Just re-deployed it and it is still not work
psql: error: connection to server at "roundhouse.proxy.rlwy.net" (xxx), port xxx failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The error raised by psql in my mac
I expected the migration should be completed in 5 minutes, now it is more than 30 minutes. What if I switch back to the legacy plugin?
the migration is still running?
It is completed, but the database can't be access
you can, just change the namespace of the reference variables for the database variables in the raw editor
You mean rollback to the legacy one is fine?
it can't hurt to try again, re-deploy the new database again for good measure
the legacy database is left fully in tact, you would only need to update the namespace on the database variables of your service
Postgres -> Legacy Postgres
I don't mind to send you the password of the database, could you help me find the reason why the database cannot be connected?
there are no any sensitive data
if you can't connect publicly then I likely won't be able to
I'm going to silent tag in @jr here, I know you're dnd, sorry
I have rollback to the legacy one, how should I re-migrate later. There is no
migrate
button now.If you delete the new database then the migrate button will re-appear
How are you trying to connect to your database? The database is loading fine in the UI. Can you try connecting with
psql
?
I suspect you might be hitting the network initialization timepsql: error: connection to server at "roundhouse.proxy.rlwy.net" (xxx), port xxx failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The error raised by psql in my mac
What is the command you are using. It should be
psql $DATABASE_URL
I am able to connect like this npI see, I can also connect to the database in a digital ocean droplet now, but not in my local env. Maybe it is because I'm using a VPN
Now my app can also connect to the database, so I believe the source of the error is 'network initialization time'
Which is around half an hour for me