Mysql template crashed suddenly with no interaction from my side

Hello guys, my MySQL database template crashed today suddenly this is the deploy logs, I tried to restart many times but didn't work
No description
Solution:
you would want to deploy the mysql:9 image to put you back on the image you need to be on
Jump to solution
29 Replies
Percy
Percy4mo ago
Project ID: 41e8b6c2-49ee-4d85-afe8-0378c687f492
Gabriel Uribe
Gabriel UribeOP4mo ago
41e8b6c2-49ee-4d85-afe8-0378c687f492
Brody
Brody4mo ago
looks like you tried to downgrade from mysql 9 to 8
No description
Gabriel Uribe
Gabriel UribeOP4mo ago
I did not try anything today and it says it was done 6 hours ago, one question.. in that scenario I should redeploy the last one it does not have that 8, rigth?
No description
Solution
Brody
Brody4mo ago
you would want to deploy the mysql:9 image to put you back on the image you need to be on
Gabriel Uribe
Gabriel UribeOP4mo ago
how can I do that? does this has something to do with the app sleep? why are there so many deploys?
Brody
Brody4mo ago
from the service settings. looks like that was you
Gabriel Uribe
Gabriel UribeOP4mo ago
here?
No description
Gabriel Uribe
Gabriel UribeOP4mo ago
Disconnect?
Brody
Brody4mo ago
yep, then connect the correct image
Gabriel Uribe
Gabriel UribeOP4mo ago
will I lost data in the database? or this has nothing to do with the data?
Brody
Brody4mo ago
unless something else was severally missconfigured, your data will be fine
Gabriel Uribe
Gabriel UribeOP4mo ago
got it disconnected...
Gabriel Uribe
Gabriel UribeOP4mo ago
No description
Gabriel Uribe
Gabriel UribeOP4mo ago
now Connect image, right?
Gabriel Uribe
Gabriel UribeOP4mo ago
what do I put there
No description
Brody
Brody4mo ago
^
Gabriel Uribe
Gabriel UribeOP4mo ago
No description
Gabriel Uribe
Gabriel UribeOP4mo ago
this is weird, I have not touched anything here since some weeks and what I understand is it was downgraded from jmysql 9 to 8... on question, today after I received the email that my DB crashed, I disabled the cronjob that was waking the database every 10 minutes from 7am to 6pm here
No description
Gabriel Uribe
Gabriel UribeOP4mo ago
does this has something to do with why I see many deploys? I mean
Brody
Brody4mo ago
may i ask why you had a cron job on your database?
Gabriel Uribe
Gabriel UribeOP4mo ago
for not consuming resourses at nights... the company uses in workdays, is this not a good practice?
Brody
Brody4mo ago
thats just not how it works though cron jobs can't achieve that
Gabriel Uribe
Gabriel UribeOP4mo ago
got it, so that'swhy I see many deploys in the history? because of that cronjob I had?
No description
Brody
Brody4mo ago
yes, see, skipped since that is not functionality railway supports
Gabriel Uribe
Gabriel UribeOP4mo ago
got it, thank you for your help one more thing Railway does not support a recovey ? I mean if for example somebody deletes the data in the database by accident does Railway support backups?
Brody
Brody4mo ago
you would need to handle backups yourself at this time
Gabriel Uribe
Gabriel UribeOP4mo ago
got it. I see you launch new good thing every friday so I think this could be some feature to be launch someday that would be great!
Brody
Brody4mo ago
someday maybe haha
Want results from more Discord servers?
Add your server