Mariadb refuses to start: Failed to start mariadb.service: Unit mariadb.service not found. 'InnoDB' registration failed

MariaDB
#1

Keywords: MariaDB - AWS - Technical issue - Services (Apache, MariaDB, MySQL…)

bndiagnostic ID: ee6af742-1043-57d5-dba6-11ccff671c20

bndiagnostic output:

? Apache: Found possible issues
? Mariadb: Found possible issues
? Resources: Found possible issues
? Processes: Found possible issues
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-errors-apache/
https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/

bndiagnostic failure reason: The documentation did not make any significant change

Description:
Initially Server was down, Restarted Apache and Got a gateway timeout error, Then last Night, Got Error establishing a database connection from wordpress…
Restarting all service failed,
checked bitnami log “systemctl status bitnami.service”
and Got Mariadb did not start
check mysqld.log file and found
“Can’t lock aria control file”
Deleted arial_log_control and restarted service and nothing changed mariadb still didn’t run
moved over to check php fpm log, where it said pm.max_children(15) exceeded,
increased pm.max_children and nothing still changed!!!

currently stuck at this point

#2

Hi @ovo ,

The bndiagnostic information is clear. There are errors in the Apache’s configuration

The Apache configuration has errors:

AH00526: Syntax error on line 20 of /opt/bitnami/apache/conf/vhosts/store.fitted.ng-https-vhost.conf: deny requires at least two arguments, 'from' followed by hostnames or IP-address wildcards

Please check the configuration.

and the machine is running out of memory

[Resources]

Your instance has little available RAM memory.

 total used free shared buff/cache available Mem: 482 367 7 13 107 88 Swap: 634 38 596

You could try to increase your instance’s memory. Please check your cloud provider’s documentation for more information.

I suggest you increase the resources of the VM and fix the Apache’s configuration error.

#3

oh i forgot to mention, i added the ip addressed later on, actually the last thing i did when i noticed a bot was polling our sites
i will removed that, is there a way to update the diagnostic log key?

#4

So i fixed the apache issue, and increased memeory size to 1GB, yet the issue still Persists, Mariadb still fails to start

free -m

                    total        used        free      shared  buff/cache   available
Mem:            987         131         199          16         656         696
Swap:           634           0         634

Apache Log

[Thu May 26 03:19:16.525221 2022] [authz_core:error] [pid 11206:tid
140100138620672] [client **ip_address**:47560] AH01630: client denied by server
configuration: /opt/bitnami/apache/cgi-bin, referer:
http://13.36.179.39:80/cgi-bin/index2.asp
 [Thu May 26 06:17:40.086383 2022] [core:error] [pid 11206:tid 140100281296640]
[client **ip_address**:59670] AH10244: invalid URI path
Press [Enter] to continue:
(/cgi-bin/.%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/etc/hosts)

 [Thu May 26 13:21:58.004078 2022] [core:error] [pid 1575:tid 139922526603008]
[client **ip_address**:37188] AH10244: invalid URI path
(/cgi-bin/.%2e/.%2e/.%2e/.%2e/bin/sh)

Mysql Recent Log

2022-05-26 15:35:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-26 15:35:55 0 [Note] InnoDB: Number of pools: 1
2022-05-26 15:35:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-26 15:35:55 0 [Note] InnoDB: Using Linux native AIO
2022-05-26 15:35:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16777216, chunk size = 16777216
2022-05-26 15:35:55 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-26 15:35:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5518692707,5518692707
2022-05-26 15:35:55 0 [ERROR] InnoDB: Malformed log record; set innodb_force_recovery=1 to ignore.
2022-05-26 15:35:55 0 [Note] InnoDB: Dump from the start of the mini-transaction (LSN=5518692707) to 100 bytes after th$ len 100; hex 6437353062626139383730663138616164613234373862323438343061223b613a333a7b733a383a227363686564756c65223b733$2022-05-26 15:35:55 0 [Warning] InnoDB: Log scan aborted at LSN 5518745600
2022-05-26 15:35:55 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-05-26 15:35:55 0 [Note] InnoDB: Starting shutdown...
2022-05-26 15:35:55 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-05-26 15:35:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-05-26 15:35:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-26 15:35:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-05-26 15:35:55 0 [ERROR] Aborting

decided to rerun status check and i get this new error

sudo /opt/bitnami/ctlscript.sh status
Cannot find any running daemon to contact. If it is running, make sure you are pointing to the right pid file (/var/run/gonit.pid)
#5 
Cannot find any running daemon to contact. If it is running, make sure you are pointing to the right pid file (/var/run/gonit.pid)
#6

I can see MariaDB can’t be started properly. There are some solutions here

https://stackoverflow.com/questions/26439742/getting-error-plugin-innodb-registration-as-a-storage-engine-failed-when-sta

Note: The MariaDB files are inside the /opt/bitnami/mariadb directory

#7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.