{"id":160303,"status":"failed","playbook":{"id":1976,"items":{"plays":1,"tasks":6,"results":6,"hosts":1,"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/kuly/bash-kvm-inventory-dev.sh"],"listhosts":false,"subset":"ns1-test.man-1.solus.stage.town","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":["install_superDNS.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"},{"id":126,"name":"subset:ns1-test.man-1.solus.stage.town"}],"started":"2024-09-18T10:46:31.765714+01:00","ended":"2024-09-18T10:47:24.582617+01:00","duration":"00:00:52.816903","name":null,"ansible_version":"2.16.11","client_version":"1.7.2","python_version":"3.10.10","server_version":"1.7.2","status":"failed","path":"/home/ssh-gateway/ansible/kuly/install_superDNS.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"play":{"id":2292,"items":{"tasks":6,"results":6},"started":"2024-09-18T10:46:31.814192+01:00","ended":"2024-09-18T10:47:24.485242+01:00","duration":"00:00:52.671050","name":"Playbook to install SuperDNS PDNS on alma8","status":"completed"},"task":{"id":4866,"items":{"results":1},"path":"/home/ssh-gateway/ansible/kuly/install_superDNS.yaml","tags":[],"started":"2024-09-18T10:47:23.940751+01:00","ended":"2024-09-18T10:47:24.437642+01:00","duration":"00:00:00.496891","name":"Create powertdns database","uuid":"001851d0-75dc-ad04-d5ca-00000000002a","action":"ansible.builtin.shell","lineno":63,"handler":false,"status":"failed","warnings":[],"deprecations":[],"exceptions":[],"file":3917},"host":{"id":67209,"name":"ns1-test.man-1.solus.stage.town","changed":1,"failed":1,"ok":5,"skipped":0,"unreachable":0},"delegated_to":[],"content":{"changed":false,"cmd":"set -o pipefail\nmysql -e \"CREATE DATABASE powerdns\"\nmysql -e \"CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'Lu6B1jvVEFvU'\"\nmysql -e \"GRANT ALL PRIVILEGES ON powerdns.* TO 'powerdns'@'localhost'\"\nmysql -e \"flush privileges\"\nmysql powerdns < /usr/share/doc/pdns-backend-mysql/schema.mysql.sql\n","delta":"0:00:00.038742","end":"2024-09-18 09:47:24.392909","invocation":{"module_args":{"_raw_params":"set -o pipefail\nmysql -e \"CREATE DATABASE powerdns\"\nmysql -e \"CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'Lu6B1jvVEFvU'\"\nmysql -e \"GRANT ALL PRIVILEGES ON powerdns.* TO 'powerdns'@'localhost'\"\nmysql -e \"flush privileges\"\nmysql powerdns < /usr/share/doc/pdns-backend-mysql/schema.mysql.sql\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":"non-zero return code","rc":1,"start":"2024-09-18 09:47:24.354167","stderr":"ERROR 1049 (42000): Unknown database 'powerdns'\nERROR 1049 (42000): Unknown database 'powerdns'\nERROR 1049 (42000): Unknown database 'powerdns'\nERROR 1049 (42000): Unknown database 'powerdns'\nERROR 1049 (42000): Unknown database 'powerdns'","stderr_lines":["ERROR 1049 (42000): Unknown database 'powerdns'","ERROR 1049 (42000): Unknown database 'powerdns'","ERROR 1049 (42000): Unknown database 'powerdns'","ERROR 1049 (42000): Unknown database 'powerdns'","ERROR 1049 (42000): Unknown database 'powerdns'"],"stdout":"","stdout_lines":[]},"created":"2024-09-18T10:47:24.430870+01:00","updated":"2024-09-18T10:47:24.430902+01:00","started":"2024-09-18T10:47:23.991583+01:00","ended":"2024-09-18T10:47:24.424694+01:00","duration":"00:00:00.433111","changed":false,"ignore_errors":false}