2 years ago
We had a MySQL server running for a while with no issues. Today we hit a resource usage limit that turned off all servers and when we tried to turn the MySQL instance back on, it crashes with the following errors:
```
2024-08-21T14:03:55.042784Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-08-21T14:03:55.162540Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 7
2024-08-21T14:03:55.168729Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-21T14:03:55.553843Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90000 to 80402. Downgrade is only permitted between patch releases.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2024-08-21T14:03:55.560442Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-08-21T14:03:55.560609Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-08-21T14:03:55.560635Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-21T14:03:55.561487Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2) MySQL Community Server - GPL.
2024-08-21T14:03:55.561503Z 0 [System] [MY-015016] [Server] MySQL Server - end.
```
2 Replies
2 years ago
Fixed. In case anyone gets this in the future, the MySQL image version changed between server restarts and since the version wasn't locked, there was a mismatch between the version used to init the mysql instance and the version used to start it later. This caused the error message: "Invalid MySQL server downgrade: Cannot downgrade from 90000 to 80402. Downgrade is only permitted between patch releases." This means: You can't run mysql with version 8.4.2 if you initialized it with version 9.0.0.
What I did was manually disconnect the mysql:8 image and reconnect the server to the msyql:9.0 image, this ran the server with the correct version. Hope it helps someone in the future!
Status changed to Solved angelo-railway • over 1 year ago
Status changed to Open angelo-railway • over 1 year ago
2 years ago
Hey there Juan,
Yep, we ran into image version pinning issues. We now have updated the image over to version 9. We did debate restoring back to 8.3 but users already migrated over would need to migrate back.
Thanks,
Angelo