Error: Database connection failed It is possible that the database is overloaded or otherwise not running properly

Keywords: Moodle - AWS - Technical issue - Other
Description:
Description not provided

code 60a58cfb-d700-5f1a-5d9d-cc3cfb6279e2

You mentioned:

Check free amount of disk space

-----------------------------------

Running: df -h

In: /opt/bitnami

Output:

Filesystem      Size  Used Avail Use% Mounted on

udev            488M     0  488M   0% /dev

tmpfs           100M   12M   88M  12% /run

/dev/sda1       9.8G  9.4G     0 100% /

tmpfs           499M     0  499M   0% /dev/shm

tmpfs           5.0M     0  5.0M   0% /run/lock

tmpfs           499M     0  499M   0% /sys/fs/cgroup

Could you try if resizing the server solves the issues? Find below our documentation:
https://docs.bitnami.com/google/faq/administration/resize-server-disk/

After that, try to restart MySQL:

sudo /opt/bitnami/ctlscript.sh restart mysql

But where dou you have the numbers from???
Figures are:

bitnami@ip-172-31-41-233:/opt/bitnami$ df -h
Filesystem       Size  Used Avail Use% Mounted on
udev             7.8G     0  7.8G   0% /dev
tmpfs            1.6G  8.4M  1.6G   1% /run
/dev/nvme1n1p1   2.0T  426G  1.5T  23% /
tmpfs            7.8G     0  7.8G   0% /dev/shm
tmpfs            5.0M     0  5.0M   0% /run/lock
tmpfs            7.8G     0  7.8G   0% /sys/fs/cgroup
/dev/nvme1n1p15  124M  278K  124M   1% /boot/efi
/dev/nvme0n1     500G   15G  486G   3% /data
tmpfs            1.6G     0  1.6G   0% /run/user/1000
bitnami@ip-172-31-41-233:/opt/bitnami$

BTW: we have got Bitnami Stack on AWS.

Anither support code:

238cb963-47d3-af3c-d1d8-95321f5cab02

ff3f80d9-b857-9070-c355-a4394515e9b6

Is there a chance to get a paid service?

ML

Hello @michael.leondaris,

We are sorry to tell you that we do not provide this kind of service. This Community is for giving support on issues discovered with our application packaging. We try to help our users in this forum but we do not offer paid support.

I’m not seeing the output you shared in your second post in any of the bnsupport IDs and I don’t think there is a space issue in your instance. There are a lot of accesses to your site coming from a single IP:

-----------------------------------
Check performance issues: Count number of requests for the 10 most active IP addresses in the last 100.000 requests
-----------------------------------
Running: tail -n 100000 access_log | awk '{print $1}' | sort | uniq -c | sort -nr | head -n 10 | awk '{print $1}'
In: /opt/bitnami/apache2/logs/

Output:

20546
79
66
45
23
21
20
14
14
11

Could you check our Deny Connections From Bots/Attackers Using Apache guide and verify that the current behaviour is expected?

Apart from that, our tool couldn’t get the database logs, probably because its size, could you please share here the output of the following commands:

sudo /opt/bitnami/ctlscript.sh restart
sudo /opt/bitnami/ctlscript.sh status
sudo tail -60 /opt/bitnami/mariadb/logs/mysqld.log

Regards,
Francisco de Paz

restart output

Job for bitnami.service failed because the control process exited with error code.
See "systemctl status bitnami.service" and "journalctl -xe" for details.

status output

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)

tail output

2021-06-13 21:36:53 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-13 21:36:53 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-13 21:36:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-13 21:36:53 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-13 21:36:53 0 [ERROR] Aborting

2021-06-14 13:22:37 0 [Note] InnoDB: Using Linux native AIO
2021-06-14 13:22:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14 13:22:37 0 [Note] InnoDB: Uses event mutexes
2021-06-14 13:22:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14 13:22:37 0 [Note] InnoDB: Number of pools: 1
2021-06-14 13:22:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-14 13:22:37 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2021-06-14 13:22:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-14 13:22:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-14 13:22:37 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 1082858333562 between the checkpoint 1082855277226 and the end 1082858333184.
2021-06-14 13:22:37 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-14 13:22:38 0 [Note] InnoDB: Starting shutdown...
2021-06-14 13:22:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-14 13:22:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-14 13:22:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-14 13:22:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-14 13:22:38 0 [ERROR] Aborting

Hello @michael.leondaris,

Please share the output of the recommended commands:

sudo systemctl status bitnami.service
sudo journalctl -xe

Where did you obtain the info for the df -h command you shared in your second post? Was that the old state of your instance? Also, have you performed any permission change with chmod of chown to your instance?

Regards,
Francisco de Paz

  1. bitnami.service could not be found

bitnami@ip-172-31-41-233:~$ sudo journalctl -xe
Jun 17 06:33:01 ip-172-31-41-233 CRON[15938]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:33:01 ip-172-31-41-233 CRON[15939]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:33:01 ip-172-31-41-233 CRON[15938]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:34:01 ip-172-31-41-233 CRON[15941]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:34:01 ip-172-31-41-233 CRON[15942]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:34:02 ip-172-31-41-233 CRON[15941]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:34:26 ip-172-31-41-233 dhclient[533]: XMT: Solicit on ens5, interval 131560ms.
Jun 17 06:35:01 ip-172-31-41-233 CRON[15945]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:35:01 ip-172-31-41-233 CRON[15946]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:35:01 ip-172-31-41-233 CRON[15945]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:36:01 ip-172-31-41-233 CRON[15948]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:36:01 ip-172-31-41-233 CRON[15949]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:36:01 ip-172-31-41-233 CRON[15948]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:36:38 ip-172-31-41-233 dhclient[533]: XMT: Solicit on ens5, interval 125300ms.
Jun 17 06:37:01 ip-172-31-41-233 CRON[15951]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:37:01 ip-172-31-41-233 CRON[15952]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:37:01 ip-172-31-41-233 CRON[15951]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:38:01 ip-172-31-41-233 CRON[15954]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:38:01 ip-172-31-41-233 CRON[15955]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:38:01 ip-172-31-41-233 CRON[15954]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:38:06 ip-172-31-41-233 sshd[15957]: Invalid user master from 40.118.226.96 port 48498
Jun 17 06:38:07 ip-172-31-41-233 sshd[15957]: Received disconnect from 40.118.226.96 port 48498:11: Bye Bye [preauth]
Jun 17 06:38:07 ip-172-31-41-233 sshd[15957]: Disconnected from invalid user master 40.118.226.96 port 48498 [preauth]
Jun 17 06:38:43 ip-172-31-41-233 dhclient[533]: XMT: Solicit on ens5, interval 110140ms.
Jun 17 06:39:01 ip-172-31-41-233 CRON[15959]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:39:01 ip-172-31-41-233 CRON[15960]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:39:01 ip-172-31-41-233 CRON[15959]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:39:28 ip-172-31-41-233 sshd[15965]: Did not receive identification string from 81.161.63.253 port 47932
Jun 17 06:39:37 ip-172-31-41-233 sshd[15964]: Connection reset by 81.161.63.253 port 42550 [preauth]
Jun 17 06:39:43 ip-172-31-41-233 sshd[15967]: Connection reset by 81.161.63.253 port 42566 [preauth]
Jun 17 06:40:01 ip-172-31-41-233 sshd[15972]: Invalid user admin from 5.188.62.240 port 30644
Jun 17 06:40:01 ip-172-31-41-233 CRON[15974]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:40:01 ip-172-31-41-233 CRON[15975]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:40:01 ip-172-31-41-233 sshd[15972]: Connection closed by invalid user admin 5.188.62.240 port 30644 [preauth]
Jun 17 06:40:01 ip-172-31-41-233 CRON[15974]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:40:10 ip-172-31-41-233 sshd[15970]: Accepted publickey for bitnami from 178.15.37.146 port 62596 ssh2: RSA SHA256:e5838WCNG2wyc1dwF9t4DJGTmFGgbkz2cdROg+4w3qY
Jun 17 06:40:10 ip-172-31-41-233 sshd[15970]: pam_unix(sshd:session): session opened for user bitnami by (uid=0)
Jun 17 06:40:10 ip-172-31-41-233 systemd-logind[628]: New session 1501 of user bitnami.
-- Subject: A new session 1501 has been created for user bitnami
-- Defined-By: systemd
-- Support: https://www.debian.org/support
-- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat
--
-- A new session with the ID 1501 has been created for the user bitnami.
--
-- The leading process of the session is 15970.
Jun 17 06:40:10 ip-172-31-41-233 systemd[1]: Started Session 1501 of user bitnami.
-- Subject: A start job for unit session-1501.scope has finished successfully
-- Defined-By: systemd
-- A start job for unit session-1501.scope has finished successfully.
--
-- The job identifier is 762.
Jun 17 06:40:17 ip-172-31-41-233 sudo[15987]:  bitnami : TTY=pts/0 ; PWD=/home/bitnami ; USER=root ; COMMAND=/usr/bin/mc
Jun 17 06:40:17 ip-172-31-41-233 sudo[15987]: pam_unix(sudo:session): session opened for user root by bitnami(uid=0)
Jun 17 06:40:33 ip-172-31-41-233 dhclient[533]: XMT: Solicit on ens5, interval 115110ms.
Jun 17 06:41:00 ip-172-31-41-233 sshd[16010]: Invalid user music from 162.62.58.181 port 34678
Jun 17 06:41:00 ip-172-31-41-233 sshd[16010]: Received disconnect from 162.62.58.181 port 34678:11: Bye Bye [preauth]
Jun 17 06:41:00 ip-172-31-41-233 sshd[16010]: Disconnected from invalid user music 162.62.58.181 port 34678 [preauth]
Jun 17 06:41:01 ip-172-31-41-233 CRON[16012]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:41:01 ip-172-31-41-233 CRON[16013]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:41:01 ip-172-31-41-233 CRON[16012]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:41:07 ip-172-31-41-233 sudo[15987]: pam_unix(sudo:session): session closed for user root
Jun 17 06:41:41 ip-172-31-41-233 sudo[16016]:  bitnami : TTY=pts/0 ; PWD=/home/bitnami ; USER=root ; COMMAND=/usr/bin/systemctl status binami.service
Jun 17 06:41:41 ip-172-31-41-233 sudo[16016]: pam_unix(sudo:session): session opened for user root by bitnami(uid=0)
Jun 17 06:41:41 ip-172-31-41-233 sudo[16016]: pam_unix(sudo:session): session closed for user root
Jun 17 06:42:01 ip-172-31-41-233 CRON[16019]: pam_unix(cron:session): session opened for user daemon by (uid=0)
Jun 17 06:42:01 ip-172-31-41-233 CRON[16020]: (daemon) CMD (/opt/bitnami/php/bin/php /opt/bitnami/moodle/admin/cli/cron.php > /dev/null 2>> /bitnami/moodledata/moodle-cron.log)
Jun 17 06:42:01 ip-172-31-41-233 CRON[16019]: pam_unix(cron:session): session closed for user daemon
Jun 17 06:42:11 ip-172-31-41-233 sudo[16022]:  bitnami : TTY=pts/0 ; PWD=/home/bitnami ; USER=root ; COMMAND=/usr/bin/journalctl -xe
Jun 17 06:42:11 ip-172-31-41-233 sudo[16022]: pam_unix(sudo:session): session opened for user root by bitnami(uid=0)
  1. No it is the current status of df -h

As per now:

bitnami@ip-172-31-41-233:~$ df -h
Filesystem       Size  Used Avail Use% Mounted on
udev             7.8G     0  7.8G   0% /dev
tmpfs            1.6G   17M  1.6G   2% /run
/dev/nvme1n1p1   2.0T  426G  1.5T  23% /
tmpfs            7.8G     0  7.8G   0% /dev/shm
tmpfs            5.0M     0  5.0M   0% /run/lock
tmpfs            7.8G     0  7.8G   0% /sys/fs/cgroup
/dev/nvme1n1p15  124M  278K  124M   1% /boot/efi
/dev/nvme0n1    1000G   15G  986G   2% /data
tmpfs            1.6G     0  1.6G   0% /run/user/1000
bitnami@ip-172-31-41-233:~$ ^C
bitnami@ip-172-31-41-233:~$

Regards
Michael

Hello @michael.leondaris,

So the first output of df -h in this post was not of your current instance, right?

Let’s start by checking the issue of the missing daemon when executing a ctlscript.sh status. Any issues with the daemon initialization should be solved with sudo gonit reload or sudo gonit:

$ sudo gonit
daemon with PID 1558 awakened

If you get the following error

Socket file '/var/run/gonit.sock' is not writable

Remove that file:

sudo rm /var/run/gonit.sock

And try again:

sudo gonit

And check the status:

sudo /opt/bitnami/ctlscript.sh status 
sudo gonit status

Regards,
Francisco de Paz

ok

Uptime 1m38s
Last Check 2021-06-17 12:08:23.421129664 +0000 UTC m=+0.017778055
Next Check 2021-06-17 12:10:23.421129664 +0000 UTC m=+120.017778055
Pid 6120
Pid File /var/run/gonit.pid
Control File /etc/gonit/gonitrc
Socket File /var/run/gonit.sock
Log File /var/log/gonit.log
Process ‘apache’
monitoring status Not monitored

Process ‘mariadb’
monitoring status Not monitored

Process ‘php-fpm’
monitoring status Not monitored

Hello @michael.leondaris,

It seems gonit has started working again

Could you please try to restart the services now?

sudo /opt/bitnami/ctlscript.sh restart
sudo /opt/bitnami/ctlscript.sh start
sudo gonit status
ps aux |  grep 'apache\|mysql\|nginx\|/opt/bitnami\|php-fpm\|maria\|gonit'

That would probably leave us with the database error. Please retrieve again the last logs from it and share them here:

sudo tail -60 /opt/bitnami/mariadb/logs/mysqld.log

Regards,
Francisco de Paz

sudo /opt/bitnami/ctlscript.sh restart and start give me:

Job for bitnami.service failed because the control process exited with error code.
See "systemctl status bitnami.service" and "journalctl -xe" for details.

When i start gonit deamon it is fine after i get:

daemon with PID 11237 awakened

bitnami@ip-172-31-41-233:~$ ps aux |  grep 'apache\|mysql\|nginx\|/opt/bitnami\|php-fpm\|maria\|gonit'
root       754  0.0  0.2 293908 35936 ?        Ss   Jun17   0:02 php-fpm: master process (/opt/bitnami/php/etc/php-fpm.conf)
daemon     758  0.0  0.1 294280 27424 ?        S    Jun17   0:00 php-fpm: pool www
daemon     759  0.0  0.2 296744 34492 ?        S    Jun17   0:00 php-fpm: pool www
daemon     760  0.0  0.1 294280 27684 ?        S    Jun17   0:00 php-fpm: pool www
daemon     761  0.0  0.1 294284 29324 ?        S    Jun17   0:00 php-fpm: pool www
daemon     762  0.0  0.1 294284 27692 ?        S    Jun17   0:00 php-fpm: pool www
daemon     763  0.0  0.1 294284 27316 ?        S    Jun17   0:00 php-fpm: pool www
daemon     764  0.0  0.1 294284 27460 ?        S    Jun17   0:00 php-fpm: pool www
daemon     765  0.0  0.1 294284 27692 ?        S    Jun17   0:00 php-fpm: pool www
daemon     766  0.0  0.1 294284 27632 ?        S    Jun17   0:00 php-fpm: pool www
daemon     767  0.0  0.1 294284 27708 ?        S    Jun17   0:00 php-fpm: pool www
daemon     768  0.0  0.1 294236 29808 ?        S    Jun17   0:00 php-fpm: pool www
daemon     769  0.0  0.1 294284 28604 ?        S    Jun17   0:00 php-fpm: pool www
daemon     770  0.0  0.0 293908 10016 ?        S    Jun17   0:00 php-fpm: pool www
daemon     771  0.0  0.1 294284 28096 ?        S    Jun17   0:00 php-fpm: pool www
daemon     772  0.0  0.2 296744 34572 ?        S    Jun17   0:00 php-fpm: pool www
daemon     773  0.0  0.1 294284 27708 ?        S    Jun17   0:00 php-fpm: pool www
daemon     774  0.0  0.1 294284 27732 ?        S    Jun17   0:00 php-fpm: pool www
daemon     775  0.0  0.1 294284 29108 ?        S    Jun17   0:00 php-fpm: pool www
daemon     776  0.0  0.0 293908 10000 ?        S    Jun17   0:00 php-fpm: pool www
daemon     777  0.0  0.1 294288 27736 ?        S    Jun17   0:00 php-fpm: pool www
daemon     778  0.0  0.0 293908 10000 ?        S    Jun17   0:00 php-fpm: pool www
daemon     779  0.0  0.1 294288 27736 ?        S    Jun17   0:00 php-fpm: pool www
daemon     780  0.0  0.0 293908 10016 ?        S    Jun17   0:00 php-fpm: pool www
daemon     781  0.0  0.1 294288 27608 ?        S    Jun17   0:00 php-fpm: pool www
daemon     782  0.0  0.0 293908 10024 ?        S    Jun17   0:00 php-fpm: pool www
daemon     783  0.0  0.1 294288 27616 ?        S    Jun17   0:00 php-fpm: pool www
daemon     784  0.0  0.1 294288 27744 ?        S    Jun17   0:00 php-fpm: pool www
daemon     785  0.0  0.1 300412 31868 ?        S    Jun17   0:00 php-fpm: pool www
daemon     786  0.0  0.0 293908 10024 ?        S    Jun17   0:00 php-fpm: pool www
daemon     787  0.0  0.1 294288 27716 ?        S    Jun17   0:00 php-fpm: pool www
daemon     788  0.0  0.0 293908 10032 ?        S    Jun17   0:00 php-fpm: pool www
daemon     789  0.0  0.1 294288 27604 ?        S    Jun17   0:00 php-fpm: pool www
daemon     790  0.0  0.1 294284 27600 ?        S    Jun17   0:00 php-fpm: pool www
daemon     791  0.0  0.1 294284 27604 ?        S    Jun17   0:00 php-fpm: pool www
daemon     792  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     793  0.0  0.0 293908 10020 ?        S    Jun17   0:00 php-fpm: pool www
daemon     794  0.0  0.0 293908 10024 ?        S    Jun17   0:00 php-fpm: pool www
daemon     795  0.0  0.0 293908 10028 ?        S    Jun17   0:00 php-fpm: pool www
daemon     796  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     797  0.0  0.0 293908 10028 ?        S    Jun17   0:00 php-fpm: pool www
daemon     798  0.0  0.0 293908 10032 ?        S    Jun17   0:00 php-fpm: pool www
daemon     799  0.0  0.0 293908 10032 ?        S    Jun17   0:00 php-fpm: pool www
daemon     800  0.0  0.0 293908 10032 ?        S    Jun17   0:00 php-fpm: pool www
daemon     801  0.0  0.0 293908 10032 ?        S    Jun17   0:00 php-fpm: pool www
daemon     802  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     803  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     804  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     805  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     806  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     807  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     808  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     809  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     810  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     811  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     812  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     813  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     814  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     815  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     816  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     817  0.0  0.0 293908  9956 ?        S    Jun17   0:00 php-fpm: pool www
daemon     818  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     819  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     820  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     821  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     822  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     823  0.0  0.0 293908  9996 ?        S    Jun17   0:00 php-fpm: pool www
daemon     824  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     825  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     826  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     827  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     828  0.0  0.0 293908  9976 ?        S    Jun17   0:00 php-fpm: pool www
daemon     829  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     830  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     831  0.0  0.0 293908  9984 ?        S    Jun17   0:00 php-fpm: pool www
daemon     832  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     833  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     834  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     835  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     836  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     837  0.0  0.0 293908  9936 ?        S    Jun17   0:00 php-fpm: pool www
daemon     838  0.0  0.0 293908  9980 ?        S    Jun17   0:00 php-fpm: pool www
daemon     839  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     840  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     841  0.0  0.0 293908 10016 ?        S    Jun17   0:00 php-fpm: pool www
daemon     842  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     843  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     844  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     845  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     846  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     847  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     848  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     849  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     850  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     851  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     852  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     853  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     854  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     855  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     856  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     857  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     858  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     859  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     860  0.0  0.0 293908  9992 ?        S    Jun17   0:00 php-fpm: pool www
daemon     861  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     862  0.0  0.0 293908  9976 ?        S    Jun17   0:00 php-fpm: pool www
daemon     863  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     864  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     865  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     866  0.0  0.0 293908  9876 ?        S    Jun17   0:00 php-fpm: pool www
daemon     867  0.0  0.0 293908 11380 ?        S    Jun17   0:00 php-fpm: pool www
daemon     868  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     869  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     870  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     871  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     872  0.0  0.0 293908 10036 ?        S    Jun17   0:00 php-fpm: pool www
daemon     873  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     874  0.0  0.0 293908 10040 ?        S    Jun17   0:00 php-fpm: pool www
daemon     875  0.0  0.0 293908 11380 ?        S    Jun17   0:00 php-fpm: pool www
daemon     876  0.0  0.0 293908 10044 ?        S    Jun17   0:00 php-fpm: pool www
daemon     877  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     878  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     879  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     880  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     881  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     882  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     883  0.0  0.0 293908 10048 ?        S    Jun17   0:00 php-fpm: pool www
daemon     884  0.0  0.0 293908  9976 ?        S    Jun17   0:00 php-fpm: pool www
daemon     885  0.0  0.0 293908 10052 ?        S    Jun17   0:00 php-fpm: pool www
daemon     886  0.0  0.0 293908  9948 ?        S    Jun17   0:00 php-fpm: pool www
daemon     887  0.0  0.0 293908 10052 ?        S    Jun17   0:00 php-fpm: pool www
root       900  0.0  0.0  14772  8640 ?        Ss   Jun17   0:03 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon     903  0.0  0.0 3375308 15600 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon     908  0.0  0.0 3375308 11520 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon     957  0.0  0.1 3375308 20892 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon     974  0.0  0.1 3375308 17628 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1007  0.0  0.1 3375308 21224 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1056  0.0  0.0 3375308 15812 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1109  0.0  0.0 3375308 16084 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1172  0.0  0.0 3375308 11508 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1230  0.0  0.1 3375308 23824 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1253  0.0  0.0 3375308 12840 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1290  0.0  0.1 3375308 21660 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1426  0.0  0.1 3375308 25688 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1498  0.0  0.1 3375308 23696 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1903  0.0  0.1 3375308 23236 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1917  0.0  0.1 3375804 28440 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    1935  0.0  0.1 3375308 22168 ?       Sl   Jun17   0:00 /opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf
daemon    3752  0.0  0.0 293908 10056 ?        S    Jun17   0:00 php-fpm: pool www
root     11237  0.0  0.0 1376896 14572 ?       Ssl  11:50   0:00 gonit
root     11362  0.0  0.0   7436  4060 ?        S    11:52   0:00 /bin/bash /opt/bitnami/scripts/mariadb/start.sh
bitnami  11456  0.0  0.0   6224   888 pts/0    S+   11:53   0:00 grep apache\|mysql\|nginx\|/opt/bitnami\|php-fpm\|maria\|gonit
bitnami@ip-172-31-41-233:~$ sudo tail -60 /opt/bitnami/mariadb/logs/mysqld.log
2021-06-18 11:49:13 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-18 11:49:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-18 11:49:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-18 11:49:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-18 11:49:13 0 [ERROR] Aborting

2021-06-18 11:50:31 0 [Note] InnoDB: Using Linux native AIO
2021-06-18 11:50:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-18 11:50:31 0 [Note] InnoDB: Uses event mutexes
2021-06-18 11:50:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-18 11:50:31 0 [Note] InnoDB: Number of pools: 1
2021-06-18 11:50:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-18 11:50:31 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2021-06-18 11:50:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-18 11:50:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-18 11:50:31 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 1082858333562 between the checkpoint 1082855277226 and the end 1082858333184.
2021-06-18 11:50:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-18 11:50:31 0 [Note] InnoDB: Starting shutdown...
2021-06-18 11:50:32 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-18 11:50:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-18 11:50:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-18 11:50:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-18 11:50:32 0 [ERROR] Aborting

2021-06-18 11:52:31 0 [Note] InnoDB: Using Linux native AIO
2021-06-18 11:52:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-18 11:52:31 0 [Note] InnoDB: Uses event mutexes
2021-06-18 11:52:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-18 11:52:31 0 [Note] InnoDB: Number of pools: 1
2021-06-18 11:52:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-18 11:52:31 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2021-06-18 11:52:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-18 11:52:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-18 11:52:31 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 1082858333562 between the checkpoint 1082855277226 and the end 1082858333184.
2021-06-18 11:52:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-18 11:52:31 0 [Note] InnoDB: Starting shutdown...
2021-06-18 11:52:32 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-18 11:52:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-18 11:52:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-18 11:52:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-18 11:52:32 0 [ERROR] Aborting

2021-06-18 11:54:31 0 [Note] InnoDB: Using Linux native AIO
2021-06-18 11:54:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-18 11:54:31 0 [Note] InnoDB: Uses event mutexes
2021-06-18 11:54:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-18 11:54:31 0 [Note] InnoDB: Number of pools: 1
2021-06-18 11:54:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-18 11:54:31 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2021-06-18 11:54:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-18 11:54:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-18 11:54:31 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 1082858333562 between the checkpoint 1082855277226 and the end 1082858333184.
2021-06-18 11:54:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-06-18 11:54:31 0 [Note] InnoDB: Starting shutdown...
2021-06-18 11:54:32 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-06-18 11:54:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-06-18 11:54:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-18 11:54:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-06-18 11:54:32 0 [ERROR] Aborting

Hello @michael.leondaris,

It seems your database may be corrupted and needs to be restored. Please start by creating a backup for your database and then try recovering it by following the linked guides.

Regards,
Francisco de Paz

mysqldump: Got error: 2002: “Can’t connect to local MySQL server through socket ‘/opt/bitnami/mariadb/tmp/mysql.sock’ (111)” when trying to connect

Issue solved.

Michael