Arguments and configuration
Argument Value
version None
verbosity 1
ask_pass False
private_key_file None
remote_user None
connection smart
timeout 10
ssh_common_args
sftp_extra_args
scp_extra_args
ssh_extra_args
force_handlers True
flush_cache False
become False
become_method sudo
become_user None
become_ask_pass False
tags ['all']
skip_tags []
check False
syntax False
diff False
inventory ['/root/.ansible/test/tmp/mysql_variables-6o5livc1-ÅÑŚÌβŁÈ/test/integration/inventory']
listhosts False
subset None
extra_vars Not saved by ARA as configured by 'ignored_arguments'
vault_ids []
ask_vault_pass False
vault_password_files []
forks 5
module_path None
listtasks False
listtags False
step False
start_at_task None
args ['mysql_variables-bjwc0e66.yml']
Records No records have been saved with ara_record for this playbook.
Files
Hosts
Host Changed Failed Ok Skipped Unreachable
testhost 20 0 68 6 0
Play: testhost
Task: Gathering Facts (gather_facts)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:16 +0000
Task: setup_mysql_db : python 2 (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:17 +0000
Task: setup_mysql_db : python 3 (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:17 +0000
Task: setup_mysql_db : include_vars (include_vars)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:17 +0000
Task: setup_mysql_db : install mysqldb_test rpm dependencies (yum)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:17 +0000
Task: setup_mysql_db : install mysqldb_test rpm dependencies (dnf)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:17 +0000
Task: setup_mysql_db : install mysqldb_test debian dependencies (apt)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:01 Fri, 31 May 2019 14:58:19 +0000
Task: setup_mysql_db : install mysqldb_test FreeBSD dependencies (pkgng)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:19 +0000
Task: setup_mysql_db : install mysql-python package via pip (FreeBSD) (pip)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:19 +0000
Task: setup_mysql_db : enable mysql-server service (FreeBSD) (lineinfile)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:19 +0000
Task: setup_mysql_db : apply work-around for OverlayFS issue (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:20 +0000
Task: setup_mysql_db : restart mysql_db service (service)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:02 Fri, 31 May 2019 14:58:22 +0000
Task: setup_mysql_db : Detect socket path (shell)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:22 +0000
Task: setup_mysql_db : Set socket path (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:23 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:23 +0000
Task: mysql_variables : read mysql variables (expect changed=false) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:23 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:23 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:23 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:24 +0000
Task: mysql_variables : assert output variable info match mysql variable info (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:24 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:24 +0000
Task: mysql_variables : set mysql variable (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:25 +0000
Task: mysql_variables : update mysql variable to same value (expect changed=false) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:25 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:25 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:25 +0000
Task: mysql_variables : assert output mysql variable name and value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:26 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:26 +0000
Task: mysql_variables : set mysql variable to a temp value (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:26 +0000
Task: mysql_variables : update mysql variable value (expect changed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:26 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:27 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:27 +0000
Task: mysql_variables : assert output mysql variable name and value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:27 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:27 +0000
Task: mysql_variables : set mysql variable to a temp value (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:27 +0000
Task: mysql_variables : update mysql variable value (expect changed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:28 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:28 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:28 +0000
Task: mysql_variables : assert output mysql variable name and value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:29 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:29 +0000
Task: mysql_variables : set mysql variable to a temp value (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:29 +0000
Task: mysql_variables : update mysql variable value (expect changed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:29 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:30 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:30 +0000
Task: mysql_variables : assert output mysql variable name and value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:30 +0000
Task: mysql_variables : set mysql variable value to an expression (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:30 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:31 +0000
Task: mysql_variables : set mysql variable value to a number out of range (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:31 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:31 +0000
Task: mysql_variables : set mysql variable value to a non-valid value number (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:31 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:32 +0000
Task: mysql_variables : set a non mysql variable (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:32 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:32 +0000
Task: mysql_variables : set value of a read only mysql variable (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:32 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:33 +0000
Task: mysql_variables : create mysql user (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:34 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:34 +0000
Task: mysql_variables : query mysql_variable using login_user and password_password (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:35 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:35 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:35 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:35 +0000
Task: mysql_variables : assert output variable info match mysql variable info (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:36 +0000
Task: mysql_variables : set mysql variable to temp value using user login and password (expect changed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:36 +0000
Task: mysql_variables : update mysql variable value using user login and password (expect changed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:36 +0000
Task: mysql_variables : assert output message changed value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:36 +0000
Task: mysql_variables : run mysql command to show variable (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:37 +0000
Task: mysql_variables : assert output mysql variable name and value (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:37 +0000
Task: mysql_variables : set_fact (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:37 +0000
Task: mysql_variables : query mysql_variable using incorrect login_password (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:37 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:38 +0000
Task: mysql_variables : update mysql variable value using incorrect login_password (expect failed=true) (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:38 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:38 +0000
Task: mysql_variables : query mysql_variable using incorrect login_host (mysql_variables)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:05 Fri, 31 May 2019 14:58:43 +0000
Task: mysql_variables : assert message failure (expect failed=true) (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:44 +0000
Task: mysql_variables : remove mysql_user user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:44 +0000