MySQL Server Initialization Issue

webmasteraafHOBBY

8 months 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.ibd file 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