Description of problem: The validator "MySQL Open Files Limit" fails with error: The MySQL-python module is required. Task 'Get the open_files_limit value' failed: Host: controller-0 Message: The MySQL-python module is required. Task 'Get the open_files_limit value' failed: Host: controller-1 Message: The MySQL-python module is required. Task 'Get the open_files_limit value' failed: Host: controller-2 Message: The MySQL-python module is required. Failure! The validation failed for all hosts: * controller-0 * controller-1 * controller-2 Version-Release number of selected component (if applicable): openstack-tripleo-validations-9.3.1-0.20181008110747.4064fb7.el7ost.noarch How reproducible: 100% Steps to Reproduce: 1. Deploy OSP14 from (07-nov-2018) 2. Go to tripleo in GUI and run validator "MySQL Open Files Limit" 3. Actual results: The validator fails with error message: Message: The MySQL-python module is required. Expected results: The validator should check MySQL Open Files Limit and pass/fail with clear message. Additional info:
Ran on puddle 2018-11-27.1 [stack@undercloud-0 ~]$ rpm -q openstack-tripleo-validations openstack-tripleo-validations-9.3.1-0.20181008110752.4064fb7.el7ost.noarch Got another error: Task 'Get the open_files_limit value' failed: Host: controller-1 Message: Command `docker exec -u root -it mysql ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Task 'Get the open_files_limit value' failed: Host: controller-0 Message: Command `docker exec -u root -it mysql ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Task 'Get the open_files_limit value' failed: Host: controller-2 Message: Command `docker exec -u root -it mysql ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Failure! The validation failed for all hosts: * controller-0 * controller-1 * controller-2
I got a different error: Task 'Get the open_files_limit value' failed: Host: overcloud-controller-0 Message: Command `docker exec -u root -it mysql ulimit -n` exited with code: 1: non-zero return code stderr: the input device is not a TTY Failure! The validation failed for all hosts: * overcloud-controller-0 When running the command manually you get: rpc error: code = 2 desc = oci runtime error: exec failed: container_linux.go:247: starting container process caused "exec: \"ulimit\": executable file not found in $PATH"
The validator still fails. The execution from GUI: Task 'Get the open_files_limit value' failed: Host: controller-0 Message: Command `docker exec -u root mysql /bin/bash -c ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Task 'Get the open_files_limit value' failed: Host: controller-1 Message: Command `docker exec -u root mysql /bin/bash -c ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Task 'Get the open_files_limit value' failed: Host: controller-2 Message: Command `docker exec -u root mysql /bin/bash -c ulimit -n` exited with code: 1: non-zero return code stderr: Error response from daemon: No such container: mysql Failure! The validation failed for all hosts: * controller-0 * controller-1 * controller-2 ****Also from CLI the validator fails: (undercloud) [stack@undercloud-0 ~]$ ansible-playbook -i /usr/bin/tripleo-ansible-inventory /usr/share/openstack-tripleo-validations/validations/mysql-open-files-limit.yaml PLAY [Controller] ************************************************************************************************************************************************************************************************* TASK [Gathering Facts] ******************************************************************************************************************************************************************************************** ok: [controller-0] ok: [controller-1] ok: [controller-2] TASK [Get the open_files_limit value] ***************************************************************************************************************************************************************************** fatal: [controller-1]: FAILED! => {"changed": false, "cmd": ["docker", "exec", "-u", "root", "mysql", "/bin/bash", "-c", "ulimit -n"], "delta": "0:00:00.072744", "end": "2018-12-04 06:25:00.166422", "msg": "non-zero return code", "rc": 1, "start": "2018-12-04 06:25:00.093678", "stderr": "Error response from daemon: No such container: mysql", "stderr_lines": ["Error response from daemon: No such container: mysql"], "stdout": "", "stdout_lines": []} fatal: [controller-2]: FAILED! => {"changed": false, "cmd": ["docker", "exec", "-u", "root", "mysql", "/bin/bash", "-c", "ulimit -n"], "delta": "0:00:00.066704", "end": "2018-12-04 06:25:00.208273", "msg": "non-zero return code", "rc": 1, "start": "2018-12-04 06:25:00.141569", "stderr": "Error response from daemon: No such container: mysql", "stderr_lines": ["Error response from daemon: No such container: mysql"], "stdout": "", "stdout_lines": []} fatal: [controller-0]: FAILED! => {"changed": false, "cmd": ["docker", "exec", "-u", "root", "mysql", "/bin/bash", "-c", "ulimit -n"], "delta": "0:00:00.107945", "end": "2018-12-04 06:25:00.248511", "msg": "non-zero return code", "rc": 1, "start": "2018-12-04 06:25:00.140566", "stderr": "Error response from daemon: No such container: mysql", "stderr_lines": ["Error response from daemon: No such container: mysql"], "stdout": "", "stdout_lines": []} [WARNING]: Could not create retry file '/usr/share/openstack-tripleo-validations/validations/mysql-open-files-limit.retry'. [Errno 13] Permission denied: u'/usr/share/openstack-tripleo- validations/validations/mysql-open-files-limit.retry' PLAY RECAP ******************************************************************************************************************************************************************************************************** controller-0 : ok=1 changed=0 unreachable=0 failed=1 controller-1 : ok=1 changed=0 unreachable=0 failed=1 controller-2 : ok=1 changed=0 unreachable=0 failed=1
(undercloud) [stack@undercloud-0 ~]$ rpm -q openstack-tripleo-validations-9.3.1-0.20181008110754.4064fb7.el7ost openstack-tripleo-validations-9.3.1-0.20181008110754.4064fb7.el7ost.noarch
Verified. (undercloud) [stack@undercloud-0 ~]$ rpm -q openstack-tripleo-validations openstack-tripleo-validations-9.3.1-0.20181008110756.4064fb7.el7ost.noarch
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHEA-2019:0045