systemctl status mariadb

Active

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.

● 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: active (running) since Thu 2022-12-15 19:44:17 UTC; 11s ago
    Docs: man:mysqld(8)
          https://mariadb.com/kb/en/library/systemd/
 Process: 24922 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
 Process: 24920 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 24797 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recov
 Process: 24795 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Process: 24785 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 24888 (mysqld)
  Status: "Taking your SQL requests now..."
   Tasks: 32 (limit: 1151)
  CGroup: /system.slice/mariadb.service
          └─24888 /usr/sbin/mysqld

Dec 15 19:44:17 server systemd[1]: Starting MariaDB 10.4.21 database server...
Dec 15 19:44:17 server mysqld[24888]: 2022-12-15 19:44:17 0 [Note] /usr/sbin/mysqld (mysqld 10.4.21-MariaDB-1:10.4.21+maria~bionic)
Dec 15 19:44:17 server systemd[1]: Started MariaDB 10.4.21 database server.
Dec 15 19:44:17 server /etc/mysql/debian-start[24929]: Upgrading MySQL tables if necessary.
Dec 15 19:44:17 server /etc/mysql/debian-start[24932]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Dec 15 19:44:17 server /etc/mysql/debian-start[24932]: Looking for 'mysql' as: /usr/bin/mysql
Dec 15 19:44:17 server /etc/mysql/debian-start[24932]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Dec 15 19:44:17 server /etc/mysql/debian-start[24932]: This installation of MariaDB is already upgraded to 10.4.21- MariaDB, use --fo
Dec 15 19:44:17 server /etc/mysql/debian-start[24940]: Checking for insecure root accounts.
Dec 15 19:44:17 server /etc/mysql/debian-start[24944]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria

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
• /var/log/mysql/mariadb-slow.log
• mysqlcheck --repair --all-databases
• systemctl restart mariadb
• systemctl restart php*

See also

• /var/log/mysql/error.log, mariadbcheck, MariaDB binary log