When ever i create a MySQL db i have the massage saying "Crashed" and the following error
How can I solve that ? is it an incident
Solution:Jump to solution
thank you both! i have updated the template to include the start command that Brody identified, so you should be good to go now to deploy from the template
64 Replies
Project ID:
N/A
the project id is "lucky-friction"
Project ID:lucky-friction
I'll be looking into this though
in your service settings for mysql set this as the start command and let it redeploy
The issue still the same even after pasting the code you shared
please send the deployment logs for the database https://bookmarklets.up.railway.app/log-downloader/
the data directory is unusable, try creating another mysql deployment and use that start command if need be
just use mariadb lol
It does not deployy at all
I tried with post gress and it is working perfect
same also
i can reproduce this, will ask the team tomorrow
ok thank you
hope it will get solved by tomorrow
wish you a happy sunday
evening
you too
Same here, MySQL is crashing on deploy
try the start command above?
After paste the command above it doesn't deploy
screenshots?
does it have a volume?
I think it didn't created the volume
okay then its the same problem as OP, will ask the team tomorrow
Thread has been flagged to Railway team by @Adam.
I would like to +1 this thread, I am having the same issue with my MySQL databases.
Glad to know that i am not the only one .
this should be fixed now
#🚨|incidents
@Brody It still crashing ! i even added the start deployment command and its the same
I first created without the start command and it carashes
deployment logs for the mysql service please
make sure you are using the start command i provided
copy down the current volumes mount point
delete the volume, cancel the automatic redeploy.
mount a new volume to the same path, let it automatically redeploy.
to unmount do i needto click any of those bottons :
if not can you gide me ?
delete the volume, make sure you keep the current mount point in a note so you can mount a new volume to the same path
by the current mounting poing you mean the whole url ?
cause after deleting the volum i am unable to access the url it automaticly redirect me to the project page
i mean the mount path
you mean this
indeed
I have the mount path . what to do next to remount
delete the volume, please follow the instructions I have given
how can I create a new volume path (appreciate your patient with me )
right click the service
not much changes
please follow the instructions
i deleted the volumeas you said and created an new one using the right click and it redeployed automaticly after that.
do you have the start command i gave set?
"docker-entrypoint.sh mysqld --innodb-use-native-aio=0" this one ?
yes
do i add it now ?
done
now you have to do the whole delete and re-add the volume thing
For me to make sure that I understood the instructions:
1-delete the database .
2-create new one .
3-delete the volume .
4-create a new volume path using the path that i copied while deleting
5-and wait for the new redployement.
let me know if there is any missing step
when i follow these instructions the database successfully deploys
cancel the automatic redeploy.(how to do this one )
theres a popup with cancel text
let me know if you all need help with anything, looks like the DB is up. assuming this all stemmed from the incident earlier? anything outstanding that needs to be raised?
I feel embarassed guys to distube you . but still it is not working . i tried to follow the steps provided by you brody it is not working
melissa and I are talking about this, hopefully we will have a solution for you soon that doesn't require any config on your part
Solution
thank you both! i have updated the template to include the start command that Brody identified, so you should be good to go now to deploy from the template
confirmed working smoothly!
Awesome
i confirm
it is working
thanks to both of you guys (and thanks brody for your patient)
no problem!