Job for mariadb.service failed because the control process

hi, my local server shutdown unexpectedly after that i am getting internal server error.
and mariadb is not working, i searched and tried every solution but still not starting.

**frappe@erp**:**~/frappe-bench**$ sudo 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.

the above error i am getting when i am trying to start.

the rollback command i already tried which i found from other threats but still its not working for my case.
sudo mysqld --tc-heuristic-recover=ROLLBACK

anybody plz help?

Below is the output of systemctl status mariadb.service and journalctl -xe

**frappe@erp**:**~/frappe-bench**$ sudo systemctl status mariadb.service

**●** mariadb.service - MariaDB 10.4.14 database server

Loaded: loaded (/lib/systemd/system/mariadb.service; bad; vendor preset: enab

Drop-In: /etc/systemd/system/mariadb.service.d

└─migrated-from-my.cnf-settings.conf

Active: **failed** (Result: exit-code) since Wed 2023-01-04 20:07:19 PKT; 1min 23

Docs: man:mysqld(8)

https://mariadb.com/kb/en/library/systemd/

Process: 6308 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS

Process: 6036 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR

Process: 6029 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START

Process: 6021 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/ru

Main PID: 6308 (code=exited, status=1/FAILURE)

Status: "MariaDB server is down"

Jan 04 20:07:18 erp systemd[1]: Starting MariaDB 10.4.14 database server...

Jan 04 20:07:18 erp mysqld[6308]: **2023-01-04 20:07:18 0 [Note] /usr/sbin/mysq**

Jan 04 20:07:19 erp systemd[1]: **mariadb.service: Main process exited, code=ex**

Jan 04 20:07:19 erp systemd[1]: **mariadb.service: Failed with result 'exit-cod**

Jan 04 20:07:19 erp systemd[1]: **Failed to start MariaDB 10.4.14 database serv**

Jan 04 20:08:43 erp systemd[1]: **/lib/systemd/system/mariadb.service:2: Missin**

lines 1-20/20 (END)

journalctl -xe

**frappe@erp**:**~/frappe-bench**$ sudo journalctl -xe

Jan 04 20:07:18 erp sudo[6018]: **erp : TTY=pts/1 ; PWD=/home/erp/frappe-b**

Jan 04 20:07:18 erp sudo[6018]: pam_unix(sudo:session): session opened for us

Jan 04 20:07:18 erp systemd[1]: Starting MariaDB 10.4.14 database server...

-- Subject: Unit mariadb.service has begun start-up

-- Defined-By: systemd

-- Support: http://www.ubuntu.com/support

--

-- Unit mariadb.service has begun starting up.

Jan 04 20:07:18 erp mysqld[6308]: **2023-01-04 20:07:18 0 [Note] /usr/sbin/mysq**

Jan 04 20:07:19 erp systemd[1]: **mariadb.service: Main process exited, code=ex**

Jan 04 20:07:19 erp systemd[1]: **mariadb.service: Failed with result 'exit-cod**

Jan 04 20:07:19 erp systemd[1]: **Failed to start MariaDB 10.4.14 database serv**

-- Subject: Unit mariadb.service has failed

-- Defined-By: systemd

-- Support: http://www.ubuntu.com/support

--

-- Unit mariadb.service has failed.

--

-- The result is RESULT.

Jan 04 20:07:19 erp sudo[6018]: pam_unix(sudo:session): session closed for us

Jan 04 20:08:43 erp sudo[6339]: **erp : TTY=pts/1 ; PWD=/home/erp/frappe-b**

Jan 04 20:08:43 erp sudo[6339]: pam_unix(sudo:session): session opened for us

Jan 04 20:08:43 erp systemd[1]: **/lib/systemd/system/mariadb.service:2: Missin**

lines 2156-2178/2178 (END)

anybody faced same issue?

have you find any solution?