Attachment 9775 Details for Bug 21982 – Result of systemctl status mysql and mysqld

Result of systemctl status mysql and mysqld

systemctl mysql and mysqld (text/plain), 3.14 KB, created by Kristoffer Grundström on 2017-11-05 21:46:12 CET

(hide)

Description:

Filename:

MIME Type:

Creator: Kristoffer Grundström

Created: 2017-11-05 21:46:12 CET

Size: 3.14 KB

patch

obsolete

>[root@localhost ~]# systemctl status mysql
>Failed to dump process list, ignoring: Unit mysql.service not found.
>â mysql.service
>   Loaded: not-found (Reason: No such file or directory)
>   Active: inactive (dead)
>[root@localhost ~]# systemctl status mysqld
>â mysqld.service - MySQL database server
>   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor prese
>   Active: active (running) since sÃ¶n 2017-11-05 21:40:51 CET; 3min 1s ago
>  Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, statu
> Main PID: 1532 (mysqld)
>   Status: "Taking your SQL requests now..."
>   CGroup: /system.slice/mysqld.service
>           ââ1532 /usr/sbin/mysqld
>
>nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653
>nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057594
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit
>nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit
>nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB'  
>nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.
>lines 1-19/19 (END)...skipping...
>â mysqld.service - MySQL database server
>   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: enabled)
>   Active: active (running) since sÃ¶n 2017-11-05 21:40:51 CET; 3min 1s ago
>  Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
> Main PID: 1532 (mysqld)
>   Status: "Taking your SQL requests now..."
>   CGroup: /system.slice/mysqld.service
>           ââ1532 /usr/sbin/mysqld
>
>nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Waiting for purge to sta
>nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB:  Percona XtraDB (http://
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140575942633216 [Note] InnoDB: Dumping buffer pool(s) n
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [Warning] mysqld: GSSAPI plugin : defau
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] mysqld: Server GSSAPI error (ma
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] Plugin 'gssapi' init function r
>nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: MariaDB Audit Plugin version 1.4.2 STARTED.
>nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: Query cache is enabled with the TABLE events.
>nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  M
>nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.

[root@localhost ~]# systemctl status mysql
Failed to dump process list, ignoring: Unit mysql.service not found.
â mysql.service
   Loaded: not-found (Reason: No such file or directory)
   Active: inactive (dead)
[root@localhost ~]# systemctl status mysqld
â mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor prese
   Active: active (running) since sÃ¶n 2017-11-05 21:40:51 CET; 3min 1s ago
  Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, statu
 Main PID: 1532 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mysqld.service
           ââ1532 /usr/sbin/mysqld

nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653
nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057594
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit
nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit
nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB'  
nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.
lines 1-19/19 (END)...skipping...
â mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: enabled)
   Active: active (running) since sÃ¶n 2017-11-05 21:40:51 CET; 3min 1s ago
  Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
 Main PID: 1532 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mysqld.service
           ââ1532 /usr/sbin/mysqld

nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Waiting for purge to sta
nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB:  Percona XtraDB (http://
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140575942633216 [Note] InnoDB: Dumping buffer pool(s) n
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [Warning] mysqld: GSSAPI plugin : defau
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] mysqld: Server GSSAPI error (ma
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] Plugin 'gssapi' init function r
nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: MariaDB Audit Plugin version 1.4.2 STARTED.
nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: Query cache is enabled with the TABLE events.
nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  M
nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.

Actions: View

Attachments on bug 21982: 9775