R
Railway•11mo ago
Dill

postgres migrate data failed to migrate

Was just trying to migrate my postgres db to latest version and the migration failed
No description
37 Replies
Percy
Percy•11mo ago
Project ID: d1ff40c5-a9bf-4677-a3e0-f9a1c3d20b81
Dill
Dill•11mo ago
d1ff40c5-a9bf-4677-a3e0-f9a1c3d20b81 Need help ASAP if possible - have live users and concerned about uptime
Brody
Brody•11mo ago
@Ray - migration still failing
Dill
Dill•11mo ago
got this
Dill
Dill•11mo ago
No description
Dill
Dill•11mo ago
looks like a disk space issue i do think this db is rather large
Brody
Brody•11mo ago
youre on hobby?
Dill
Dill•11mo ago
yes im down to upgrade if possible i already spend quite a bit a month fyi - i dont see an easy way to upgrade my plan as a user
Brody
Brody•11mo ago
going forward you'd want to be on pro since you likely are not running a hobby workload, but right now we will wait for ray and hopefully he will be able to push the migration along by temp bumping the volume size
Dill
Dill•11mo ago
No description
Dill
Dill•11mo ago
No description
Dill
Dill•11mo ago
i see no button anywhere to upgrade ty! 🙌
Brody
Brody•11mo ago
Brody
Brody•11mo ago
Dill
Dill•11mo ago
ahh my bad i overlooked it in a hurry thanks for sharing!
Brody
Brody•11mo ago
dont have any eta for rays arrival so upgrading to pro may be the faster option if youd like
Dill
Dill•11mo ago
was just looking at details - does pro plan also include $20 usage per month?
Brody
Brody•11mo ago
nope 😦
Dill
Dill•11mo ago
ah i see hmm i think it may not be feasible for me at current stage to go for pro plan yet don't get me wrong - i'm super happy customer and endorse railway to all my friends and on twitter too! i just don't have a need for the higher workloads / more RAM yet given my business i guess the only constraint i'm facing is the DB disk size for that one project
Brody
Brody•11mo ago
its not so much about upgrading to get 32 vcpu and 32 gb of mem, its more so based on the workload youre running, if you have users and are generating revenue, then thats generally a pro workload but in your case youd also be upgrading to get the 50gb volumes
jr
jr•11mo ago
Hey there, I can help you migrate. It is indeed failing because it is running out of disk space I can increase the amount of available space in this specific database so that you can get migrated if that works for you
Dill
Dill•11mo ago
yaa i agree! to be honest the business is still pre-revenue and very early stage. I'm also bootstrapping as well so trying to be as cost-concious as possible. will definitely reconsider pro plan few months down the line if business is going well and team grows too 😊
jr
jr•11mo ago
I will increase to 50GB in the meantime
Dill
Dill•11mo ago
thanks for the quick response! that would be helpful 🙂
jr
jr•11mo ago
np! You should be able to run the migration again!
Dill
Dill•11mo ago
running again
jr
jr•11mo ago
ah I see it failed again. This problem is that some data had already been migrated to the new DB. Do you mind deleting the v2 "Postgre" service (the one with the volume) and rerunning the migration from the start
Dill
Dill•11mo ago
ahh i see
jr
jr•11mo ago
it will give it a fresh db that I will also increase the volume size on (Don't delete the legacy plugin) I'm happy to do this as well if you would like. But I won't touch your project without your go ahead
Dill
Dill•11mo ago
any risk of data loss?
jr
jr•11mo ago
Nope. Not if you just delete this https://railway.app/project/d1ff40c5-a9bf-4677-a3e0-f9a1c3d20b81/service/89f146af-69da-4ea2-9ed7-d6f2bde6918a All the data is still in "Postgres Legacy"
Dill
Dill•11mo ago
ahh ok done deleted it
jr
jr•11mo ago
Cool. And now can run the migration again. Also feel free to remove the services that have crashed Updated the new database to 50gb
Dill
Dill•11mo ago
awesome, running again and will remove the crashed onces
jr
jr•11mo ago
nice! Your service is pointed to the new database too
Dill
Dill•11mo ago
awesomeee just checked 🙂 everythings working now will delete the old plugin thanks again for your help!
jr
jr•11mo ago
glad I could help 😄 Sorry again for the hicuups
Want results from more Discord servers?
Add your server