{"id":799696,"status":"ok","playbook":{"id":5058,"items":{"plays":1,"tasks":6,"results":1689,"hosts":395,"files":1,"records":0},"arguments":{"version":null,"verbosity":2,"private_key_file":"/home/ssh-gateway/.ssh/id_rsa","remote_user":"root","connection":"ssh","timeout":null,"ssh_common_args":null,"sftp_extra_args":null,"scp_extra_args":null,"ssh_extra_args":null,"ask_pass":false,"connection_password_file":null,"force_handlers":false,"flush_cache":false,"become":false,"become_method":"sudo","become_user":null,"become_ask_pass":false,"become_password_file":null,"tags":["all"],"skip_tags":[],"check":false,"diff":false,"inventory":["/home/ssh-gateway/ansible/ansible-luca/bash-kvm-inventory-prod.sh"],"listhosts":false,"subset":null,"extra_vars":"Not saved by ARA as configured by 'ignored_arguments'","vault_ids":[],"ask_vault_pass":false,"vault_password_files":[],"forks":20,"module_path":null,"syntax":false,"listtasks":false,"listtags":false,"step":false,"start_at_task":null,"args":["eol-checker.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"}],"started":"2026-02-02T22:07:25.483296Z","ended":"2026-02-02T22:10:41.316233Z","duration":"00:03:15.832937","name":null,"ansible_version":"2.16.11","client_version":"1.7.4","python_version":"3.10.10","server_version":"1.7.4","status":"failed","path":"/home/ssh-gateway/ansible/ansible-luca/eol-checker.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"play":{"id":5562,"items":{"tasks":6,"results":1689},"started":"2026-02-02T22:07:25.626898Z","ended":"2026-02-02T22:10:22.064203Z","duration":"00:02:56.437305","name":"RM10252 - PHP EOL Checker","status":"completed"},"task":{"id":12242,"items":{"results":392},"path":"/home/ssh-gateway/ansible/ansible-luca/eol-checker.yaml","tags":[],"started":"2026-02-02T22:09:21.246245Z","ended":"2026-02-02T22:09:36.188908Z","duration":"00:00:14.942663","name":"Query domains using active EOL Plesk PHP handlers","uuid":"001851d0-75dc-49b8-1713-000000000190","action":"ansible.builtin.command","lineno":34,"handler":false,"status":"failed","warnings":[],"deprecations":[],"exceptions":[],"file":7215},"host":{"id":289894,"name":"amber-morning.man-1.vm.plesk-server.com","changed":0,"failed":1,"ok":3,"skipped":0,"unreachable":0},"delegated_to":[],"content":{"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":"--------------\nselect 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)'\n--------------\n\nERROR 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'\n  AND h.php_handler_id R...' at line 1\nexit 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":[]},"created":"2026-02-02T22:09:28.390271Z","updated":"2026-02-02T22:09:28.390297Z","started":"2026-02-02T22:09:27.777814Z","ended":"2026-02-02T22:09:28.383209Z","duration":"00:00:00.605395","changed":false,"ignore_errors":false}