MySQL crashing
hradutiu
HOBBYOP

2 years ago

Hello everyone, I just noticed my app not working due to some MySQL error. I did not deploy anything or made any changes, my railway MySQL db just crashed with following message and I cannot bring it back up. Does anyone know anything about it?

2024-07-05 19:07:26+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2024-07-05 19:07:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.0-1.el9 started.

'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

2024-07-05T19:07:26.593219Z 0 [System] [MY-015015] [Server] MySQL Server - start.

2024-07-05T19:07:26.711353Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.0) starting as process 7

2024-07-05T19:07:26.716071Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2024-07-05T19:07:26.895445Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2024-07-05T19:07:26.899044Z 1 [ERROR] [MY-014060] [Server] Invalid MySQL server upgrade: Cannot upgrade from 80300 to 90000. Upgrade to next major version is only allowed from the last LTS release, which version 80300 is not.

2024-07-05T19:07:26.899190Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2024-07-05T19:07:26.899221Z 0 [ERROR] [MY-010119] [Server] Aborting

2024-07-05T19:07:26.932114Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 9.0.0) MySQL Community Server - GPL.

2024-07-05T19:07:26.932136Z 0 [System] [MY-015016] [Server] MySQL Server - end.

Solved

7 Replies

hradutiu
HOBBYOP

2 years ago

Project ID:
039a07b8-3697-4814-8e6e-e219375a4ea8


2 years ago

fix the source image to mysql 8.3


Status changed to Solved Railway over 1 year ago


hradutiu
HOBBYOP

2 years ago

@Brody what do you mean by that? I only see source image here but I cannot find how to change it

1258865638013665300


2 years ago

remove it, re-add it, but this time with the tag fixed to version 8.3


hradutiu
HOBBYOP

2 years ago

it worked, thank you 🙂


2 years ago

no problem


olamigokayphils
HOBBY

2 years ago

In your case: - 1. click on Source image 'disconnect'- 2.Input mysql with your specific tag i.e `mysql:8.3.0` without the back-ticks- 3. A deploy action button would appear. Click DeployYou should be good to go

Attachments


Loading...