R
Railway•8mo ago
Yahya#51

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
No description
No description
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
Jump to solution
64 Replies
Percy
Percy•8mo ago
Project ID: N/A
Yahya#51
Yahya#51•8mo ago
the project id is "lucky-friction" Project ID:lucky-friction
Brody
Brody•8mo ago
I'll be looking into this though in your service settings for mysql set this as the start command and let it redeploy
docker-entrypoint.sh mysqld --innodb-use-native-aio=0
docker-entrypoint.sh mysqld --innodb-use-native-aio=0
Yahya#51
Yahya#51•8mo ago
The issue still the same even after pasting the code you shared
No description
Brody
Brody•8mo ago
please send the deployment logs for the database https://bookmarklets.up.railway.app/log-downloader/
Brody
Brody•8mo ago
the data directory is unusable, try creating another mysql deployment and use that start command if need be
Yahya#51
Yahya#51•8mo ago
No description
Brody
Brody•8mo ago
just use mariadb lol
Yahya#51
Yahya#51•8mo ago
It does not deployy at all I tried with post gress and it is working perfect
Yahya#51
Yahya#51•8mo ago
No description
Yahya#51
Yahya#51•8mo ago
same also
Brody
Brody•8mo ago
i can reproduce this, will ask the team tomorrow
Yahya#51
Yahya#51•8mo ago
ok thank you hope it will get solved by tomorrow wish you a happy sunday evening
Brody
Brody•8mo ago
you too
Eddie
Eddie•8mo ago
Same here, MySQL is crashing on deploy
Brody
Brody•8mo ago
try the start command above?
Eddie
Eddie•8mo ago
After paste the command above it doesn't deploy
Brody
Brody•8mo ago
screenshots?
Eddie
Eddie•8mo ago
No description
Eddie
Eddie•8mo ago
No description
Brody
Brody•8mo ago
does it have a volume?
Eddie
Eddie•8mo ago
I think it didn't created the volume
Brody
Brody•8mo ago
okay then its the same problem as OP, will ask the team tomorrow
Duchess
Duchess•8mo ago
Thread has been flagged to Railway team by @Adam.
Crouton
Crouton•8mo ago
I would like to +1 this thread, I am having the same issue with my MySQL databases.
Yahya#51
Yahya#51•8mo ago
Glad to know that i am not the only one .
Brody
Brody•8mo ago
this should be fixed now #🚨|incidents
Yahya#51
Yahya#51•8mo ago
@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
Brody
Brody•8mo ago
deployment logs for the mysql service please
Brody
Brody•8mo ago
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.
Yahya#51
Yahya#51•8mo ago
to unmount do i needto click any of those bottons :
No description
Yahya#51
Yahya#51•8mo ago
if not can you gide me ?
Brody
Brody•8mo ago
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
Yahya#51
Yahya#51•8mo ago
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
Brody
Brody•8mo ago
i mean the mount path
Yahya#51
Yahya#51•8mo ago
you mean this
No description
Brody
Brody•8mo ago
indeed
Yahya#51
Yahya#51•8mo ago
I have the mount path . what to do next to remount
Brody
Brody•8mo ago
delete the volume, please follow the instructions I have given
Yahya#51
Yahya#51•8mo ago
how can I create a new volume path (appreciate your patient with me )
Brody
Brody•8mo ago
right click the service
Yahya#51
Yahya#51•8mo ago
No description
Yahya#51
Yahya#51•8mo ago
not much changes
Brody
Brody•8mo ago
please follow the instructions
Yahya#51
Yahya#51•8mo ago
i deleted the volumeas you said and created an new one using the right click and it redeployed automaticly after that.
Brody
Brody•8mo ago
do you have the start command i gave set?
Yahya#51
Yahya#51•8mo ago
"docker-entrypoint.sh mysqld --innodb-use-native-aio=0" this one ?
Brody
Brody•8mo ago
yes
Yahya#51
Yahya#51•8mo ago
do i add it now ? done
Brody
Brody•8mo ago
now you have to do the whole delete and re-add the volume thing
Yahya#51
Yahya#51•8mo ago
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
Brody
Brody•8mo ago
when i follow these instructions the database successfully deploys
Yahya#51
Yahya#51•8mo ago
cancel the automatic redeploy.(how to do this one )
Brody
Brody•8mo ago
theres a popup with cancel text
Melissa
Melissa•8mo ago
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?
Yahya#51
Yahya#51•8mo ago
No description
Yahya#51
Yahya#51•8mo ago
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
Brody
Brody•8mo ago
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
Melissa
Melissa•8mo ago
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
Brody
Brody•8mo ago
confirmed working smoothly!
Yahya#51
Yahya#51•8mo ago
Awesome i confirm it is working thanks to both of you guys (and thanks brody for your patient)
Brody
Brody•8mo ago
no problem!