I'm also having this same error, even following all the tips here the problem still occurs.
[root@vps1 ~]# service mysqld restart
Restarting mysqld (via systemctl): Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[FAILED]
[root@vps1 ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: signal) since Fri 2021-07-16 09:32:22 -03; 4s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 25722 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
Process: 25686 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 25685 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 25722 (code=killed, signal=ABRT)
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 16 09:32:22 vps1.zkservidores.com systemd[1]: mariadb.service failed.
[root@vps1 ~]# journalctl -xe
Jul 15 08:08:38 vps1.zkservidores.com postfix/pickup[30223]: warning: 5A57684460: message has been queued for 1 days
Jul 15 08:08:38 vps1.zkservidores.com postfix/pickup[30223]: 5A57684460: uid=0 from=<root>
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: 5A57684460: message-id=<20210715110838.5A57684460@vps1.zkservidores.com>
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: 5A57684460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:38 vps1.zkservidores.com postfix/cleanup[15945]: warning: 5A57684460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:39 vps1.zkservidores.com postfix/pickup[30223]: 5B4AE84460: uid=0 from=<root>
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: 5B4AE84460: message-id=<20210715110839.5B4AE84460@vps1.zkservidores.com>
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: 5B4AE84460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:39 vps1.zkservidores.com postfix/cleanup[15947]: warning: 5B4AE84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:40 vps1.zkservidores.com postfix/pickup[30223]: 8516C84460: uid=0 from=<root>
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: 8516C84460: message-id=<20210715110840.8516C84460@vps1.zkservidores.com>
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "webmaster@zkservidores.com"
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8516C84460: virtual_alias_maps map lookup problem for webmaster@zkservidores.com -- message not accepted, try again later
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "webmaster@zkservidores.com"
Jul 15 08:08:40 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8516C84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:41 vps1.zkservidores.com postfix/pickup[30223]: 8648E84460: uid=0 from=<root>
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: 8648E84460: message-id=<20210715110841.8648E84460@vps1.zkservidores.com>
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: 8648E84460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:41 vps1.zkservidores.com postfix/cleanup[15947]: warning: 8648E84460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: mariadb.service holdoff time over, scheduling restart.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Cannot add dependency job for unit systemd-vconsole-setup.service, ignoring: Unit is masked.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Stopped MariaDB 10.2.36 database server.
-- Subject: Unit mariadb.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has finished shutting down.
Jul 15 08:08:42 vps1.zkservidores.com systemd[1]: Starting MariaDB 10.2.36 database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] /usr/sbin/mysqld (mysqld 10.2.36-MariaDB) starting as process 17979 ...
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32232)
Jul 15 08:08:42 vps1.zkservidores.com postfix/pickup[30223]: warning: 8722384460: message has been queued for 5 days
Jul 15 08:08:42 vps1.zkservidores.com postfix/pickup[30223]: 8722384460: uid=0 from=<root>
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: 8722384460: message-id=<20210715110842.8722384460@vps1.zkservidores.com>
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_alias_default_maps.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8722384460: virtual_alias_maps map lookup problem for root@vps1.zkservidores.com -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: proxy:mysql:/etc/postfix/mysql-virtual_vacation.cf lookup error for "root@vps1.zkservidores.com"
Jul 15 08:08:42 vps1.zkservidores.com postfix/cleanup[15945]: warning: 8722384460: recipient_bcc_maps map lookup problem -- message not accepted, try again later
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Uses event mutexes
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Compressed tables use zlib 1.2.7
Jul 15 08:08:42 vps1.zkservidores.com mysqld[17979]: 2021-07-15 8:08:42 139974079039680 [Note] InnoDB: Using Linux native AIO
Any way to fix, besides those already informed? Did I forget something?