Data loss
Hey!
Something bad happened today with our Postgres service. Looks like we lost some data for the last 3-4 weeks.
First, our nodejs app could not connect to the db, (we haven't any updates recently). Then some queries could not be run and event got errors like segmentation fault (core dumped). Postgres sometimes was saying 'could not receive data from client: Connection reset by peer'
Some data got lost. I know that because only I can delete it through sql queries.
It hurts. Can anyone help with that?
Project Id — 79365ff8-3688-440c-b45d-69714c7add33
Service Id — bf18cbdb-fa37-4999-aadb-c9391bc63611
Solution:Jump to solution
Thanks a lot, did re-inititiation migration from here https://docs.railway.app/guides/database-migration-guide#re-initiating-migration
That helped. Thanks!...
Railway Docs
Migrating from Legacy Plugins to Database Services | Railway Docs
Documentation for Railway
4 Replies
Project ID:
79365ff8-3688-440c-b45d-69714c7add33,bf18cbdb-fa37-4999-aadb-c9391bc63611was a legacy database plugin involved?
Sounds like it. Please delete the new migrated database, then remigrate your legacy database. This time, make sure to change your service’s env variables to point to the new database using reference variables
this happened because you skipped a step while migrating, you should have changed your environment variables when you migrated your database in the first place
Solution
Thanks a lot, did re-inititiation migration from here https://docs.railway.app/guides/database-migration-guide#re-initiating-migration
That helped. Thanks!
Railway Docs
Migrating from Legacy Plugins to Database Services | Railway Docs
Documentation for Railway