Postgres database legacy migration stuck in "migrating data" | Railway | Page 1

manic torrent Dec 9, 2023, 7:15 AM

#

for 45 minutes now. The db is not that big, pg_dump and import would take a couple of minutes.
Also noticed that the migration is adding to my usage. I am not sure I can interrupt the process without losing data - but then i don't also want to hit any overage charges.

lime patioBOT Dec 9, 2023, 7:15 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

gusty sundialBOT Dec 9, 2023, 7:15 AM

#

Project ID: 4501ee61-00b6-421b-afd6-edae65fd1423

manic torrent Dec 9, 2023, 7:16 AM

#

4501ee61-00b6-421b-afd6-edae65fd1423

dusk jungle Dec 9, 2023, 7:28 AM

#

you can cancel it, there's extremely low risk of data loss

manic torrent Dec 9, 2023, 7:31 AM

#

what should the process be? Do I cancel, stop and remove the new pg db and migration - and repeat?

dusk jungle Dec 9, 2023, 7:31 AM

#

correct

#

but, it sounds like you're familiar with pg_dump and pg_restore? if the auto migrations fails again you could spin up a new database yourself and do the dump and restore manually?

manic torrent Dec 9, 2023, 7:32 AM

#

how do I cancel the migration though. I clicked on the legacy service - but there is no option to cancel.

#

do I just hit restart database?

dusk jungle Dec 9, 2023, 7:33 AM

#

I've actually not ran this process myself, can you show me some screenshots of what you're looking at?

manic torrent Dec 9, 2023, 7:34 AM

#

this is what shows up on the screen when I click on migration status

dusk jungle Dec 9, 2023, 7:34 AM

#

maybe try deleting the new database

manic torrent Dec 9, 2023, 7:36 AM

#

you are confident - I wont mess up my db? 😨

dusk jungle Dec 9, 2023, 7:36 AM

#

as long as you don't delete the wrong database

#

you'd also want to delete the migration service

manic torrent Dec 9, 2023, 7:51 AM

#

ok - completed manually now. I had a backup so wasnt worried about losing data. Thanks for the guidance. I noticed now that the new PG has a volume/disk attached. The legacy did not. Does this mean I will get charged for disk usage as well as memory usage? Previously only memory was being used/charged for.

dusk jungle Dec 9, 2023, 7:52 AM

#

thats correct

#

$0.25 / GB

manic torrent Dec 9, 2023, 7:55 AM

#

interesting.. do you know if by any chance memory usage will go down?

dusk jungle Dec 9, 2023, 8:03 AM

#

whats it at right now? you could always restart the database

manic torrent Dec 9, 2023, 8:04 AM

#

I was hovering at around 700Mb in the legacy - still about the same in the new one.

dusk jungle Dec 9, 2023, 8:05 AM

#

oh then no its not gonna go down

manic torrent Dec 9, 2023, 8:06 AM

#

its not a big amount - but it means i will be paying slightly more going forward. Its not much - but still hurts a bit!

#

thanks!

dusk jungle Dec 9, 2023, 8:12 AM

#

youd said both databases used around 700mb of memory, so in terms of that you will be paying the same

#

whats your disk usage at?

manic torrent Dec 9, 2023, 8:15 AM

#

about a Gb

#

So thats the incremental amount.

dusk jungle Dec 9, 2023, 8:16 AM

#

are you pro?

manic torrent Dec 9, 2023, 8:16 AM

#

no still on hobby

#

no worries. I have to drop now. will check in later. thanks again

dusk jungle Dec 9, 2023, 8:18 AM

#

sounds good, only asked since discord says youre not on either hobby or pro and was wondering how you where able to fill a disk with 1gb of data 🤣

#Postgres database legacy migration stuck in "migrating data"