2 years ago
I am encountering issues with the initialization of my MySQL server on Railway. Here are the details of the error logs:
2024-08-21T14:57:55.862269Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-08-21T14:57:55.976415Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 7 2024-08-21T14:57:55.981056Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-21T14:57:56.488462Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90001 to 80402. Downgrade is only permitted between patch releases. 2024-08-21T14:57:56.497381Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-08-21T14:57:56.497561Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-08-21T14:57:56.497585Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-08-21T14:57:56.498376Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2) MySQL Community Server - GPL. 2024-08-21T14:57:56.498392Z 0 [System] [MY-015016] [Server] MySQL Server - end.
Summary of the Issue:
- The MySQL server fails to start and aborts the initialization process.
- Errors indicate an attempt to downgrade MySQL server versions, which is not supported between major releases.
- The
mysql.ibdfile cannot be opened, leading to the failure of initializing the Data Dictionary Storage Engine.
Steps Taken:
- Checked the server logs for errors.
- Verified that the correct MySQL version is being used.
- Attempted to connect to the database but faced connectivity issues.
Could you please assist with resolving these initialization errors and help in troubleshooting the connection issues?
0 Replies