ByEzel I am getting the following error when starting mysql. how can i solve this problem. 230429 09:42:50 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2023-04-29 9:42:50 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2023-04-29 9:42:50 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 68819 ... 2023-04-29 9:42:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-04-29 9:42:50 0 [Note] InnoDB: Number of transaction pools: 1 2023-04-29 9:42:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-04-29 9:42:50 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2023-04-29 9:42:50 0 [Note] InnoDB: Completed initialization of buffer pool 2023-04-29 9:42:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42227,42227 2023-04-29 9:42:50 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42227 between the checkpoint 42227 and the end 4730328. 2023-04-29 9:42:50 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-04-29 9:42:50 0 [Note] InnoDB: Starting shutdown... 2023-04-29 9:42:51 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-04-29 9:42:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-04-29 9:42:51 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-04-29 9:42:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-04-29 9:42:51 0 [ERROR] Aborting 230429 09:42:51 mysqld_safe mysqld from pid file /www/server/data/teknowater.co.pid ended
aaPanel_Kern ByEzel Hello, is the problem solved? Is it normal to try to move the file away? 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
Dhanamerdeka what you do before it's crashed? seems something corrupted maybe suggestion it's better to reinstall db and import it with current db so no error on future use yum remove to uninstall it completely
