{"id":12082,"status":"changed","playbook":{"id":255,"items":{"plays":1,"tasks":3,"results":3,"hosts":2,"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/hosts_CTListFromObasDB"],"listhosts":false,"subset":"kuly-c7-uk.uk.easy-server.com","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":["projects/RM9556/RM9556.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"},{"id":13,"name":"plesk"},{"id":27,"name":"subset:kuly-c7-uk.uk.easy-server.com"},{"id":28,"name":"monitoring"},{"id":29,"name":"loadavg"}],"started":"2024-05-08T11:01:07.134306+01:00","ended":"2024-05-08T11:01:10.588741+01:00","duration":"00:00:03.454435","name":"RM9556.yaml","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/RM9556/RM9556.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"play":{"id":255,"items":{"tasks":3,"results":3},"started":"2024-05-08T11:01:07.210451+01:00","ended":"2024-05-08T11:01:10.482847+01:00","duration":"00:00:03.272396","name":"Playbook to get the loadverages and create a csv","status":"completed"},"task":{"id":380,"items":{"results":1},"path":"/home/ssh-gateway/ansible/projects/RM9556/RM9556.yaml","tags":[],"started":"2024-05-08T11:01:09.406849+01:00","ended":"2024-05-08T11:01:10.430973+01:00","duration":"00:00:01.024124","name":"Execute uploaded script","uuid":"001851d0-75dc-bb62-8f5f-0000000001e4","action":"ansible.builtin.shell","lineno":29,"handler":false,"status":"completed","warnings":[],"deprecations":[],"exceptions":[],"file":255},"host":{"id":6339,"name":"kuly-c7-uk.uk.easy-server.com","changed":1,"failed":0,"ok":3,"skipped":0,"unreachable":0},"delegated_to":[{"id":6339,"name":"kuly-c7-uk.uk.easy-server.com","changed":1,"failed":0,"ok":3,"skipped":0,"unreachable":0}],"content":{"changed":true,"msg":"All items completed","results":[{"ansible_loop_var":"item","changed":true,"cmd":"set -o pipefail\necho \"#!/bin/bash\nTOKEN=$(sqlite3 /usr/local/psa/var/modules/monitoring/monitoring.sqlite3 \"SELECT value FROM params WHERE name = 'rrd_api_auth_token'\")\nHOSTNAME=$(hostname -f)\nfrom=$(date -u -d '30 days ago' +\"%Y-%m-%dT%H:%M:%S.%NZ\")\nto=$(date -u +\"%Y-%m-%dT%H:%M:%S.%NZ\")\nstartTime=$(date -u +\"%s%3N\")\n\ncurl -s -k https://$HOSTNAME:8443/modules/monitoring/public/index.php/$TOKEN/query --data '{\n    \"interval\": \"1h\",\n    \"intervalMs\": 3600000,\n    \"maxDataPoints\": 778,\n    \"range\": {\n        \"from\": \"'\"$from\"'\",\n        \"raw\": {\n            \"from\": \"now-30d\",\n            \"to\": \"now\"\n        },\n        \"to\": \"'\"$to\"'\"\n    },\n    \"rangeRaw\": {\n        \"from\": \"now-30d\",\n        \"to\": \"now\"\n    },\n    \"scopedVars\": {\n        \"__interval\": {\n            \"text\": \"1h\",\n            \"value\": \"1h\"\n        },\n        \"__interval_ms\": {\n            \"text\": \"3600000\",\n            \"value\": 3600000\n        }\n    },\n    \"startTime\": '$startTime',\n    \"targets\": [\n        {\n            \"target\": \"load:load:midterm\",\n            \"type\": \"timeserie\"\n        }\n    ]\n}' | jq -r '.[].datapoints[] | [.[] | tostring] | join(\",\")'| sort -n  |  awk -v hst=$HOSTNAME -F ',' '{print hst\",\" $1 \",\" strftime(\"%Y-%m-%d %H:%M:%S\", $2/1000)}' | tail -1\n\" > /tmp/get_loadavg.sh\nchmod 755 get_loadavg.sh\n/tmp/get_loadavg.sh\n","delta":"0:00:00.164036","end":"2024-05-08 11:01:10.330638","failed":false,"invocation":{"module_args":{"_raw_params":"set -o pipefail\necho \"#!/bin/bash\nTOKEN=$(sqlite3 /usr/local/psa/var/modules/monitoring/monitoring.sqlite3 \"SELECT value FROM params WHERE name = 'rrd_api_auth_token'\")\nHOSTNAME=$(hostname -f)\nfrom=$(date -u -d '30 days ago' +\"%Y-%m-%dT%H:%M:%S.%NZ\")\nto=$(date -u +\"%Y-%m-%dT%H:%M:%S.%NZ\")\nstartTime=$(date -u +\"%s%3N\")\n\ncurl -s -k https://$HOSTNAME:8443/modules/monitoring/public/index.php/$TOKEN/query --data '{\n    \"interval\": \"1h\",\n    \"intervalMs\": 3600000,\n    \"maxDataPoints\": 778,\n    \"range\": {\n        \"from\": \"'\"$from\"'\",\n        \"raw\": {\n            \"from\": \"now-30d\",\n            \"to\": \"now\"\n        },\n        \"to\": \"'\"$to\"'\"\n    },\n    \"rangeRaw\": {\n        \"from\": \"now-30d\",\n        \"to\": \"now\"\n    },\n    \"scopedVars\": {\n        \"__interval\": {\n            \"text\": \"1h\",\n            \"value\": \"1h\"\n        },\n        \"__interval_ms\": {\n            \"text\": \"3600000\",\n            \"value\": 3600000\n        }\n    },\n    \"startTime\": '$startTime',\n    \"targets\": [\n        {\n            \"target\": \"load:load:midterm\",\n            \"type\": \"timeserie\"\n        }\n    ]\n}' | jq -r '.[].datapoints[] | [.[] | tostring] | join(\",\")'| sort -n  |  awk -v hst=$HOSTNAME -F ',' '{print hst\",\" $1 \",\" strftime(\"%Y-%m-%d %H:%M:%S\", $2/1000)}' | tail -1\n\" > /tmp/get_loadavg.sh\nchmod 755 get_loadavg.sh\n/tmp/get_loadavg.sh\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}},"item":"kuly-c7-uk.uk.easy-server.com","msg":"","rc":0,"start":"2024-05-08 11:01:10.166602","stderr":"chmod: cannot access 'get_loadavg.sh': No such file or directory\njq: error: syntax error, unexpected ',' (Unix shell quoting issues?) at <top-level>, line 1:\n.[].datapoints[] | [.[] | tostring] | join(,)                                           \njq: 1 compile error\nawk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}\nawk: cmd. line:1:              ^ syntax error\nawk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}\nawk: cmd. line:1:                         ^ syntax error\nawk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}\nawk: cmd. line:1:                                    ^ syntax error\nawk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}\nawk: cmd. line:1:                                             ^ unterminated regexp\nawk: cmd. line:2: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}\nawk: cmd. line:2:                                                   ^ unexpected newline or end of string\n(23) Failed writing body","stderr_lines":["chmod: cannot access 'get_loadavg.sh': No such file or directory","jq: error: syntax error, unexpected ',' (Unix shell quoting issues?) at <top-level>, line 1:",".[].datapoints[] | [.[] | tostring] | join(,)                                           ","jq: 1 compile error","awk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}","awk: cmd. line:1:              ^ syntax error","awk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}","awk: cmd. line:1:                         ^ syntax error","awk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}","awk: cmd. line:1:                                    ^ syntax error","awk: cmd. line:1: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}","awk: cmd. line:1:                                             ^ unterminated regexp","awk: cmd. line:2: {print hst,  , strftime(%Y-%m-%d %H:%M:%S, /1000)}","awk: cmd. line:2:                                                   ^ unexpected newline or end of string","(23) Failed writing body"],"stdout":"","stdout_lines":[]}]},"created":"2024-05-08T11:01:10.411937+01:00","updated":"2024-05-08T11:01:10.411974+01:00","started":"2024-05-08T11:01:09.458608+01:00","ended":"2024-05-08T11:01:10.401630+01:00","duration":"00:00:00.943022","changed":true,"ignore_errors":false}