{"id":5156,"status":"ok","playbook":{"id":86,"items":{"plays":1,"tasks":3,"results":3,"hosts":2,"files":1,"records":0},"arguments":{"version":null,"verbosity":0,"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/projects/RM9380/infra-inventory"],"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":30,"module_path":null,"syntax":false,"listtasks":false,"listtags":false,"step":false,"start_at_task":null,"args":["fetch_csv.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"}],"started":"2024-04-03T08:24:54.321234+01:00","ended":"2024-04-03T08:24:58.464476+01:00","duration":"00:00:04.143242","name":null,"ansible_version":"2.16.4","client_version":"1.7.1","python_version":"3.10.10","server_version":"1.7.2.dev2","status":"completed","path":"/home/ssh-gateway/ansible/projects/RM9380/fetch_csv.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"play":{"id":86,"items":{"tasks":3,"results":3},"started":"2024-04-03T08:24:54.365557+01:00","ended":"2024-04-03T08:24:58.361096+01:00","duration":"00:00:03.995539","name":"Playbook to run mysqlquery on infra4 and fetch the results","status":"completed"},"task":{"id":127,"items":{"results":1},"path":"/home/ssh-gateway/ansible/projects/RM9380/fetch_csv.yaml","tags":[],"started":"2024-04-03T08:24:55.085083+01:00","ended":"2024-04-03T08:24:56.899464+01:00","duration":"00:00:01.814381","name":"Run the script","uuid":"001851d0-75dc-735b-31aa-000000000005","action":"ansible.builtin.shell","lineno":14,"handler":false,"status":"completed","warnings":[],"deprecations":[],"exceptions":[],"file":86},"host":{"id":3299,"name":"infra_vz1","changed":2,"failed":0,"ok":3,"skipped":0,"unreachable":0},"delegated_to":[],"content":{"ansible_facts":{"discovered_interpreter_python":"/usr/bin/python"},"changed":false,"cmd":"set -o pipefail\necho \"U0VMRUNUCmRzdG9zLm5hbWUgQVMgZHN0bm9kZW5hbWUsClJFR0VYUF9TVUJTVFIoZHN0b3MubmFtZSwgJ1swLTldKycpIEFTIGRzdG5vZGVuYW1lX2N0aWQsCmRzdGhuLmhvc3RuYW1lIEFTIGRzdGhubmFtZSwKZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCBhcyBzb3VyY2VwYXRoLApmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGggYXMgbmZzc2VydmVycGF0aCwKZmlsZV9wZXJtaXNzaW9ucy5zcmNIb3N0IGFzIHN0b3JhZ2VBZGRyZXNzLApmaWxlX3Blcm1pc3Npb25zLnN0b3JhZ2VfaWQgQVMgc3RvcmFnZW5vZGVfaWQsCm9zX25vZGUuaWQgYXMgc3RvcmFnZV9jdGlkLApoYXJkX25vZGUuaG9zdG5hbWUgQVMgaGFyZG5vZGUsCmFwcF9ub2Rlcy51aWQgQVMgdWlkLApgdXNlcmAuZW1haWwgQVMgdXNlcmVtYWlsLApDT05DQVQoZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCwgIi0iLCBmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGgpIEFTIHRlbXBEYXRhCkZST00KaGl2ZXh0X2plbGFzdGljLmZpbGVfcGVybWlzc2lvbnMKSU5ORVIgSk9JTiBoaXZleHRfamVsYXN0aWMuc29mdF9ub2RlIE9OIHNvZnRfbm9kZS5pZCA9IGZpbGVfcGVybWlzc2lvbnMuc3RvcmFnZV9pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5vc19ub2RlIE9OIG9zX25vZGUuaWQgPSBzb2Z0X25vZGUub3NOb2RlX2lkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmhhcmRfbm9kZSBPTiBvc19ub2RlLmhhcmROb2RlX2lkID0gaGFyZF9ub2RlLmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmFwcF9ub2RlcyBPTiBzb2Z0X25vZGUuZW52X2lkID0gYXBwX25vZGVzLmlkCklOTkVSIEpPSU4gaGl2ZXh0X3VzZXJzLmB1c2VyYCBPTiBgdXNlcmAuaWQgPSBhcHBfbm9kZXMudWlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLnNvZnRfbm9kZSBkc3Rzb2Z0IE9OIGZpbGVfcGVybWlzc2lvbnMuc29mdE5vZGVfaWQgPSBkc3Rzb2Z0LmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLm9zX25vZGUgZHN0b3MgT04gZHN0c29mdC5vc05vZGVfaWQgPSBkc3Rvcy5pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5oYXJkX25vZGUgZHN0aG4gT04gZHN0b3MuaGFyZE5vZGVfaWQgPSBkc3Robi5pZApXSEVSRQpzdG9yYWdlX2lkIElTIE5PVCBOVUxMCkFORCBhcHBfbm9kZXMuaXNEZWxldGVkID0gMApBTkQgb3Nfbm9kZS5pc0RlbGV0ZWQgPSAwCg==\" | base64 -d > /vz/root/301/tmp/query\necho \"IyEvYmluL2Jhc2gKbXlzcWwgLXVsYXllcnNoaWZ0IC1wJ2dXZFJEYlVHbE5qVkVveHdsYXp0JyAtZSAiJChjYXQgL3RtcC9xdWVyeSkiIC1OcyB8IHRyICdcdCcgJywnID4gL3RtcC9STTkzODAtZmlsZS5jc3YK\" | base64 -d > /vz/root/301/tmp/make_csv.sh\nvzctl exec 301 'bash /tmp/make_csv.sh'\nrm -f /vz/root/301/tmp/make_csv.sh /vz/root/301/tmp/query\n","delta":"0:00:00.052266","end":"2024-04-03 07:24:56.853219","invocation":{"module_args":{"_raw_params":"set -o pipefail\necho \"U0VMRUNUCmRzdG9zLm5hbWUgQVMgZHN0bm9kZW5hbWUsClJFR0VYUF9TVUJTVFIoZHN0b3MubmFtZSwgJ1swLTldKycpIEFTIGRzdG5vZGVuYW1lX2N0aWQsCmRzdGhuLmhvc3RuYW1lIEFTIGRzdGhubmFtZSwKZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCBhcyBzb3VyY2VwYXRoLApmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGggYXMgbmZzc2VydmVycGF0aCwKZmlsZV9wZXJtaXNzaW9ucy5zcmNIb3N0IGFzIHN0b3JhZ2VBZGRyZXNzLApmaWxlX3Blcm1pc3Npb25zLnN0b3JhZ2VfaWQgQVMgc3RvcmFnZW5vZGVfaWQsCm9zX25vZGUuaWQgYXMgc3RvcmFnZV9jdGlkLApoYXJkX25vZGUuaG9zdG5hbWUgQVMgaGFyZG5vZGUsCmFwcF9ub2Rlcy51aWQgQVMgdWlkLApgdXNlcmAuZW1haWwgQVMgdXNlcmVtYWlsLApDT05DQVQoZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCwgIi0iLCBmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGgpIEFTIHRlbXBEYXRhCkZST00KaGl2ZXh0X2plbGFzdGljLmZpbGVfcGVybWlzc2lvbnMKSU5ORVIgSk9JTiBoaXZleHRfamVsYXN0aWMuc29mdF9ub2RlIE9OIHNvZnRfbm9kZS5pZCA9IGZpbGVfcGVybWlzc2lvbnMuc3RvcmFnZV9pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5vc19ub2RlIE9OIG9zX25vZGUuaWQgPSBzb2Z0X25vZGUub3NOb2RlX2lkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmhhcmRfbm9kZSBPTiBvc19ub2RlLmhhcmROb2RlX2lkID0gaGFyZF9ub2RlLmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmFwcF9ub2RlcyBPTiBzb2Z0X25vZGUuZW52X2lkID0gYXBwX25vZGVzLmlkCklOTkVSIEpPSU4gaGl2ZXh0X3VzZXJzLmB1c2VyYCBPTiBgdXNlcmAuaWQgPSBhcHBfbm9kZXMudWlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLnNvZnRfbm9kZSBkc3Rzb2Z0IE9OIGZpbGVfcGVybWlzc2lvbnMuc29mdE5vZGVfaWQgPSBkc3Rzb2Z0LmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLm9zX25vZGUgZHN0b3MgT04gZHN0c29mdC5vc05vZGVfaWQgPSBkc3Rvcy5pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5oYXJkX25vZGUgZHN0aG4gT04gZHN0b3MuaGFyZE5vZGVfaWQgPSBkc3Robi5pZApXSEVSRQpzdG9yYWdlX2lkIElTIE5PVCBOVUxMCkFORCBhcHBfbm9kZXMuaXNEZWxldGVkID0gMApBTkQgb3Nfbm9kZS5pc0RlbGV0ZWQgPSAwCg==\" | base64 -d > /vz/root/301/tmp/query\necho \"IyEvYmluL2Jhc2gKbXlzcWwgLXVsYXllcnNoaWZ0IC1wJ2dXZFJEYlVHbE5qVkVveHdsYXp0JyAtZSAiJChjYXQgL3RtcC9xdWVyeSkiIC1OcyB8IHRyICdcdCcgJywnID4gL3RtcC9STTkzODAtZmlsZS5jc3YK\" | base64 -d > /vz/root/301/tmp/make_csv.sh\nvzctl exec 301 'bash /tmp/make_csv.sh'\nrm -f /vz/root/301/tmp/make_csv.sh /vz/root/301/tmp/query\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-04-03 07:24:56.800953","stderr":"","stderr_lines":[],"stdout":"","stdout_lines":[]},"created":"2024-04-03T08:24:56.890947+01:00","updated":"2024-04-03T08:24:56.890984+01:00","started":"2024-04-03T08:24:55.137722+01:00","ended":"2024-04-03T08:24:56.880372+01:00","duration":"00:00:01.742650","changed":false,"ignore_errors":false}