MySQL 10.7.3-MariaDB does not turn on after a sudden shutdown of the server

Toyota

Hello, dear developers. I had an unexpected situation. I googled for two hours and didn't find a solution 🙁 Deleting and reinstalling the plugin is not an option 🙁

[root@centos-4gb-nbg1-1 ~]# systemctl status mysqld.service
● mysqld.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2022-08-11 21:34:06 UTC; 5s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 2408 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)

Aug 11 21:34:04 centos-4gb-nbg1-1 systemd[1]: Starting LSB: start and stop M....
Aug 11 21:34:05 centos-4gb-nbg1-1 mysqld[2408]: Starting MariaDB.220811 21:3....
Aug 11 21:34:05 centos-4gb-nbg1-1 mysqld[2408]: 220811 21:34:05 mysqld_safe ...a
Aug 11 21:34:06 centos-4gb-nbg1-1 mysqld[2408]: /etc/rc.d/init.d/mysqld: lin...s
Aug 11 21:34:06 centos-4gb-nbg1-1 mysqld[2408]: ERROR!
Aug 11 21:34:06 centos-4gb-nbg1-1 systemd[1]: mysqld.service: control proces...1
Aug 11 21:34:06 centos-4gb-nbg1-1 systemd[1]: Failed to start LSB: start and....
Aug 11 21:34:06 centos-4gb-nbg1-1 systemd[1]: Unit mysqld.service entered fa....
Aug 11 21:34:06 centos-4gb-nbg1-1 systemd[1]: mysqld.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

2022-08-11 21:27:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-08-11 21:27:26 0 [Note] InnoDB: Number of transaction pools: 1
2022-08-11 21:27:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-08-11 21:27:26 0 [Note] InnoDB: Using Linux native AIO
2022-08-11 21:27:26 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-08-11 21:27:26 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-11 21:27:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42373,42373
2022-08-11 21:27:26 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42373 between the checkpoint 42373 and the end 11641987.
2022-08-11 21:27:26 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-08-11 21:27:26 0 [Note] InnoDB: Starting shutdown...
2022-08-11 21:27:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-08-11 21:27:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-08-11 21:27:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-11 21:27:26 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-08-11 21:27:26 0 [ERROR] Aborting
220811 21:27:26 mysqld_safe mysqld from pid file /www/server/data/centos-4gb-nbg1-1.pid ended
220811 21:31:05 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-08-11 21:31:05 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-08-11 21:31:05 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3317 ...
2022-08-11 21:31:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-08-11 21:31:05 0 [Note] InnoDB: Number of transaction pools: 1
2022-08-11 21:31:05 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-08-11 21:31:05 0 [Note] InnoDB: Using Linux native AIO
2022-08-11 21:31:05 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-08-11 21:31:05 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-11 21:31:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42373,42373
2022-08-11 21:31:05 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42373 between the checkpoint 42373 and the end 11641987.
2022-08-11 21:31:05 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-08-11 21:31:05 0 [Note] InnoDB: Starting shutdown...
2022-08-11 21:31:05 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-08-11 21:31:05 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-08-11 21:31:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-11 21:31:05 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-08-11 21:31:05 0 [ERROR] Aborting
220811 21:31:05 mysqld_safe mysqld from pid file /www/server/data/centos-4gb-nbg1-1.pid ended
220811 21:31:58 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-08-11 21:31:58 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-08-11 21:31:58 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1995 ...
2022-08-11 21:31:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-08-11 21:31:58 0 [Note] InnoDB: Number of transaction pools: 1
2022-08-11 21:31:58 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-08-11 21:31:58 0 [Note] InnoDB: Using Linux native AIO
2022-08-11 21:31:58 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-08-11 21:31:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-11 21:31:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42373,42373
2022-08-11 21:31:58 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42373 between the checkpoint 42373 and the end 11641987.
2022-08-11 21:31:58 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-08-11 21:31:58 0 [Note] InnoDB: Starting shutdown...
2022-08-11 21:31:58 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-08-11 21:31:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-08-11 21:31:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-11 21:31:58 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-08-11 21:31:58 0 [ERROR] Aborting
220811 21:31:58 mysqld_safe mysqld from pid file /www/server/data/centos-4gb-nbg1-1.pid ended
220811 21:34:05 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-08-11 21:34:05 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-08-11 21:34:05 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 2729 ...
2022-08-11 21:34:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-08-11 21:34:05 0 [Note] InnoDB: Number of transaction pools: 1
2022-08-11 21:34:05 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-08-11 21:34:05 0 [Note] InnoDB: Using Linux native AIO
2022-08-11 21:34:05 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-08-11 21:34:05 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-11 21:34:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42373,42373
2022-08-11 21:34:05 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42373 between the checkpoint 42373 and the end 11641987.
2022-08-11 21:34:05 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-08-11 21:34:05 0 [Note] InnoDB: Starting shutdown...
2022-08-11 21:34:05 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-08-11 21:34:05 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-08-11 21:34:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-11 21:34:05 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-08-11 21:34:05 0 [ERROR] Aborting
220811 21:34:05 mysqld_safe mysqld from pid file /www/server/data/centos-4gb-nbg1-1.pid ended

Toyota

DONE https://www.aapanel.com/forum/d/13086-mysql-stop/10

Toyota

Now the problem with phpmyadmin is🙁

Warning in ./libraries/classes/Config.php#1761
 mkdir(): Permission denied

Backtrace

./libraries/classes/Config.php#1761: mkdir(
string './tmp//twig',
integer 504,
boolean true,
)
./libraries/classes/Template.php#62: PhpMyAdmin\Config->getTempDir(string 'twig')
./libraries/classes/Template.php#102: PhpMyAdmin\Template->__construct(string 'list/item')
./libraries/classes/Util.php#1657: PhpMyAdmin\Template::get(string 'list/item')
./libraries/classes/Util.php#1688: PhpMyAdmin\Util::getHtmlTab(
array,
array,
)
./libraries/classes/Menu.php#130: PhpMyAdmin\Util::getHtmlTabs(
array,
array,
string 'topmenu',
boolean true,
)
./libraries/classes/Menu.php#95: PhpMyAdmin\Menu->_getMenu()
./libraries/classes/Response.php#313: PhpMyAdmin\Menu->getHash()
./libraries/classes/Response.php#436: PhpMyAdmin\Response->_ajaxResponse()
PhpMyAdmin\Response->response()

aaPanel_Kern

Toyota
Check the php version of phpmyadmin, the phpmyadmin of the panel does not support php8.1, try to replace it with php7.4
If it still doesn't solve the problem. Please reinstall phpmyadmin, reinstallation will not affect the mysql/mariaDB database

Toyota

aaPanel_Kern

It helped. Deleted and reinstalled phpmyadmin.