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
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)