Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1648921

Summary: The validator "MySQL Open Files Limit" fails.
Product: Red Hat OpenStack Reporter: Andrey Fiodorov <afiodoro>
Component: openstack-tripleo-validationsAssignee: Gaƫl Chamoulaud <gchamoul>
Status: CLOSED ERRATA QA Contact: Andrey Fiodorov <afiodoro>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 14.0 (Rocky)CC: beth.white, gchamoul, jjoyce, jschluet, mbarnett, slinaber, tvignaud, ukalifon
Target Milestone: rcKeywords: Triaged
Target Release: 14.0 (Rocky)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-tripleo-validations-9.3.1-0.20181008110756.4064fb7.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-01-11 11:54:40 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1524518    

Description Andrey Fiodorov 2018-11-12 13:15:07 UTC
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:

Comment 7 Andrey Fiodorov 2018-11-27 16:33:50 UTC
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

Comment 8 Udi Kalifon 2018-11-27 17:28:15 UTC
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"

Comment 10 Andrey Fiodorov 2018-12-04 06:28:43 UTC
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

Comment 11 Andrey Fiodorov 2018-12-04 06:30:56 UTC
(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

Comment 13 Andrey Fiodorov 2018-12-10 09:17:57 UTC
Verified.
(undercloud) [stack@undercloud-0 ~]$ rpm -q openstack-tripleo-validations
openstack-tripleo-validations-9.3.1-0.20181008110756.4064fb7.el7ost.noarch

Comment 17 errata-xmlrpc 2019-01-11 11:54:40 UTC
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