Closed Ivaan09 closed 1 year ago
As the tool warned you, it seems there is an error in the MariaDB's log. Can you take a look at that file and find what's happening? You can follow the instructions in this guide
https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/
This is the O/P of mysqld.log
2023-05-28 8:34:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 8:34:45 0 [Note] InnoDB: Number of pools: 1 2023-05-28 8:34:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 8:34:45 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 8:34:45 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 8:34:45 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 8:34:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 8:34:45 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 8:34:45 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 8:34:45 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 8:34:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 8:34:45 0 [Note] InnoDB: Starting shutdown... 2023-05-28 8:34:45 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 8:34:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 8:34:45 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 8:34:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 8:34:45 0 [ERROR] Aborting 2023-05-28 8:37:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 8:37:07 0 [Note] InnoDB: Number of pools: 1 2023-05-28 8:37:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 8:37:07 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 8:37:07 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 8:37:07 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 8:37:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 8:37:07 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 8:37:07 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 8:37:07 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 8:37:07 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 8:37:07 0 [Note] InnoDB: Starting shutdown... 2023-05-28 8:37:07 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 8:37:07 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 8:37:07 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 8:37:07 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 8:37:07 0 [ERROR] Aborting 2023-05-28 8:39:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 9:35:41 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 9:35:41 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 9:35:41 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 9:35:41 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 9:35:41 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 9:35:41 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 9:35:41 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 9:35:41 0 [Note] InnoDB: Starting shutdown... 2023-05-28 9:35:41 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 9:35:41 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 9:35:41 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 9:35:41 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 9:35:41 0 [ERROR] Aborting 2023-05-28 9:38:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 9:38:10 0 [Note] InnoDB: Number of pools: 1 2023-05-28 9:38:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 9:38:10 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 9:38:10 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 9:38:10 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 9:38:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 9:38:10 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 9:38:10 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 9:38:10 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 9:38:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 9:38:10 0 [Note] InnoDB: Starting shutdown... 2023-05-28 9:38:10 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 9:38:10 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 9:38:10 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 9:38:10 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 9:38:10 0 [ERROR] Aborting 2023-05-28 9:39:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 9:39:50 0 [Note] InnoDB: Number of pools: 1 2023-05-28 9:39:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 9:39:50 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 9:40:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 9:40:52 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 9:40:52 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 9:40:52 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 9:40:52 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 9:40:52 0 [Note] InnoDB: Starting shutdown... 2023-05-28 9:40:52 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 9:40:52 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 9:40:52 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 9:40:52 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 9:40:52 0 [ERROR] Aborting 2023-05-28 9:46:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 9:46:33 0 [Note] InnoDB: Number of pools: 1 2023-05-28 9:46:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 9:46:33 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 9:46:33 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 9:46:33 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 9:46:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-28 9:46:33 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-28 9:46:33 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-28 9:46:33 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-28 9:46:33 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-28 9:46:33 0 [Note] InnoDB: Starting shutdown... 2023-05-28 9:46:33 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-28 9:46:33 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-28 9:46:33 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-28 9:46:33 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-28 9:46:33 0 [ERROR] Aborting 2023-05-28 9:55:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-28 9:55:17 0 [Note] InnoDB: Number of pools: 1 2023-05-28 9:55:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-28 9:55:17 0 [Note] InnoDB: Using Linux native AIO 2023-05-28 9:55:17 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-28 9:55:17 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-28 9:55:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-31 8:33:10 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-31 8:33:10 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-31 8:33:10 0 [ERROR] Aborting 2023-05-31 9:56:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-31 9:56:37 0 [Note] InnoDB: Number of pools: 1 2023-05-31 9:56:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-31 9:56:37 0 [Note] InnoDB: Using Linux native AIO 2023-05-31 9:56:37 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-31 9:56:37 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-31 9:56:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-31 9:56:37 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-31 9:56:37 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-31 9:56:37 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-31 9:56:37 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-31 9:56:37 0 [Note] InnoDB: Starting shutdown... 2023-05-31 9:56:38 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-31 9:56:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-31 9:56:38 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-31 9:56:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-31 9:56:38 0 [ERROR] Aborting 2023-05-31 10:38:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-31 10:38:24 0 [Note] InnoDB: Number of pools: 1 2023-05-31 10:38:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-31 10:38:24 0 [Note] InnoDB: Using Linux native AIO 2023-05-31 10:38:24 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-31 10:38:24 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-31 10:38:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-31 10:38:24 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-31 10:38:24 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-31 10:38:24 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-31 10:38:24 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-31 10:38:24 0 [Note] InnoDB: Starting shutdown... 2023-05-31 10:38:24 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-31 10:38:24 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-31 10:38:24 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-31 10:38:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-05-31 10:38:24 0 [Note] InnoDB: Number of pools: 1 2023-05-31 10:38:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-05-31 10:38:24 0 [Note] InnoDB: Using Linux native AIO 2023-05-31 10:38:24 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-05-31 10:38:24 0 [Note] InnoDB: Completed initialization of buffer pool 2023-05-31 10:38:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11186502092,11186502092 2023-05-31 10:38:24 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore. 2023-05-31 10:38:24 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=11186502092) to 100 bytes after the record: len 103; hex 2261726773223b613a303a7b7d733a383a22696e74657276616c223b693a333630303b7d7d7d693a313638353039323034393b613a313a7b733a34363a2266616365626f6f6b5f666f725f776f6f$ 2023-05-31 10:38:24 0 [Warning] InnoDB: Log scan aborted at LSN 11186557952 2023-05-31 10:38:24 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-05-31 10:38:24 0 [Note] InnoDB: Starting shutdown... 2023-05-31 10:38:24 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-05-31 10:38:24 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-05-31 10:38:24 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-05-31 10:38:24 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2023-05-31 10:38:24 0 [ERROR] Aborting
You are getting a "Malformed log record" error message. There are similar tickets in this forum regarding this issue, please take a look at them.
https://github.com/bitnami/vms/issues?q=is%3Aissue+%22Malformed+log+record%22
Nothing work
bitnami@ip-172-26-10-171:~$ wp plugin deactivate --all
18:51:13.25 ERROR ==> Please run this script as a superuser, to be able to execute WordPr
ess CLI with the proper user
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$ sudo wp plugin deactivate --all
Error: Error establishing a database connection.
bitnami@ip-172-26-10-171:~$ sudo /opt/bitnami/ctlscript.sh restart mariadb
Failed to restart mariadb: Failed to restart mariadb
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$ mysql -uroot -p... -e"SET GLOBAL innodb_fast_shutdown = 0"
ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp
/mysql.sock' (111)
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$ service mysql stop
-bash: service: command not found
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$ mv /var/lib/mysql/ib_logfile[01] /tmp
mv: cannot stat '/var/lib/mysql/ib_logfile[01]': No such file or directory
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$ service mysql start
-bash: service: command not found
bitnami@ip-172-26-10-171:~$ sudo mysql -uroot -p... -e"SET GLOBAL innodb_fast_shutdown = 0
"
ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp
/mysql.sock' (111)
bitnami@ip-172-26-10-171:~$
bitnami@ip-172-26-10-171:~$
Applied everything but unable to start mariaDB urgent help needed in this ....
What changes did you apply to the database? From your commands, you are just trying to access the database, but I do not know if you set the innodb_force_recovery parameter in the database's configuration file.
As I mentioned above, there are several cases that explain how to solve this. Please follow them and apply the required changes before trying to start the database. You can also take a look at the database's official documentation to know more about how to recover the database
This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.
Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.
Platform
AWS
bndiagnostic ID know more about bndiagnostic ID
3acae087-112d-2c6c-ff64-3705d5cac13f
bndiagnostic output
===== Begin of bndiagnostic tool output =====
[Apache]
Found recent error or warning messages in the Apache error log.
Please check the following guide to troubleshoot server issues:
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-erro rs-apache/
[Mariadb]
Found recent error messages in the MariaDB error log: 2023-05-31 9:56:38 0 [ERROR] Aborting