please make ansible-test -> python better

gistfile1.txt

I tried your suggestions but somehow the integration tests are still failing

ansible-test integration test_mysql_user --docker -vvv > test.log
Fails within docker

```
Configured locale: en_US.UTF-8
RLIMIT_NOFILE: (1024, 1048576)
Falling back to tests in "tests/integration/targets/" because "roles/test/" was not found.
WARNING: Unable to determine context for the following test targets, they will be run on the target host: test_mysql_user
Assuming Docker is available on localhost.
Run command: docker -v
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Detected "docker" container runtime version: Docker version 20.10.21, build baeda1f
Starting new "ansible-test-controller-kmKNloi9" container.
Run command: docker image inspect quay.io/ansible/default-test-container:7.4.0
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Skipping pull of existing image: quay.io/ansible/default-test-container:7.4.0
Run command: docker run --volume /sys/fs/cgroup:/sys/fs/cgroup:ro --privileged=false --tmpfs /tmp:exec --tmpfs /run:exec --tmpfs /run/lock --security-opt seccomp=unconfined --volume /var/run/docker.sock:/var/run/docker ...
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Adding "ansible-test-controller-kmKNloi9" to container database.
Run command: docker container inspect 4441181bf7640feda3de4c36ed939065ca82f8a49eaea0ef5ae7aed7ee33aeb3
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Stream command with data: docker exec -i ansible-test-controller-kmKNloi9 /bin/sh
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Error response from daemon: Container 4441181bf7640feda3de4c36ed939065ca82f8a49eaea0ef5ae7aed7ee33aeb3 is not running
ERROR: Host <ansible_test._internal.host_profiles.DockerProfile object at 0x7f15ab7c97b0> job failed: Command "docker exec -i ansible-test-controller-kmKNloi9 /bin/sh" returned exit status 1.
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/provisioning.py", line 191, in dispatch_jobs
    thread.wait_for_result()
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/thread.py", line 45, in wait_for_result
    raise exception[1].with_traceback(exception[2])
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/thread.py", line 32, in run
    self._result.put((self.action(), None))
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/provisioning.py", line 132, in provision
    profile.setup()
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/host_profiles.py", line 373, in setup
    docker_exec(self.args, self.container_name, [shell], data=setup_sh, capture=False)
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/docker_util.py", line 532, in docker_exec
    return docker_command(args, ['exec'] + options + [container_id] + cmd, capture=capture, stdin=stdin, stdout=stdout, interactive=interactive,
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/docker_util.py", line 566, in docker_command
    return run_command(args, command + cmd, env=env, capture=capture, stdin=stdin, stdout=stdout, interactive=interactive, always=always,
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/util_common.py", line 448, in run_command
    return raw_command(cmd, capture=capture, env=env, data=data, cwd=cwd, explain=explain, stdin=stdin, stdout=stdout, interactive=interactive,
  File "/home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_internal/util.py", line 498, in raw_command
    raise SubprocessError(cmd, status, stdout_text, stderr_text, runtime, error_callback)

Run command: docker rm -f ansible-test-controller-kmKNloi9
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/docker
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh

```

The fact that something failing within docker definitely means this is uses in a vary highly opinionated way and runs containers in a way that is not really cross compatible with docker standard installations.

-- Without Docker it tries to create something on /root/dbdeployer ... it will not work

```
Configured locale: en_US.UTF-8
RLIMIT_NOFILE: (1024, 1048576)
Falling back to tests in "tests/integration/targets/" because "roles/test/" was not found.
WARNING: Unable to determine context for the following test targets, they will be run on the target host: test_mysql_user
Detected architecture x86_64 for Python interpreter: /usr/bin/python
Creating container database.
>>> Container Database
{}
Run command: /usr/bin/python /home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_util/target/tools/yamlcheck.py
Working directory: /home/bizmate/ansible_collections/community/mysql
Program found: /usr/bin/python
HOME=/home/bizmate
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
PATH=/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
Configuring target inventory.
>>> Inventory
[testgroup]
testhost ansible_connection="local" ansible_pipelining="yes" ansible_python_interpreter="/usr/bin/python"
Running test_mysql_user integration test role
Preparing temporary directory: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ
Copying tests/integration/targets/setup_mysql/ to /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/
Copying tests/integration/targets/setup_remote_tmp_dir/ to /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_remote_tmp_dir/
Copying tests/integration/targets/test_mysql_user/ to /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/
Copying /home/bizmate/Documents/siti-web/ansible/test/lib/ansible_test/_data/ansible.cfg to /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/integration.cfg
Copying /home/bizmate/ansible_collections/community/mysql/tests/integration/inventory to /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory
>>> Playbook: test_mysql_user-hoa8sq53.yml
[
    {
        "gather_facts": true,
        "hosts": "testhost",
        "roles": [
            "test_mysql_user"
        ],
        "vars": {
            "output_dir": "/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/output_dir"
        },
        "vars_files": []
    }
]
Initializing "/tmp/ansible-test-_2jgar4i-injector" as the temporary injector directory.
Injecting "/tmp/python-v1njphh1-ansible/python" as a execv wrapper for the "/usr/bin/python" interpreter.
Stream command: ansible-playbook test_mysql_user-hoa8sq53.yml -i inventory -vvv
Working directory: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration
Program found: /tmp/ansible-test-_2jgar4i-injector/ansible-playbook
ANSIBLE_CALLBACKS_ENABLED=junit
ANSIBLE_COLLECTIONS_PATH=/home/bizmate
ANSIBLE_CONFIG=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/integration.cfg
ANSIBLE_DEPRECATION_WARNINGS=false
ANSIBLE_DEVEL_WARNING=false
ANSIBLE_FORCE_COLOR=false
ANSIBLE_FORCE_HANDLERS=true
ANSIBLE_HOST_KEY_CHECKING=false
ANSIBLE_HOST_PATTERN_MISMATCH=error
ANSIBLE_INVENTORY=/dev/null
ANSIBLE_LIBRARY=/dev/null
ANSIBLE_PLAYBOOK_DIR=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration
ANSIBLE_PYTHON_INTERPRETER=/set/ansible_python_interpreter/in/inventory
ANSIBLE_PYTHON_MODULE_RLIMIT_NOFILE=1024
ANSIBLE_RETRY_FILES_ENABLED=false
ANSIBLE_ROLES_PATH=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets
ANSIBLE_TEST_CI=
ANSIBLE_TEST_COVERAGE=
ANSIBLE_TEST_PYTHON_INTERPRETER=/usr/bin/python
ANSIBLE_TEST_PYTHON_VERSION=3.10
ANSIBLE_WORKER_SHUTDOWN_POLL_COUNT=100
ANSIBLE_WORKER_SHUTDOWN_POLL_DELAY=0.1
HOME=/home/bizmate
INVENTORY_PATH=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory
JUNIT_OUTPUT_DIR=/home/bizmate/ansible_collections/community/mysql/tests/output/junit
JUNIT_REPLACE_OUT_OF_TREE_PATH=out-of-tree:
JUNIT_TASK_RELATIVE_PATH=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ
LC_ALL=en_US.UTF-8
LD_LIBRARY_PATH=/usr/local/cuda/lib
OUTPUT_DIR=/home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/output_dir
PAGER=/bin/cat
PATH=/tmp/ansible-test-_2jgar4i-injector:/tmp/python-v1njphh1-ansible:/home/bizmate/Documents/siti-web/ansible/bin:/home/bizmate/.nvm/versions/node/v16.13.2/bin:/home/bizmate/.phpbrew/php/php-7.4.25/bin:/home/bizmate/.rvm/gems/ruby-2.1.0/bin:/home/bizmate/.rvm/gems/ruby-2.1.0@global/bin:/home/bizmate/.rvm/rubies/ruby-2.1.0/bin:/home/bizmate/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:/home/bizmate/.rvm/bin:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/android-sdk-linux/tools:/home/bizmate/.rvm/bin:/home/bizmate/android-sdk-linux/platform-tools:/home/bizmate/.local/bin:/opt/mssql-tools/bin:/opt/mssql-tools/bin:/usr/local/cuda/bin
PYTHONPATH=/home/bizmate/Documents/siti-web/ansible/lib
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
ansible-playbook [core 2.15.0.dev0] (devel f79a54ae22) last updated 2022/11/25 13:56:19 (GMT +400)
  config file = /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/integration.cfg
  configured module search path = ['/dev/null']
  ansible python module location = /home/bizmate/Documents/siti-web/ansible/lib/ansible
  ansible collection location = /home/bizmate
  executable location = /home/bizmate/Documents/siti-web/ansible/bin/ansible-playbook
  python version = 3.10.6 (main, Nov  2 2022, 18:53:38) [GCC 11.3.0] (/usr/bin/python)
  jinja version = 3.0.3
  libyaml = True
Using /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/integration.cfg as config file
host_list declined parsing /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory as it did not pass its verify_file() method
script declined parsing /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory as it did not pass its verify_file() method
auto declined parsing /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory as it did not pass its verify_file() method
Parsed /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/inventory inventory source with ini plugin
running playbook inside collection community.mysql
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/dir.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/install.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/config.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/verify.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/issue-121.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/issue-28.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/create_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/resource_limits.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/create_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_user_password.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_user_plugin_auth.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_privs.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_privs.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_privs.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_privs.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_priv_dict.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_priv_append.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_priv_append.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_priv_subtract.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_priv_subtract.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/tls_requirements.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/remove_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/issue-29511.yaml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/issue-64560.yaml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/issue-265.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/assert_no_user.yml
statically imported: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/test_mysql_user/tasks/test_user_grants_with_roles_applied.yml
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

PLAYBOOK: test_mysql_user-hoa8sq53.yml *****************************************
1 plays in test_mysql_user-hoa8sq53.yml

PLAY [testhost] ****************************************************************

TASK [Gathering Facts] *********************************************************
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/setup.py
Pipelining is enabled.
<testhost> ESTABLISH LOCAL CONNECTION FOR USER: bizmate
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
ok: [testhost]

TASK [setup_mysql : setup_mysql | setvars | split mysql version in parts] ******
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:2
ok: [testhost] => {
    "ansible_facts": {
        "mysql_version_parts": [
            "8",
            "0",
            "22"
        ]
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | get mysql major version] ***********
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:11
ok: [testhost] => {
    "ansible_facts": {
        "mysql_major_version": "8.0"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | set the appropriate extension dependent on the mysql version] ***
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:15
ok: [testhost] => {
    "ansible_facts": {
        "mysql_compression_extension": "xz"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | set the install type] **************
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:19
ok: [testhost] => {
    "ansible_facts": {
        "install_type": "mysql"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | set install_version] ***************
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:23
ok: [testhost] => {
    "ansible_facts": {
        "install_version": "8.0.22"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | set install_tarball] ***************
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:27
ok: [testhost] => {
    "ansible_facts": {
        "install_tarball": "mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | setvars | set install_src] *******************
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/setvars.yml:31
ok: [testhost] => {
    "ansible_facts": {
        "install_src": "https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz"
    },
    "changed": false
}

TASK [setup_mysql : setup_mysql | dir | create dbdeployer directories] *********
task path: /home/bizmate/ansible_collections/community/mysql/tests/output/.tmp/integration/test_mysql_user-as_u4rr8-ÅÑŚÌβŁÈ/tests/integration/targets/setup_mysql/tasks/dir.yml:2
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/file.py
Pipelining is enabled.
<testhost> ESTABLISH LOCAL CONNECTION FOR USER: bizmate
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
failed: [testhost] (item=/opt/dbdeployer) => {
    "ansible_loop_var": "item",
    "changed": false,
    "invocation": {
        "module_args": {
            "_diff_peek": null,
            "_original_basename": null,
            "access_time": null,
            "access_time_format": "%Y%m%d%H%M.%S",
            "attributes": null,
            "follow": true,
            "force": false,
            "group": null,
            "mode": null,
            "modification_time": null,
            "modification_time_format": "%Y%m%d%H%M.%S",
            "owner": null,
            "path": "/opt/dbdeployer",
            "recurse": false,
            "selevel": null,
            "serole": null,
            "setype": null,
            "seuser": null,
            "src": null,
            "state": "directory",
            "unsafe_writes": false
        }
    },
    "item": "/opt/dbdeployer",
    "msg": "There was an issue creating /opt/dbdeployer as requested: [Errno 13] Permission denied: b'/opt/dbdeployer'",
    "path": "/opt/dbdeployer"
}
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/file.py
Pipelining is enabled.
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
failed: [testhost] (item=/opt/dbdeployer/dbdeployer_1.64.0) => {
    "ansible_loop_var": "item",
    "changed": false,
    "invocation": {
        "module_args": {
            "_diff_peek": null,
            "_original_basename": null,
            "access_time": null,
            "access_time_format": "%Y%m%d%H%M.%S",
            "attributes": null,
            "follow": true,
            "force": false,
            "group": null,
            "mode": null,
            "modification_time": null,
            "modification_time_format": "%Y%m%d%H%M.%S",
            "owner": null,
            "path": "/opt/dbdeployer/dbdeployer_1.64.0",
            "recurse": false,
            "selevel": null,
            "serole": null,
            "setype": null,
            "seuser": null,
            "src": null,
            "state": "directory",
            "unsafe_writes": false
        }
    },
    "item": "/opt/dbdeployer/dbdeployer_1.64.0",
    "msg": "There was an issue creating /opt/dbdeployer as requested: [Errno 13] Permission denied: b'/opt/dbdeployer'",
    "path": "/opt/dbdeployer/dbdeployer_1.64.0"
}
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/file.py
Pipelining is enabled.
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
failed: [testhost] (item=/root/downloads) => {
    "ansible_loop_var": "item",
    "changed": false,
    "invocation": {
        "module_args": {
            "_diff_peek": null,
            "_original_basename": null,
            "access_time": null,
            "access_time_format": "%Y%m%d%H%M.%S",
            "attributes": null,
            "follow": true,
            "force": false,
            "group": null,
            "mode": null,
            "modification_time": null,
            "modification_time_format": "%Y%m%d%H%M.%S",
            "owner": null,
            "path": "/root/downloads",
            "recurse": false,
            "selevel": null,
            "serole": null,
            "setype": null,
            "seuser": null,
            "src": null,
            "state": "directory",
            "unsafe_writes": false
        }
    },
    "item": "/root/downloads",
    "msg": "There was an issue creating /root/downloads as requested: [Errno 13] Permission denied: b'/root/downloads'",
    "path": "/root/downloads"
}
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/file.py
Pipelining is enabled.
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
failed: [testhost] (item=/root/opt/mysql) => {
    "ansible_loop_var": "item",
    "changed": false,
    "invocation": {
        "module_args": {
            "_diff_peek": null,
            "_original_basename": null,
            "access_time": null,
            "access_time_format": "%Y%m%d%H%M.%S",
            "attributes": null,
            "follow": true,
            "force": false,
            "group": null,
            "mode": null,
            "modification_time": null,
            "modification_time_format": "%Y%m%d%H%M.%S",
            "owner": null,
            "path": "/root/opt/mysql",
            "recurse": false,
            "selevel": null,
            "serole": null,
            "setype": null,
            "seuser": null,
            "src": null,
            "state": "directory",
            "unsafe_writes": false
        }
    },
    "item": "/root/opt/mysql",
    "msg": "There was an issue creating /root/opt as requested: [Errno 13] Permission denied: b'/root/opt'",
    "path": "/root/opt/mysql"
}
Using module file /home/bizmate/Documents/siti-web/ansible/lib/ansible/modules/file.py
Pipelining is enabled.
<testhost> EXEC /bin/sh -c '/usr/bin/python && sleep 0'
failed: [testhost] (item=/root/sandboxes) => {
    "ansible_loop_var": "item",
    "changed": false,
    "invocation": {
        "module_args": {
            "_diff_peek": null,
            "_original_basename": null,
            "access_time": null,
            "access_time_format": "%Y%m%d%H%M.%S",
            "attributes": null,
            "follow": true,
            "force": false,
            "group": null,
            "mode": null,
            "modification_time": null,
            "modification_time_format": "%Y%m%d%H%M.%S",
            "owner": null,
            "path": "/root/sandboxes",
            "recurse": false,
            "selevel": null,
            "serole": null,
            "setype": null,
            "seuser": null,
            "src": null,
            "state": "directory",
            "unsafe_writes": false
        }
    },
    "item": "/root/sandboxes",
    "msg": "There was an issue creating /root/sandboxes as requested: [Errno 13] Permission denied: b'/root/sandboxes'",
    "path": "/root/sandboxes"
}

PLAY RECAP *********************************************************************
testhost                   : ok=8    changed=0    unreachable=0    failed=1    skipped=0    rescued=0    ignored=0   

NOTICE: To resume at this test target, use the option: --start-at test_mysql_user
Cleaning up temporary python directory: /tmp/python-v1njphh1-ansible

```

It doesnt feel so great to have this unstable setup. If you have any suggestions please let me know