Lost postgres data on metal migrate
peebles
HOBBYOP

7 months ago

We lost pur data on the automatic deploy to metal. I got an email that said:

Deploy Crashed!

Uh oh. Your deployment for Volume Unpacker in Mindlytics crashed within the production environment.

I noticed a postgres-postdeply volume waiting to be mounted, but when trying to mount it, the only service option was my saas-frontend webservice, not my postgres service. I mounted it to saas-frontend anyway.

The postgres service has a "store-volume" volume.

I created some data on the emtpy postgres database after the loss, but that data is gone again. The postgres service was set to serverless, but I've unset that.

Solved

0 Replies

brody
EMPLOYEE

7 months ago

project id please



brody
EMPLOYEE

7 months ago

we restored the data in the database from before the data was lost.


peebles
HOBBYOP

7 months ago

How do I find my project ID? How do I access this lost data?


brody
EMPLOYEE

7 months ago

we already restored the data.


peebles
HOBBYOP

7 months ago

There is no old/previous data in my PG database.


brody
EMPLOYEE

7 months ago

how have you verified that?


peebles
HOBBYOP

7 months ago

By going to "Data" tab and looking at the data in the tables.


brody
EMPLOYEE

7 months ago

there is data in the tables though?


peebles
HOBBYOP

7 months ago

There is just a little that one of our users added since the migration. But there is a lot missing. What is the "postgres-postdeploy" volume off to the side that has a link to "mount" it?


peebles
HOBBYOP

7 months ago

1372690105864552400


brody
EMPLOYEE

7 months ago

that is the data that was added to the volume after the data loss, the data in the database currently is what was in the database prior to the data loss


peebles
HOBBYOP

7 months ago

No, sorry. There was a lot of data, and it is no longer there. I started getting complaints just after the migration. Then I loaded up the database with some demo data, which disappeared again after what looked like an auto-deploy of the stack. My demo data is no longer there.


brody
EMPLOYEE

7 months ago

the data in the volume is what was in the database before the migration.


peebles
HOBBYOP

7 months ago

There were many users in this table for example:

1372691421147955200


brody
EMPLOYEE

7 months ago

we restored that data to what it was prior to the migration.


peebles
HOBBYOP

7 months ago

"the data in the volume is what was in the database before the migration." so postgress-postdeploy is my old data?


brody
EMPLOYEE

7 months ago

-postdeploy is the data post migration


peebles
HOBBYOP

7 months ago

Well, I think we'll be leaving for AWS. But thanks for looking into it.


brody
EMPLOYEE

7 months ago

no problem! rest assured, the data was put back as we found it.


peebles
HOBBYOP

7 months ago

What can I say? It ain't there.


brody
EMPLOYEE

7 months ago

the data that is there is the data that was there prior to the migration.


peebles
HOBBYOP

7 months ago

My database was empty prior to migration? You think I missed that somehow? That my user's missed that fact? I guess anything is possible now-a-days.


brody
EMPLOYEE

7 months ago

I cannot speak to what specific data you had in your tables prior to the migration.


kiran-sg
HOBBY

7 months ago

Hi @Brody @Ray
I am also facing similar issue in my service, where the Postgres service got redeployed after an auto migration to metal. All the tables are lost. I tried roll back after going through the documentations, still no tables are there.
Can you please restore my previous data which were there before the auto migration happened.
The application is running in production. All the users are impacted, please help.
Project ID: 8ab109a3-6419-41b7-8aa3-0140b41337ed


brody
EMPLOYEE

7 months ago

please open your own thread


brody
EMPLOYEE

7 months ago

!s


Status changed to Solved brody 7 months ago


Loading...