Mysql template crashed suddenly with no interaction from my side
gabrielurgomez
PROOP

2 years ago

Hello guys, my MySQL database template crashed today suddenly

this is the deploy logs, I tried to restart many times but didn't work

42 Replies

gabrielurgomez
PROOP

2 years ago

41e8b6c2-49ee-4d85-afe8-0378c687f492


2 years ago

looks like you tried to downgrade from mysql 9 to 8

1273423557241733000


gabrielurgomez
PROOP

2 years 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?

1273423882531115000


2 years ago

you would want to deploy the mysql:9 image to put you back on the image you need to be on


gabrielurgomez
PROOP

2 years ago

how can I do that?


gabrielurgomez
PROOP

2 years ago

does this has something to do with the app sleep?


gabrielurgomez
PROOP

2 years ago

why are there so many deploys?


2 years ago

from the service settings.


2 years ago

looks like that was you


gabrielurgomez
PROOP

2 years ago

here?

1273424957874901000


gabrielurgomez
PROOP

2 years ago

Disconnect?


2 years ago

yep, then connect the correct image


gabrielurgomez
PROOP

2 years ago

will I lost data in the database?


gabrielurgomez
PROOP

2 years ago

or this has nothing to do with the data?


2 years ago

unless something else was severally missconfigured, your data will be fine


gabrielurgomez
PROOP

2 years ago

got it


gabrielurgomez
PROOP

2 years ago

disconnected…


gabrielurgomez
PROOP

2 years ago

1273425618004086800


gabrielurgomez
PROOP

2 years ago

now Connect image, right?


gabrielurgomez
PROOP

2 years ago

what do I put there

1273425725239853000


2 years ago

^


gabrielurgomez
PROOP

2 years ago

1273425850594758700


gabrielurgomez
PROOP

2 years 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

1273426454696165400


gabrielurgomez
PROOP

2 years ago

does this has something to do with why I see many deploys?


gabrielurgomez
PROOP

2 years ago

I mean


2 years ago

may i ask why you had a cron job on your database?


gabrielurgomez
PROOP

2 years ago

for not consuming resourses at nights… the company uses in workdays, is this not a good practice?


2 years ago

thats just not how it works though


2 years ago

cron jobs can't achieve that


gabrielurgomez
PROOP

2 years ago

got it, so that'swhy I see many deploys in the history? because of that cronjob I had?

1273427173222518800


2 years ago

yes, see, skipped since that is not functionality railway supports


gabrielurgomez
PROOP

2 years ago

got it, thank you for your help


gabrielurgomez
PROOP

2 years ago

one more thing


gabrielurgomez
PROOP

2 years ago

Railway does not support a recovey ?


gabrielurgomez
PROOP

2 years ago

I mean


gabrielurgomez
PROOP

2 years ago

if for example


gabrielurgomez
PROOP

2 years ago

somebody deletes the data in the database by accident


gabrielurgomez
PROOP

2 years ago

does Railway support backups?


2 years ago

you would need to handle backups yourself at this time


gabrielurgomez
PROOP

2 years ago

got it. I see you launch new good thing every friday so I think this could be some feature to be launch someday


gabrielurgomez
PROOP

2 years ago

that would be great!


2 years ago

someday maybe haha


Loading...