Mounted data is inaccessible
zhdanovme
PROOP

9 months ago

this volume has 1GB of data, but when i got into /var/lib/postgresql/data of related serivce there's no my data.

Solved

9 Replies

9 months ago

Sorry, what's the issue here?


Status changed to Awaiting User Response Railway 9 months ago


zhdanovme
PROOP

9 months ago

the volume seems to be not mounting - no data but the size of the volume is almost 1gb


Status changed to Awaiting Railway Response Railway 9 months ago


9 months ago

When did you observe this issue to have started occuring?


Status changed to Awaiting User Response Railway 9 months ago


zhdanovme
PROOP

9 months ago

After we detached volume from pg-service and attached to pgvector-service.

On staging it worked perfectly, volume was moved to new servcie.

But on production, the data haven't appeared on pg-vector service.

We restored from backup the data and attached to pg-service, but the data is empty, volume is 1GB size.
We sshed to mounted folder and mounted folder has 42mb size.


Status changed to Awaiting Railway Response Railway 9 months ago


You mentioned that this showed when you unmount. PG creates a new DB on the folder that is mounted to the new instance, just because it's PG doesn't mean that the data nor the volume is compatible.

You will need to reattach to the old mount point on the old DB to see your data.


Status changed to Awaiting User Response Railway 9 months ago


zhdanovme
PROOP

9 months ago

We have reattached to the old mount point on the old DB and dont see the data.


Status changed to Awaiting Railway Response Railway 9 months ago


Then I wouldn't know when/where your data is. According to the vol. the 1 GB of data is indeed there. You will need to see where it's at for PG to recognize the data.


Status changed to Awaiting User Response Railway 9 months ago


zhdanovme
PROOP

9 months ago

Same migration process went flawless on stage envs (exact same setup) but corrupted on production, please ask your devops/admins to reveal where the data is, issue is on the railway side.


Status changed to Awaiting Railway Response Railway 9 months ago


That's not the error that seems to be in place. With that said, Railway's databases aren't managed, so if the DB wasn't gracefully shutdown then unfortunately that is an issue that needs to be resolved by you and your team.


Status changed to Awaiting User Response Railway 9 months ago


Railway
BOT

7 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 7 months ago


Loading...