Ansible module mysql_variables not fetching WSREP variables

114 views Asked by At

I am using below block to fetch mysql variables.

- name: Check for wsrep_cluster_status setting
  mysql_variables:
    login_user: '{{ mysql_root_user }}'
    login_password: '{{ mysql_root_pwd }}'
    variable: wsrep_ready
  register: v_wcs
  become_user: mysql

When I execute playbook, it gives be following message:

TASK [mysql-post-patch-validation : Check for wsrep_cluster_status setting] *****************************************************************************************************************
task path: /ansible/MYSQL_PROD_PLAYBOOKS/roles/mysql-post-patch-validation/tasks/main.yml:21
fatal: [dehammy199.int.kn]: **FAILED! => {"changed": false, "msg": "Variable not available \"wsrep_ready\""}**

PLAY RECAP **********************************************************************************************************************************************************************************
dehammy199.int.kn          : ok=5    changed=0    unreachable=0    failed=1    skipped=0    rescued=0    ignored=0

However, when I use the same module to fetch other variable values not related to wsrep, for example wait_timeout, I get the results:

- name: Check for wait_timeout setting
  mysql_variables:
    login_user: '{{ mysql_root_user }}'
    login_password: '{{ mysql_root_pwd }}'
    variable: wait_timeout
  register: v_wcs_2
  become_user: mysql
 TASK [mysql-post-patch-validation : Check for wait_timeout setting] *************************************************************************************************************************
task path: /ansible/MYSQL_PROD_PLAYBOOKS/roles/mysql-post-patch-validation/tasks/main.yml:21
ok: [dehammy199.int.kn] => {"changed": false, "msg": "350"}

Is there a workaround for me to fetch wsrep related values using Ansible modules?

Yes, I can query the variable from mysql. (End result is same in all the cases.)

root@localhost [(none)]> show global status like 'wsrep_ready';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready   | ON    |
+---------------+-------+
1 row in set (0.00 sec)

root@localhost [(none)]>
0

There are 0 answers