Can't Install: unable to run systemctl start mariadb

Provider: N/A
Virtualization Type: Dedicated server
System: Ubuntu 18.04
Installation option: Yes, Full.
OLS or Enterprise? OLS
Installing from official server or mirror server?
official

Install Memcached extension for PHP?
Yes

Install LiteSpeed Memcached?
Yes

Install Memcached?
Yes

Install Redis extension for PHP?
Yes

Install Redis?
Yes

Problem:

When I try to install from the scrip , it fails and show error message:

[07.06.2020_01-47-57] [ERROR] We are not able to run systemctl start mariadb return code: 1. Fatal error, see /var/log/installLogs.txt for full details.

[07.06.2020_01-47-57] #########################################################################

Oops, something went wrong…

root@tfc:~# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code.
See “systemctl status mariadb.service” and “journalctl -xe” for details.
root@tfc:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.44 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2020-07-06 06:55:47 GMT; 37s ago
Docs: man:mysqld(8)
systemd - MariaDB Knowledge Base
Process: 15118 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 15038 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set
Process: 15030 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 15017 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 15118 (code=exited, status=1/FAILURE)

Jul 06 06:55:46 tfc.im systemd[1]: Starting MariaDB 10.1.44 database server…
Jul 06 06:55:47 tfc.im mysqld[15118]: 2020-07-06 6:55:47 139777335700608 [Note] /usr/sbin/mysqld (mysqld 10.1.44-MariaDB-0ubuntu0.18.04.1) starting as
Jul 06 06:55:47 tfc.im mysqld[15118]: 2020-07-06 6:55:47 139777335700608 [Warning] Can’t create test file /var/lib/mysql/tfc.lower-test
Jul 06 06:55:47 tfc.im mysqld[15118]: [97B blob data]
Jul 06 06:55:47 tfc.im mysqld[15118]: 2020-07-06 6:55:47 139777335700608 [ERROR] Aborting
Jul 06 06:55:47 tfc.im systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 06 06:55:47 tfc.im systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Jul 06 06:55:47 tfc.im systemd[1]: Failed to start MariaDB 10.1.44 database server.


I tried:

  • uninstalling mariadb-server,
  • moving (renaming) mysql* directories,
  • manually stopping, enabling, and starting mariadb via systemctl (which doesn’t ever start)