aaPanel issue with MariaDB 10.7.3

aaP_marufkhan0498

Yesterday, I encountered an issue with MariaDB 10.7.3 on my aaPanel—suddenly, it stopped working (paused), and I couldn't resolve the problem. When I attempted to reinstall it, I received a "data corrupted" error. Even after restoring my entire VPS, the issue still the same.

Is there any way to fix this without losing my data? or Can anyone help me?

aaPanel_Kern

Hello, do you have any specific error logs? It is recommended that you install mysql for better compatibility
cat /www/server/data/*.err|grep -i -C 10 error

aaP_marufkhan0498

2024-12-15 7:23:50 0 [Warning] InnoDB: Log scan aborted at LSN 125217280
2024-12-15 7:23:50 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-12-15 7:23:50 0 [Note] InnoDB: Starting shutdown...
2024-12-15 7:23:50 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-12-15 7:23:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-12-15 7:23:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-12-15 7:23:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-12-15 7:23:50 0 [ERROR] Aborting
241215 07:23:51 mysqld_safe mysqld from pid file /www/server/data/srv2.catchbd.com.pid ended
241215 07:25:13 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2024-12-15 7:25:13 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15 7:25:13 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3105 ...
2024-12-15 7:25:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-12-15 7:25:13 0 [Note] InnoDB: Using transactional memory
2024-12-15 7:25:13 0 [Note] InnoDB: Number of transaction pools: 1
2024-12-15 7:25:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-12-15 7:25:13 0 [Note] InnoDB: Using Linux native AIO
2024-12-15 7:25:13 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2024-12-15 7:25:13 0 [Note] InnoDB: Completed initialization of buffer pool
2024-12-15 7:25:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=125154913,125154913
2024-12-15 7:25:13 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore.
2024-12-15 7:25:13 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=125154913) to 100 bytes after the record:
len 104; hex b399a620002027008103030e0502000000000000e08000000000000008000000000000009704000000000012000800000000000000970104000000000036008139b2fa20ba1515327b000001832625002027008103030e0602000000000000e08000000000000008; asc ' 6 9 2{ &% ' ;

aaPanel_Kern

Hi, did you add innodb-read-only configuration?
If you have any questions, please refer to this post. Make sure to back up or take a system snapshot.
https://www.aapanel.com/forum/d/13216-mysqlmariadb-innodb-storage-engine-damage-solution

aaP_marufkhan0498