MySQL Database Down

I accidentally stopped a deployment, so had to restart. Now everytime i try to deploy my Database, I get the following

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.

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

2024-08-28T18:25:01.123158Z 0 [System] [MY-015015] [Server] MySQL Server - start.

2024-08-28T18:25:01.370016Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 7

2024-08-28T18:25:01.377756Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2024-08-28T18:25:01.527826Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90000 to 80402. Downgrade is only permitted between patch releases.

2024-08-28T18:25:01.527867Z 1 [ERROR] [MY-012967] [InnoDB] Cannot open DD tablespace.

2024-08-28T18:25:01.527880Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

2024-08-28T18:25:01.534238Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine

2024-08-28T18:25:01.534536Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2024-08-28T18:25:01.534571Z 0 [ERROR] [MY-010119] [Server] Aborting

2024-08-28T18:25:01.536504Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.

2024-08-28T18:25:01.536524Z 0 [System] [MY-015016] [Server] MySQL Server - end.

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2024-08-28 18:25:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.

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

2024-08-28T18:25:01.123158Z 0 [System] [MY-015015] [Server] MySQL Server - start.

2024-08-28T18:25:01.370016Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 7

2024-08-28T18:25:01.377756Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2024-08-28T18:25:01.527826Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90000 to 80402. Downgrade is only permitted between patch releases.

2024-08-28T18:25:01.527867Z 1 [ERROR] [MY-012967] [InnoDB] Cannot open DD tablespace.

2024-08-28T18:25:01.527880Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

2024-08-28T18:25:01.534238Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine

2024-08-28T18:25:01.534536Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2024-08-28T18:25:01.534571Z 0 [ERROR] [MY-010119] [Server] Aborting

2024-08-28T18:25:01.536504Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.

2024-08-28T18:25:01.536524Z 0 [System] [MY-015016] [Server] MySQL Server - end.

Solution:

you're trying to downgrade MySQL from v9 to v8 which you can't do

Jump to solution

13 Replies

Percy•3mo ago

Project ID: N/A

Samir•3mo ago

m/A N/A

Solution

Fragly•3mo ago

you're trying to downgrade MySQL from v9 to v8 which you can't do

Samir•3mo ago

Right guessing the base image needs to be mysql:9 instead of 8 then? What's concerning is I didn't change that myself

Fragly•3mo ago

exactly! that's strange 🤔

Samir•3mo ago

Yes I did that and it fixed it, thank you. You saviour. Yes, I don't know do deployments auto trigger if the same service from a prev env is deployed successfuly? Sorry, this is the project-id. 608a66b4-b749-45dc-b226-05c5a996dae8

Medim•3mo ago

(this isn't the first time I've seen this happen, maybe it's reproducible and can be brought up to the team) I already saw two other ´ppl who restarted their MySql DB and got this error

Fragly•3mo ago

I've heard something about that from previous reports but not 100% sure about that

Samir•3mo ago

This might've been the root cause I suspect it's that

Fragly•3mo ago

Railway started pinning databases to specific versions recently, I suspect that might have something to do with it

Falkiner•2mo ago

I've had my database stopped, and now trying to restart it I'm getting the same error, didn't update or anything lol

Samir•2mo ago

This was the fix And yes very annoying 😄 especially as it’s just a simple restart

Falkiner•2mo ago

Oh I see now, hahaha will try here, thanks! 🙂 Edit: It worked!

Gaming

Programming

MySQL Database Down