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.021038
end 
2024-09-11 15:13:11.375206
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 15:13:11.354168
stderr
stderr_lines 
[]
stdout 
● mariadb.service - MariaDB 10.6.18 database server
   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─override.conf
   Active: active (running) since Tue 2024-08-20 08:02:21 BST; 3 weeks 1 days ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 1357248 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 31 (limit: 60574)
   Memory: 1.1G
   CGroup: /system.slice/mariadb.service
           └─1357248 /usr/sbin/mariadbd

Sep 11 15:10:02 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:02 554076 [Warning] Aborted connection 554076 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:02 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:02 554078 [Warning] Aborted connection 554078 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554081 [Warning] Aborted connection 554081 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554084 [Warning] Aborted connection 554084 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554086 [Warning] Aborted connection 554086 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554088 [Warning] Aborted connection 554088 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:23 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:23 554093 [Warning] Aborted connection 554093 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:10:56 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:56 554099 [Warning] Aborted connection 554099 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:11:24 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:11:24 554106 [Warning] Aborted connection 554106 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
Sep 11 15:12:24 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:12:24 554128 [Warning] Aborted connection 554128 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
stdout_lines 
[
    "\u25cf mariadb.service - MariaDB 10.6.18 database server",
    "   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)",
    "  Drop-In: /etc/systemd/system/mariadb.service.d",
    "           \u2514\u2500override.conf",
    "   Active: active (running) since Tue 2024-08-20 08:02:21 BST; 3 weeks 1 days ago",
    "     Docs: man:mariadbd(8)",
    "           https://mariadb.com/kb/en/library/systemd/",
    " Main PID: 1357248 (mariadbd)",
    "   Status: \"Taking your SQL requests now...\"",
    "    Tasks: 31 (limit: 60574)",
    "   Memory: 1.1G",
    "   CGroup: /system.slice/mariadb.service",
    "           \u2514\u25001357248 /usr/sbin/mariadbd",
    "",
    "Sep 11 15:10:02 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:02 554076 [Warning] Aborted connection 554076 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:02 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:02 554078 [Warning] Aborted connection 554078 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554081 [Warning] Aborted connection 554081 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554084 [Warning] Aborted connection 554084 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554086 [Warning] Aborted connection 554086 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:03 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:03 554088 [Warning] Aborted connection 554088 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:23 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:23 554093 [Warning] Aborted connection 554093 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:10:56 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:10:56 554099 [Warning] Aborted connection 554099 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:11:24 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:11:24 554106 [Warning] Aborted connection 554106 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)",
    "Sep 11 15:12:24 emerald-orca.man-1.vm.plesk-server.com mariadbd[1357248]: 2024-09-11 15:12:24 554128 [Warning] Aborted connection 554128 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)"
]