Mysqld service failed to start

votuan889

240808 16:25:44 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2024-08-08 16:25:44 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-08-08 16:25:44 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3554 ... 2024-08-08 16:25:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-08-08 16:25:44 0 [Note] InnoDB: Number of transaction pools: 1 2024-08-08 16:25:44 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-08-08 16:25:44 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728 2024-08-08 16:25:44 0 [Note] InnoDB: Completed initialization of buffer pool 2024-08-08 16:25:44 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=30546160413,30580330647 2024-08-08 16:25:44 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 806 2024-08-08 16:25:44 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2024-08-08 16:25:44 0 [Note] InnoDB: Starting shutdown... 2024-08-08 16:25:44 0 [ERROR] Plugin 'InnoDB' init function returned error. 2024-08-08 16:25:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-08-08 16:25:44 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-08-08 16:25:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2024-08-08 16:25:44 0 [ERROR] Aborting 240808 16:25:44 mysqld_safe mysqld from pid file /www/server/data/taffy.pid ended 240808 16:35:32 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2024-08-08 16:35:32 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-08-08 16:35:32 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 4565 ... 2024-08-08 16:35:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-08-08 16:35:32 0 [Note] InnoDB: Number of transaction pools: 1 2024-08-08 16:35:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-08-08 16:35:32 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728 2024-08-08 16:35:32 0 [Note] InnoDB: Completed initialization of buffer pool 2024-08-08 16:35:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=30546160413,30580330647 2024-08-08 16:35:32 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 806 2024-08-08 16:35:32 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2024-08-08 16:35:32 0 [Note] InnoDB: Starting shutdown... 2024-08-08 16:35:32 0 [ERROR] Plugin 'InnoDB' init function returned error. 2024-08-08 16:35:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-08-08 16:35:32 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-08-08 16:35:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2024-08-08 16:35:32 0 [ERROR] Aborting 240808 16:35:32 mysqld_safe mysqld from pid file /www/server/data/taffy.pid ended

Now I can't turn on or off mysql or restart it. This is the error message, Please help me. All my websites are down.

aaPanel_Kern

try referring to this tutorial to check
https://www.aapanel.com/forum/d/13216-mysqlmariadb-innodb-storage-engine-damage-solution

votuan889

240808 17:04:11 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2024-08-08 17:04:11 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-08-08 17:04:11 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 2657 ... 2024-08-08 17:04:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-08-08 17:04:12 0 [Note] InnoDB: Number of transaction pools: 1 2024-08-08 17:04:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-08-08 17:04:12 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728 2024-08-08 17:04:12 0 [Note] InnoDB: Completed initialization of buffer pool 2024-08-08 17:04:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=30546160413,30580330647 2024-08-08 17:04:12 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 806 2024-08-08 17:04:12 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2024-08-08 17:04:12 0 [Note] InnoDB: Starting shutdown... 2024-08-08 17:04:12 0 [ERROR] Plugin 'InnoDB' init function returned error. 2024-08-08 17:04:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-08-08 17:04:12 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-08-08 17:04:12 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2024-08-08 17:04:12 0 [ERROR] Aborting 240808 17:04:12 mysqld_safe mysqld from pid file /www/server/data/taffy.pid ended 240808 17:05:47 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2024-08-08 17:05:48 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-08-08 17:05:48 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3197 ... 2024-08-08 17:05:48 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2024-08-08 17:05:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-08-08 17:05:48 0 [Note] InnoDB: Number of transaction pools: 1 2024-08-08 17:05:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-08-08 17:05:48 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728 2024-08-08 17:05:48 0 [Note] InnoDB: Completed initialization of buffer pool 2024-08-08 17:05:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=30546160413,30580330647 2024-08-08 17:05:48 0 [Note] InnoDB: At LSN: 30556534312: unable to open file ./sql_jadenmoodie_/#sql-ib855.ibd for tablespace 842 2024-08-08 17:05:48 0 [Note] InnoDB: At LSN: 30558050119: unable to open file ./sql_jadenmoodie_/#sql-ib856.ibd for tablespace 843 2024-08-08 17:05:48 0 [Note] InnoDB: At LSN: 30558075120: unable to open file ./sql_jadenmoodie_/#sql-ib854.ibd for tablespace 841 2024-08-08 17:05:48 0 [Note] InnoDB: At LSN: 30558597710: unable to open file ./sql_jadenmoodie_/#sql-ib841.ibd for tablespace 828 2024-08-08 17:05:48 0 [Note] InnoDB: At LSN: 30579671357: unable to open file ./sql_jadenmoodie_/#sql-ib859.ibd for tablespace 846 2024-08-08 17:05:48 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 806 2024-08-08 17:05:48 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2024-08-08 17:05:48 0 [Note] InnoDB: Starting shutdown... 2024-08-08 17:05:48 0 [ERROR] Plugin 'InnoDB' init function returned error. 2024-08-08 17:05:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-08-08 17:05:48 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-08-08 17:05:48 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2024-08-08 17:05:48 0 [ERROR] Aborting 240808 17:05:48 mysqld_safe mysqld from pid file /www/server/data/taffy.pid ended

I followed the instructions, sql still can't restart. Here is the updated log

aaPanel_Kern

try the following workarounds
after taking a snapshot backup of the server, try shutting down mysql and restarting it. Is it normal?

pkill mysqld

If it still cannot start normally, is it normal to start again after moving the files?
Please make a snapshot backup

cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart

votuan889

aaPanel_Kern
Restarting mysqld (via systemctl): mysqld.serviceJob for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
failed!

I have sql backup, now I can't uninstall mysql to do fresh install and restore

aaPanel_Kern

Still the same error message? If so, it is recommended that you find a professional company to help you handle it.

votuan889