Difference between revisions of "Systemctl status mariadb"

From wikieduonline
Jump to navigation Jump to search
(Created page with " <pre> systemctl status mariadb ● mariadb.service - MariaDB 10.1.47 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)...")
Tags: Mobile web edit, Mobile edit
 
 
(20 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{lc}}
  
 +
== 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.
  
−
<pre>
+
 
−
systemctl status mariadb
+
● mariadb.service - MariaDB 10.4.21 database server
−
● mariadb.service - MariaDB 10.1.47 database server
 
 
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 
   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
+
  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)
 
     Docs: man:mysqld(8)
 
           https://mariadb.com/kb/en/library/systemd/
 
           https://mariadb.com/kb/en/library/systemd/
−
  Main PID: 31986 (mysqld)
+
  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..."
 
   Status: "Taking your SQL requests now..."
−
     Tasks: 34 (limit: 1151)
+
     Tasks: 32 (limit: 1151)
 
   CGroup: /system.slice/mariadb.service
 
   CGroup: /system.slice/mariadb.service
−
           └─31986 /usr/sbin/mysqld
+
           └─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.
  
−
Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
+
== Related terms ==
−
</pre>
+
* <code>[[mysqlcheck]]</code>
 +
* <code>[[mariadbcheck]]</code>
 +
* <code>[[/var/log/mysql/error.log (MariaDB)|/var/log/mysql/error.log]]</code>
 +
* [[/var/log/mysql/mariadb-slow.log]]
 +
* [[mysqlcheck --repair --all-databases]]
 +
* [[systemctl restart mariadb]]
 +
* [[systemctl restart php*]]
  
 
== See also ==
 
== See also ==
−
* {{MariaDB}}
+
* {{MariaDB logs}}
  
 
[[Category:MariaDB]]
 
[[Category:MariaDB]]

Latest revision as of 07:20, 18 December 2024

Active[edit]

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[edit]

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[edit]

See also[edit]

Retrieved from "https://www.wikieduonline.com/index.php?title=Systemctl_status_mariadb&oldid=358979"

Advertising: