Playbook #1756
/home/ssh-gateway/ansible/kuly/check-if-mariadb.yaml
Execution
Date 11 Sep 2024 15:12:23 +0100
Duration 00:01:01.73
Controller ssh-gw-4.layershift.com
User root
Versions
Ansible 2.16.4
ara 1.7.1 / 1.7.1
Python 3.10.10
Summary
138 Hosts
3 Tasks
414 Results
1 Plays
6 Files
0 Records
remote_user:root check:False tags:all

Task result details


Field Value
changed 
False
cmd 
set -o pipefail
systemctl status mariadb.service
delta 
0:00:00.014464
end 
2024-09-11 14:13:03.735892
invocation 
{
    "module_args": {
        "_raw_params": "set -o pipefail\nsystemctl status mariadb.service\n",
        "_uses_shell": true,
        "argv": null,
        "chdir": null,
        "creates": null,
        "executable": "/bin/bash",
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
rc 
0
start 
2024-09-11 14:13:03.721428
stderr
stderr_lines 
[]
stdout 
● mariadb.service - MariaDB 10.6.19 database server
   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf, override.conf
   Active: active (running) since Wed 2024-09-11 13:53:15 UTC; 19min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 4093 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 18 (limit: 21768)
   Memory: 150.0M
   CGroup: /system.slice/mariadb.service
           └─4093 /usr/sbin/mariadbd

Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] Server socket created on IP: '127.0.0.1'.
Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] /usr/sbin/mariadbd: ready for connections.
Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: Version: '10.6.19-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] InnoDB: Buffer pool(s) load completed at 240911 13:53:15
Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com systemd[1]: Started MariaDB 10.6.19 database server.
Sep 11 13:53:25 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:25 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 13:58:27 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:58:27 53 [Warning] Aborted connection 53 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:03:29 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 14:03:29 85 [Warning] Aborted connection 85 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:08:31 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 14:08:31 154 [Warning] Aborted connection 154 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
stdout_lines 
[
    "\u25cf mariadb.service - MariaDB 10.6.19 database server",
    "   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)",
    "  Drop-In: /etc/systemd/system/mariadb.service.d",
    "           \u2514\u2500migrated-from-my.cnf-settings.conf, override.conf",
    "   Active: active (running) since Wed 2024-09-11 13:53:15 UTC; 19min ago",
    "     Docs: man:mariadbd(8)",
    "           https://mariadb.com/kb/en/library/systemd/",
    " Main PID: 4093 (mariadbd)",
    "   Status: \"Taking your SQL requests now...\"",
    "    Tasks: 18 (limit: 21768)",
    "   Memory: 150.0M",
    "   CGroup: /system.slice/mariadb.service",
    "           \u2514\u25004093 /usr/sbin/mariadbd",
    "",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] Server socket created on IP: '127.0.0.1'.",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] /usr/sbin/mariadbd: ready for connections.",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: Version: '10.6.19-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:15 0 [Note] InnoDB: Buffer pool(s) load completed at 240911 13:53:15",
    "Sep 11 13:53:15 gold-walrus.man-1.vm.plesk-server.com systemd[1]: Started MariaDB 10.6.19 database server.",
    "Sep 11 13:53:25 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:53:25 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 13:58:27 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 13:58:27 53 [Warning] Aborted connection 53 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:03:29 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 14:03:29 85 [Warning] Aborted connection 85 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:08:31 gold-walrus.man-1.vm.plesk-server.com mariadbd[4093]: 2024-09-11 14:08:31 154 [Warning] Aborted connection 154 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)"
]