Error on Debian 11

[ByteProTips]

I'm getting the following error on Debian 11 (x86_64):

An exception occurred during task execution. To see the full traceback, use -vvv. The error was: IndexError: list index out of range
fatal: [localhost]: FAILED! => {"changed": false, "module_stderr": "Traceback (most recent call last):\n File "/root/.ansible/tmp/ansible-tmp-1641752293.655911-42361-198139431818415/AnsiballZ_mysql_secure_installation.py", line 102, in \n _ansiballz_main()\n File "/root/.ansible/tmp/ansible-tmp-1641752293.655911-42361-198139431818415/AnsiballZ_mysql_secure_installation.py", line 94, in _ansiballz_main\n invoke_module(zipped_mod, temp_path, ANSIBALLZ_PARAMS)\n File "/root/.ansible/tmp/ansible-tmp-1641752293.655911-42361-198139431818415/AnsiballZ_mysql_secure_installation.py", line 40, in invoke_module\n runpy.run_module(mod_name='ansible.modules.mysql_secure_installation', init_globals=None, run_name='main', alter_sys=True)\n File "/usr/lib/python3.9/runpy.py", line 210, in run_module\n return _run_module_code(code, init_globals, run_name, mod_spec)\n File "/usr/lib/python3.9/runpy.py", line 97, in _run_module_code\n _run_code(code, mod_globals, init_globals,\n File "/usr/lib/python3.9/runpy.py", line 87, in _run_code\n exec(code, run_globals)\n File "/tmp/ansible_mysql_secure_installation_payload_sgcini22/ansible_mysql_secure_installation_payload.zip/ansible/modules/mysql_secure_installation.py", line 478, in \n File "/tmp/ansible_mysql_secure_installation_payload_sgcini22/ansible_mysql_secure_installation_payload.zip/ansible/modules/mysql_secure_installation.py", line 455, in main\n File "/tmp/ansible_mysql_secure_installation_payload_sgcini22/ansible_mysql_secure_installation_payload.zip/ansible/modules/mysql_secure_installation.py", line 321, in mysql_secure_installation\nIndexError: list index out of range\n", "module_stdout": "", "msg": "MODULE FAILURE\nSee stdout/stderr for the exact error", "rc": 1}

This is being invoked by an Ansible playbook I use. It works fine in CentOS, RHEL, Oracle Linux, etc. Just ran into this when testing on Debian 11 though.

[eslam-gomaa]

Thank you for posting the issue,

I'll test it on my side & get back to you

[eslam-gomaa]

I may take some time to fix it due to some busy work, if it's urgent to you please let me know.

[ByteProTips]

No worries, it's not urgent and thank you for taking a look at it.