MySQL crashing
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.
8 Replies
Project ID:
039a07b8-3697-4814-8e6e-e219375a4ea8Project ID:
039a07b8-3697-4814-8e6e-e219375a4ea8
Solution
fix the source image to mysql 8.3
@Brody what do you mean by that? I only see source image here but I cannot find how to change it
remove it, re-add it, but this time with the tag fixed to version 8.2
it worked, thank you 🙂
no problem
New reply sent from Help Station thread:
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-ticks3. A deploy action button would appear. Click DeployYou should be good to go
You're seeing this because this thread has been automatically linked to the Help Station thread.