Problems with databases in preview environments?
mbirkegaard
PROOP

2 years ago

Has there been any problems with databases and/or networking in preview environments today?

I'm unable to connect to both Mongo and Postgres dbs in a preview environment, both from services in the environment and from the outside through proxies.

The corresponding dbs in my staging environment + a fresh clone of the staging environment work as expected.

View Deploy details

ⓘ Deployment information is only viewable by project members and Railway employees.

16 Replies

brody
EMPLOYEE

2 years ago

What is the state of the database deployments?

mbirkegaard
PROOP

2 years ago

The UI reports them as successful

brody
EMPLOYEE

2 years ago

Right but what is the state.

mbirkegaard
PROOP

2 years ago

I'm not sure what you're asking. The UI says the databases deploys are active and successful. The logs show them running.The mongodb container has

Auth metrics report

Failed to authenticate

Failed to authenticate

in the logs, so it looks like it's receiving the connection attempt from the service

brody
EMPLOYEE

2 years ago

Did you try to change the password via the environment variables?

mbirkegaard
PROOP

2 years ago

Nope.

Just made a clone of the preview environment and there things are working: https://railway.app/project/a0439ab9-40f5-4be7-8ff2-2be95410de27/service/3d3cac7b-fe9c-42f5-917b-2ae604d10113?id=74100058-3b96-4974-9671-7d3df0e600ab

(This is the same service as linked above)

brody
EMPLOYEE

2 years ago

Are you aware that the databases in PR environments would have different passwords than the databases in the base environment?

mbirkegaard
PROOP

2 years ago

I haven't (ever) touched any passwords for databases. I always just use the derived connection strings and this is the first time a preview environment has crashed in this way.

brody
EMPLOYEE

2 years ago

Are you making sure to use reference variables?

mbirkegaard
PROOP

2 years ago

Yes. And as mentioned above I made a clone of the preview environment here and everything works as it should there...

brody
EMPLOYEE

2 years ago

Moderators can not view your project.

The issue is that you are likely using incorrect variables.

mbirkegaard
PROOP

2 years ago

Moderators can not view your project.

Ah. I see. I thought you were a Railway employee. Apologies!

The issue is that you are likely using incorrect variables.

Why would the clone work then?

mbirkegaard
PROOP

2 years ago

Yeah, made a new preview environment and synced it with the bad one. Same code, same configuration for everything and it works, so the issue is unlikely to be incorrect variables.

mbirkegaard
PROOP

2 years ago

I think I just have to conclude that the preview environment got busted and leave it at that.

Thanks for the effort, Brody!

Loading...