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.015865
end 
2024-09-11 15:13:08.417226
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:08.401361
stderr
stderr_lines 
[]
stdout 
● mariadb.service - MariaDB 10.6.17 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 Wed 2024-08-21 07:26:20 BST; 3 weeks 0 days ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 140886 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 21 (limit: 28635)
   Memory: 259.6M
   CGroup: /system.slice/mariadb.service
           └─140886 /usr/sbin/mariadbd

Sep 11 14:27:56 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:27:56 177526 [Warning] Aborted connection 177526 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
Sep 11 14:28:46 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:28:46 180539 [Warning] Aborted connection 180539 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:33:48 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:33:48 180566 [Warning] Aborted connection 180566 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:38:50 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:38:50 180588 [Warning] Aborted connection 180588 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:43:52 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:43:52 180618 [Warning] Aborted connection 180618 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:48:54 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:48:54 180642 [Warning] Aborted connection 180642 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:53:56 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:53:56 180668 [Warning] Aborted connection 180668 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:58:58 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:58:58 180693 [Warning] Aborted connection 180693 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:04:00 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 15:04:00 180733 [Warning] Aborted connection 180733 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:09:02 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 15:09:02 180830 [Warning] Aborted connection 180830 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
stdout_lines 
[
    "\u25cf mariadb.service - MariaDB 10.6.17 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 Wed 2024-08-21 07:26:20 BST; 3 weeks 0 days ago",
    "     Docs: man:mariadbd(8)",
    "           https://mariadb.com/kb/en/library/systemd/",
    " Main PID: 140886 (mariadbd)",
    "   Status: \"Taking your SQL requests now...\"",
    "    Tasks: 21 (limit: 28635)",
    "   Memory: 259.6M",
    "   CGroup: /system.slice/mariadb.service",
    "           \u2514\u2500140886 /usr/sbin/mariadbd",
    "",
    "Sep 11 14:27:56 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:27:56 177526 [Warning] Aborted connection 177526 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)",
    "Sep 11 14:28:46 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:28:46 180539 [Warning] Aborted connection 180539 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:33:48 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:33:48 180566 [Warning] Aborted connection 180566 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:38:50 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:38:50 180588 [Warning] Aborted connection 180588 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:43:52 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:43:52 180618 [Warning] Aborted connection 180618 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:48:54 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:48:54 180642 [Warning] Aborted connection 180642 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:53:56 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:53:56 180668 [Warning] Aborted connection 180668 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:58:58 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 14:58:58 180693 [Warning] Aborted connection 180693 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:04:00 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 15:04:00 180733 [Warning] Aborted connection 180733 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:09:02 sharp-swift.man-1.vm.plesk-server.com mariadbd[140886]: 2024-09-11 15:09:02 180830 [Warning] Aborted connection 180830 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)"
]