Systemctl status mariadb

systemctl status mariadb
● mariadb.service - MariaDB 10.1.47 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2020-10-27 06:43:05 UTC; 5 months 15 days ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 31986 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 34 (limit: 1151)
   CGroup: /system.slice/mariadb.service
           └─31986 /usr/sbin/mysqld 

Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.

Errors

systemctl status mariadb
● mariadb.service - MariaDB 10.4.21 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Thu 2022-12-15 19:18:37 UTC; 2min 10s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 24138 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, 
status=1/FAILURE
  Process: 24044 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; 
/usr/bin/galera_recov
  Process: 24042 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, 
status=0/SUCCESS)
  Process: 24034 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, 
status=0/SUCCESS)
 Main PID: 24138 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Dec 15 19:18:31 server systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Dec 15 19:18:31 server systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 2.
Dec 15 19:18:31 server systemd[1]: Stopped MariaDB 10.4.21 database server.
Dec 15 19:18:31 server systemd[1]: Starting MariaDB 10.4.21 database server...
Dec 15 19:18:32 server mysqld[24138]: 2022-12-15 19:18:32 0 [Note] /usr/sbin/mysqld (mysqld 10.4.21-MariaDB- 1:10.4.21+maria~bionic)
Dec 15 19:18:37 server systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 15 19:18:37 server systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 15 19:18:37 server systemd[1]: Failed to start MariaDB 10.4.21 database server.

Related terms

• mysqlcheck
• mariadbcheck
• /var/log/mysql/error.log (MariaDB)

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306, /etc/mysql/