Execution
Date 02 Feb 2026 22:07:25 +0000
Duration 00:03:15.83
Controller ssh-gw-4.layershift.com
User root
Versions
Ansible 2.16.11
ara 1.7.4 / 1.7.4
Python 3.10.10
Summary
395 Hosts
6 Tasks
1689 Results
1 Plays
1 Files
0 Records

Task result details


Field Value
changed
False
cmd
[
    "plesk",
    "db",
    "-Ne",
    "select d.name, h.php_handler_id from domains d from hosting h on h.dom_id=d.id where h.php = 'true'\n  AND h.php_handler_id REGEXP '^plesk-php(81|80|7|5)';"
]
delta
0:00:00.014996
end
2026-02-02 22:09:28.344424
failed_when_result
False
invocation
{
    "module_args": {
        "_raw_params": null,
        "_uses_shell": false,
        "argv": [
            "plesk",
            "db",
            "-Ne",
            "select d.name, h.php_handler_id from domains d from hosting h on h.dom_id=d.id where h.php = 'true'\n  AND h.php_handler_id REGEXP '^plesk-php(81|80|7|5)';"
        ],
        "chdir": null,
        "creates": null,
        "executable": null,
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
non-zero return code
rc
1
start
2026-02-02 22:09:28.329428
stderr
--------------
select d.name, h.php_handler_id from domains d from hosting h on h.dom_id=d.id where h.php = 'true'
  AND h.php_handler_id REGEXP '^plesk-php(81|80|7|5)'
--------------

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from hosting h on h.dom_id=d.id where h.php = 'true'
  AND h.php_handler_id R...' at line 1
exit status 1
stderr_lines
[
    "--------------",
    "select d.name, h.php_handler_id from domains d from hosting h on h.dom_id=d.id where h.php = 'true'",
    "  AND h.php_handler_id REGEXP '^plesk-php(81|80|7|5)'",
    "--------------",
    "",
    "ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from hosting h on h.dom_id=d.id where h.php = 'true'",
    "  AND h.php_handler_id R...' at line 1",
    "exit status 1"
]
stdout

stdout_lines
[]