MySQL 10.7.3-MariaDB won't start

Klaud

i've tried to restart server, still won't start, i've added innodb_force_recovery =1 and still can't
i tried to backup my database and can't because mysql is not running
please help

221020 13:22:56 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 13:22:56 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 13:22:56 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3516 ... 2022-10-20 13:22:56 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 13:22:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 13:22:56 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 13:22:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 13:22:56 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 13:22:56 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 13:22:56 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 13:22:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:22:56 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 13:22:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 13:22:56 0 [Note] InnoDB: Starting shutdown... 2022-10-20 13:22:56 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 13:22:56 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 13:22:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 13:22:56 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 13:22:56 0 [ERROR] Aborting 221020 13:22:56 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended

aaPanel_Kern

Klaud
Try the following command to remove the file, and then restart mysql to see if there is an error?
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

Klaud

still can't

aaPanel_Kern

Klaud
systemctl status mysqld.service

Klaud

Still can't

aaPanel_Kern

Klaud
Hello, is this the newly installed MySQL? If yes, it is recommended to uninstall and then install MySQL
If not, please check the log again:
cat /www/server/data/*.err|grep -i -C 10 error

Klaud

no it's already running around 3 weeks normally on fresh install server

[root@vmi1029293 ~]# cat /www/server/data/*.err|grep -i -C 10 error
2022-10-04 21:44:42 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-10-04 21:44:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-04 21:44:42 0 [Note] InnoDB: Buffer pool(s) load completed at 221004 21:44:42
2022-10-04 21:44:42 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-10-04 21:44:42 0 [Note] Server socket created on IP: '::'.
2022-10-04 21:44:42 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
221004 21:44:50 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-10-04 21:44:50 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-10-04 21:44:50 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 5674 ...
2022-10-04 21:44:51 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
221004 21:44:53 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-10-04 21:44:53 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-10-04 21:44:53 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 6151 ...
2022-10-04 21:44:53 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-10-04 21:45:21 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2022-10-04 21:45:21 0 [ERROR] Plugin 'Aria' init function returned error.
2022-10-04 21:45:21 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-10-04 21:45:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-10-04 21:45:21 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-04 21:45:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-04 21:45:21 0 [Note] InnoDB: Using Linux native AIO
2022-10-04 21:45:21 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-10-04 21:45:21 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-04 21:45:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42341,42341
2022-10-04 21:45:21 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-04 21:45:21 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2022-10-04 21:45:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-04 21:45:21 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-04 21:45:21 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-10-04 21:45:21 0 [Note] InnoDB: 10.7.3 started; log sequence number 42353; transaction id 14
2022-10-04 21:45:21 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-10-04 21:45:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-04 21:45:21 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2022-10-04 21:45:21 0 [ERROR] Failed to initialize plugins.
2022-10-04 21:45:21 0 [ERROR] Aborting
2022-10-04 21:45:23 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2022-10-04 21:45:23 0 [ERROR] Plugin 'Aria' init function returned error.
2022-10-04 21:45:23 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-10-04 21:45:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-10-04 21:45:23 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-04 21:45:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-04 21:45:23 0 [Note] InnoDB: Using Linux native AIO
2022-10-04 21:45:23 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-10-04 21:45:24 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-04 21:45:24 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-04 21:45:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-04 21:45:24 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-04 21:45:24 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-10-04 21:45:24 0 [Note] InnoDB: 10.7.3 started; log sequence number 42365; transaction id 14
2022-10-04 21:45:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-04 21:45:24 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2022-10-04 21:45:24 0 [ERROR] Failed to initialize plugins.
2022-10-04 21:45:24 0 [ERROR] Aborting
221004 21:45:24 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended
2022-10-04 23:28:28 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: 'vmi1029293.contaboserver.net' (This connection closed normally without authentication)
2022-10-04 23:37:28 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: 'vmi1029293.contaboserver.net' (This connection closed normally without authentication)
2022-10-04 23:44:56 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:44:56 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:44:56 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:44:59 50 [Warning] Aborted connection 50 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:44:59 54 [Warning] Aborted connection 54 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:44:59 51 [Warning] Aborted connection 51 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:02 63 [Warning] Aborted connection 63 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:02 67 [Warning] Aborted connection 67 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:02 64 [Warning] Aborted connection 64 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:22 76 [Warning] Aborted connection 76 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:22 80 [Warning] Aborted connection 80 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:22 77 [Warning] Aborted connection 77 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:27 89 [Warning] Aborted connection 89 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:27 93 [Warning] Aborted connection 93 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:27 90 [Warning] Aborted connection 90 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:57 102 [Warning] Aborted connection 102 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:57 106 [Warning] Aborted connection 106 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:45:57 103 [Warning] Aborted connection 103 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:46:12 115 [Warning] Aborted connection 115 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:46:12 119 [Warning] Aborted connection 119 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:46:12 116 [Warning] Aborted connection 116 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:48:15 128 [Warning] Aborted connection 128 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:48:15 132 [Warning] Aborted connection 132 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:48:15 129 [Warning] Aborted connection 129 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:59:31 165 [Warning] Aborted connection 165 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:59:31 169 [Warning] Aborted connection 169 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-10-04 23:59:31 166 [Warning] Aborted connection 166 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
221004 23:59:44 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2022-10-04 23:59:44 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-10-04 23:59:44 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 30965 ...
2022-10-04 23:59:44 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-10-05  0:00:14 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2022-10-05  0:00:14 0 [ERROR] Plugin 'Aria' init function returned error.
2022-10-05  0:00:14 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-10-05  0:00:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-10-05  0:00:14 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-05  0:00:14 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-05  0:00:14 0 [Note] InnoDB: Using Linux native AIO
2022-10-05  0:00:14 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2022-10-05  0:00:14 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-05  0:00:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=480907656,504337321
2022-10-05  0:00:17 0 [Note] InnoDB: Starting final batch to recover  5479 pages from redo log.
2022-10-05  0:00:18 0 [Note] InnoDB: Last binlog file './mysql-bin.000003', position 345666387
2022-10-05  0:00:18 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-05  0:00:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-05  0:00:18 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-05  0:00:18 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-10-05  0:00:18 0 [Note] InnoDB: 10.7.3 started; log sequence number 544210296; transaction id 2634
2022-10-05  0:00:18 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-10-05  0:00:18 0 [Note] InnoDB: Buffer pool(s) load completed at 221005  0:00:18
2022-10-05  0:00:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-05  0:00:18 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2022-10-05  0:00:18 0 [ERROR] Failed to initialize plugins.
2022-10-05  0:00:18 0 [ERROR] Aborting
221005 00:00:19 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended

```

aaPanel_Kern

Klaud
Do you have the latest log? These logs are old.

Klaud

how to get latest log?

Klaud

221020 13:06:10 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 05:14:10 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 5:14:10 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 5:14:10 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1806 ... 2022-10-20 5:14:10 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 5:14:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 5:14:10 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 5:14:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 5:14:10 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 5:14:10 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 5:14:10 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 5:14:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 5:14:10 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 5:14:10 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 5:14:10 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 5:14:11 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 5:14:11 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 5:14:11 0 [Note] InnoDB: Starting shutdown... 2022-10-20 5:14:11 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 5:14:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 5:14:11 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 5:14:11 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 5:14:11 0 [ERROR] Aborting 221020 05:14:11 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 13:16:19 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 13:16:19 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 13:16:19 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 2505 ... 2022-10-20 13:16:19 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 13:16:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 13:16:19 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 13:16:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 13:16:19 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 13:16:19 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 13:16:19 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 13:16:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 13:16:19 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:16:19 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 13:16:19 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:16:19 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 13:16:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 13:16:19 0 [Note] InnoDB: Starting shutdown... 2022-10-20 13:16:20 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 13:16:20 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 13:16:20 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 13:16:20 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 13:16:20 0 [ERROR] Aborting 221020 13:16:20 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 13:16:56 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 13:16:56 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 13:16:56 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 2944 ... 2022-10-20 13:16:56 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 13:16:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 13:16:56 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 13:16:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 13:16:56 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 13:16:56 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 13:16:56 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 13:16:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 13:16:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:16:56 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 13:16:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:16:56 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 13:16:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 13:16:56 0 [Note] InnoDB: Starting shutdown... 2022-10-20 13:16:57 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 13:16:57 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 13:16:57 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 13:16:57 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 13:16:57 0 [ERROR] Aborting 221020 13:16:57 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 13:22:56 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 13:22:56 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 13:22:56 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3516 ... 2022-10-20 13:22:56 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 13:22:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 13:22:56 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 13:22:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 13:22:56 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 13:22:56 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 13:22:56 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 13:22:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 13:22:56 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:22:56 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 13:22:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 13:22:56 0 [Note] InnoDB: Starting shutdown... 2022-10-20 13:22:56 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 13:22:56 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 13:22:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 13:22:56 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 13:22:56 0 [ERROR] Aborting 221020 13:22:56 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 13:26:38 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 13:26:38 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 13:26:38 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3920 ... 2022-10-20 13:26:38 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2022-10-20 13:26:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2022-10-20 13:26:38 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-20 13:26:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-20 13:26:38 0 [Note] InnoDB: Using Linux native AIO 2022-10-20 13:26:38 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728 2022-10-20 13:26:38 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-20 13:26:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=544211000,544211000 2022-10-20 13:26:38 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:26:38 0 [Warning] InnoDB: Ignoring malformed log record at LSN 544211000 2022-10-20 13:26:38 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 544211000 2022-10-20 13:26:39 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 544211000 between the checkpoint 544211000 and the end 655738570. 2022-10-20 13:26:39 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2022-10-20 13:26:39 0 [Note] InnoDB: Starting shutdown... 2022-10-20 13:26:39 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 13:26:39 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 13:26:39 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 13:26:39 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 13:26:39 0 [ERROR] Aborting 221020 13:26:39 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 14:46:01 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 14:46:02 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 14:46:02 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 5994 ... 2022-10-20 14:46:02 0 [ERROR] InnoDB: Can't create file '/www/server/data/ibdata1' when --innodb-force-recovery is set 2022-10-20 14:46:02 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 14:46:02 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 14:46:02 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 14:46:02 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 14:46:02 0 [ERROR] Aborting 221020 14:46:02 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended 221020 14:46:47 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2022-10-20 14:46:47 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2022-10-20 14:46:47 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 6443 ... 2022-10-20 14:46:47 0 [ERROR] InnoDB: Can't create file '/www/server/data/ibdata1' when --innodb-force-recovery is set 2022-10-20 14:46:47 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-10-20 14:46:47 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-10-20 14:46:47 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-20 14:46:47 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-10-20 14:46:47 0 [ERROR] Aborting 221020 14:46:47 mysqld_safe mysqld from pid file /www/server/data/vmi1029293.contaboserver.net.pid ended

aaPanel_Kern

Hello, check the permissions of the data directory
ls -al /www/server/data

Klaud

aaPanel_Kern

Klaud
Change the permission and try again. If it still fails, check the log again
chown -R www:www /www/server/data

Klaud

`[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

[mysqld]
innodb_force_recovery = 1
binlog_cache_size = 128K
thread_stack = 256K
join_buffer_size = 2048K
query_cache_type = 1
max_heap_table_size = 512M
port		= 3306
socket		= /tmp/mysql.sock
datadir = /www/server/data
default_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 100G
table_open_cache = 384
sort_buffer_size = 1024K
net_buffer_length = 4K
read_buffer_size = 1024K
read_rnd_buffer_size = 768K
myisam_sort_buffer_size = 32M
thread_cache_size = 128
query_cache_size = 192M
tmp_table_size = 512M
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#skip-name-resolve
max_connections = 300
max_connect_errors = 100
open_files_limit = 65535

log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
slow_query_log=1
slow-query-log-file=/www/server/data/mysql-slow.log
long_query_time=3
#log_queries_not_using_indexes=on


innodb_data_home_dir = /www/server/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /www/server/data
innodb_buffer_pool_size = 512M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 512M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 4
innodb_write_io_threads = 4

[mysqldump]
quick
max_allowed_packet = 500M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 2M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
`

heres my mysql config

Klaud

do you mean i've got ddos attack?

so how do i start mysql and recover my data?

Klaud

already change permission, and restart, but still the same, still cant start

Klaud

i've remove innodb_force_recovery = 1 and can start already

anything i shoud do? and what the optimization should i set to? my vps ram is 8gb

aaPanel_Kern

Klaud
Refer to the settings provided by us. Only settings, not actual configurations

Klaud

i've notice my database lost after mariaDB started

the missing database only on wordpress install from [add a site] [wordpress deploy]

aaPanel_Kern

Klaud
Did the deployment succeed? Try redeploying once