If I had to guess, you are executing the module and subsequently pymysql with python2. The paths seem to indicate a python3 virtualenv, but the error indicates that you are executing Python2, with potentially a PYTHONPATH pointing to the Python3 venv.
The error is in regards to the "keyword only marker" defined at: https://github.com/PyMySQL/PyMySQL/blob/6ccbecc1a0dfd04065b081950d2d35b1dac0aaa8/pymysql/connections.py#L164-L166 On Thu, Apr 8, 2021 at 1:03 PM Nick-H <[email protected]> wrote: > I am trying to move to python 3.6 on centos 7.8 and ansible 2.8.12 > Mysql_db module fails importing connections from PyMySQL pip module. > At least with recent versions ( 0.9 ,1.0.2 ) using 0.7 pass. > > the error seems to be related to a PEP recommendation E402 . > > As per PyMySQL doc , python3 is supported . > > here is my error: > > { > "module_stdout": "", > "module_stderr": "Traceback (most recent call last):\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 114, in <module>\n _ansiballz_main()\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 106, in _ansiballz_main\n invoke_module(zipped_mod, temp_path, > ANSIBALLZ_PARAMS)\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 49, in invoke_module\n imp.load_module('__main__', mod, module, > MOD_DESC)\n File \"/tmp/ansible_mysql_db_payload_3i8jCj/__main__.py\", > line 110, in <module>\n File > \"/tmp/ansible_mysql_db_payload_3i8jCj/ansible_mysql_db_payload.zip/ansible/module_utils/mysql.py\", > line 33, in <module>\n File > \"/opt/venvs/py3_ansible28/lib/python3.6/site-packages/pymysql/__init__.py\", > line 59, in <module>\n from . import connections # noqa: E402\n File > \"/opt/venvs/py3_ansible28/lib/python3.6/site-packages/pymysql/connections.py\", > line 167\n *,\n ^\nSyntaxError: invalid syntax\n", > "exception": "Traceback (most recent call last):\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 114, in <module>\n _ansiballz_main()\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 106, in _ansiballz_main\n invoke_module(zipped_mod, temp_path, > ANSIBALLZ_PARAMS)\n File > \"/var/lib/awx/.ansible/tmp/ansible-tmp-1617903869.1782537-29212-149280496397207/AnsiballZ_mysql_db.py\", > line 49, in invoke_module\n imp.load_module('__main__', mod, module, > MOD_DESC)\n File \"/tmp/ansible_mysql_db_payload_3i8jCj/__main__.py\", > line 110, in <module>\n File > \"/tmp/ansible_mysql_db_payload_3i8jCj/ansible_mysql_db_payload.zip/ansible/module_utils/mysql.py\", > line 33, in <module>\n File > \"/opt/venvs/py3_ansible28/lib/python3.6/site-packages/pymysql/__init__.py\", > line 59, in <module>\n from . import connections # noqa: E402\n File > \"/opt/venvs/py3_ansible28/lib/python3.6/site-packages/pymysql/connections.py\", > line 167\n *,\n ^\nSyntaxError: invalid syntax\n", > "msg": "MODULE FAILURE\nSee stdout/stderr for the exact error", > "rc": 1, > "_ansible_no_log": false, > "changed": false > } > > > > -- > You received this message because you are subscribed to the Google Groups > "Ansible Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/c9a3c9a6-f31f-43fc-901f-e328d6d6b1een%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/c9a3c9a6-f31f-43fc-901f-e328d6d6b1een%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Matt Martz @sivel sivel.net -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAD8N0v9Gf8eMXQa1bC2n7W6n_RcWB6vWTDj-aXhG0KLHZJaB5w%40mail.gmail.com.
