Difference between revisions of "Systemctl status mariadb"
Jump to navigation
Jump to search
| Line 87: | Line 87: | ||
== See also == | == See also == | ||
| + | * {{MariaDB logs}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
[[Category:MariaDB]] | [[Category:MariaDB]] | ||
Revision as of 07:20, 18 December 2024
Contents
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
mysqlcheckmariadbcheck/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- 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/
Advertising:
