[WordPress] AWS EC2 t3a.medium Wordpress/MariaDb WILL NOT start about vms HOT 6 CLOSED

I would like to add we had another site with same issue last week. MariaDB would not restart, in the end we ditched the instance and relaunched a new one. We setup an alarm on it to reboot. Even that new instance reboots several times a day.

from vms.

Bit more info after a failed mariadb restart:

2024-02-19 11:27:11 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 4436
2024-02-19 11:27:11 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 11:27:11 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 11:27:11 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 11:27:11 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 11:27:11 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:27:11 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:27:11 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 11:27:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 11:27:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 11:27:11 0 [ERROR] Failed to initialize plugins.
2024-02-19 11:27:11 0 [ERROR] Aborting
2024-02-19 11:28:38 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 4440
2024-02-19 11:28:38 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 11:28:38 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 11:28:38 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 11:28:38 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 11:28:38 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:28:38 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:28:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 11:28:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 11:28:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 11:28:38 0 [ERROR] Failed to initialize plugins.
2024-02-19 11:28:38 0 [ERROR] Aborting
2024-02-19 11:47:54 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 2977
2024-02-19 11:47:54 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 11:47:54 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 11:47:54 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 11:47:54 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 11:47:55 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:47:55 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 11:47:55 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 11:47:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 11:47:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 11:47:55 0 [ERROR] Failed to initialize plugins.
2024-02-19 11:47:55 0 [ERROR] Aborting
2024-02-19 12:00:52 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 3055
2024-02-19 12:00:52 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 12:00:52 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 12:00:52 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 12:00:52 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 12:00:52 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 12:00:52 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 12:00:52 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 12:00:52 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 12:00:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 12:00:52 0 [ERROR] Failed to initialize plugins.
2024-02-19 12:00:52 0 [ERROR] Aborting
2024-02-19 12:26:46 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 3425
2024-02-19 12:26:46 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 12:26:46 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 12:26:46 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 12:26:46 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 12:26:46 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 12:26:46 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 12:26:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 12:26:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 12:26:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 12:26:46 0 [ERROR] Failed to initialize plugins.
2024-02-19 12:26:46 0 [ERROR] Aborting
2024-02-19 13:53:38 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 4859
2024-02-19 13:53:38 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 13:53:38 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 13:53:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 13:53:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 13:53:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 13:53:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-02-19 13:53:38 0 [ERROR] Aborting
2024-02-19 13:54:45 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 4862
2024-02-19 13:54:45 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 13:54:45 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 13:54:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-02-19 13:54:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-02-19 13:54:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-19 13:54:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-02-19 13:54:45 0 [ERROR] Aborting

from vms.

we now have an issue with a 3rd t3a.medium instance. That's 3 in a week (bitnami/wordpress stack)

Excerpt from daemon.log....

.....
Startup finished in 2.951s (kernel) + 31.931s (userspace) = 34.882s.
Feb 20 10:42:46 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 34290ms.
Feb 20 10:43:21 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 69480ms.
Feb 20 10:44:30 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 111690ms.
Feb 20 10:46:22 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 120730ms.
Feb 20 10:48:23 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 127850ms.
Feb 20 10:50:30 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 116700ms.
Feb 20 10:52:27 ip-172-31-28-30 dhclient[489]: XMT: Solicit on ens5, interval 120690ms.
Feb 20 10:53:56 ip-172-31-28-30 systemd[1]: bitnami.service: A process of this unit has been killed by the OOM killer.
Feb 20 10:53:57 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:53:57.681Z - info: Saving configuration info to disk
Feb 20 10:53:58 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:53:58.930Z - info: Stop monitoring services from gonit
Feb 20 10:53:59 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:53:59.020Z - info: Performing service stop operation for php
Feb 20 10:54:00 ip-172-31-28-30 bitnami[2015]: #33[38;5;6mphp #33[38;5;5m10:54:00.95 #33[0m#033[38;5;2mINFO #33[0m ==> php-fpm stopped
Feb 20 10:54:00 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:54:00.955Z - info: Performing service stop operation for mariadb
Feb 20 10:54:01 ip-172-31-28-30 bitnami[2015]: #33[38;5;6mmariadb #33[38;5;5m10:54:01.46 #33[0m#033[38;5;2mINFO #33[0m ==> mariadb is not running
Feb 20 10:54:01 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:54:01.462Z - info: Performing service stop operation for apache
Feb 20 10:54:02 ip-172-31-28-30 bitnami[2015]: #33[38;5;6mapache #33[38;5;5m10:54:02.99 #33[0m#033[38;5;2mINFO #33[0m ==> apache stopped
Feb 20 10:54:02 ip-172-31-28-30 bitnami[2015]: 2024-02-20T10:54:02.993Z - info: Skipping service stop operation for varnish
Feb 20 10:54:03 ip-172-31-28-30 systemd[1]: bitnami.service: Failed with result 'oom-kill'.

oom-kill?

from vms.

Hi @NEOROMAH,

2024-02-19 12:00:52 0 [ERROR] mysqld: File '/opt/bitnami/mariadb/data/aria_log_control' not found (Errcode: 13 "Permission denied")
2024-02-19 12:00:52 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control'
2024-02-19 12:00:52 0 [ERROR] Plugin 'Aria' init function returned error.
2024-02-19 12:00:52 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-02-19 12:00:52 0 [ERROR] InnoDB: The data file './ibdata1' must be writable
2024-02-19 12:00:52 0 [ERROR] InnoDB: The data file './ibdata1' must be writable

It seems you broke the permissions configuration. I suggest you launch a fresh VM (either in the cloud or locally) and compare the permissions configuration of the /opt/bitnami/mariadb/data folder between the 2 instances.

Thanks

from vms.

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.

from vms.

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.

from vms.