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

Bug 1524518

Summary:	MySQL Open Files Limit validation - fails for access denied error from mysql
Product:	Red Hat OpenStack	Reporter:	Ola Pavlenko <opavlenk>
Component:	openstack-tripleo-validations	Assignee:	Florian Fuchs <flfuchs>
Status:	CLOSED CURRENTRELEASE	QA Contact:	nlevinki <nlevinki>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	12.0 (Pike)	CC:	augol, beth.white, gchamoul, jjoyce, jschluet, slinaber, tvignaud, ukalifon
Target Milestone:	---	Keywords:	Triaged, ZStream
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	openstack-tripleo-validations-9.1.1-0.20180706135914.d21e7fa.el7ost	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-07-30 10:42:27 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:	1648921
Bug Blocks:

Description Ola Pavlenko 2017-12-11 16:05:54 UTC

Description of problem:
The validation on containerized overcloud fails on get open_files_limit with access denied for user 'root'@'localhost' error.


Version-Release number of selected component (if applicable):

openstack-tripleo-validations-7.4.2-1.el7ost.noarch
How reproducible:

always
Steps to Reproduce:
1. deploy containerized overcloud
2. run the post deployment validation
3.

Actual results:
validation fails 

Expected results:
validation succeed

Additional info:
Also to consider, the validation should execute get open files limit from  container on each controller

Comment 2 Ola Pavlenko 2017-12-20 16:31:22 UTC

Bug that might be related: https://bugzilla.redhat.com/show_bug.cgi?id=1522760

Comment 6 Florian Fuchs 2018-11-20 12:27:23 UTC

This bug has been fixed in a previous version, but cannot be verfied atm due to another bug in the same validation related to the containerization of the undercloud: 

  https://bugzilla.redhat.com/show_bug.cgi?id=1524518

Comment 7 Florian Fuchs 2018-11-20 12:29:30 UTC

(In reply to Florian Fuchs from comment #6)
> This bug has been fixed in a previous version, but cannot be verfied atm due
> to another bug in the same validation related to the containerization of the
> undercloud: 
> 
>   https://bugzilla.redhat.com/show_bug.cgi?id=1524518

The correct link is this: 

  https://bugzilla.redhat.com/show_bug.cgi?id=1648921

Comment 8 Udi Kalifon 2018-11-26 07:40:50 UTC

Currently fails on https://bugzilla.redhat.com/show_bug.cgi?id=1648921: "the MySQL-python module is required"

Comment 9 Udi Kalifon 2018-11-29 10:22:52 UTC

In puddle 2018-11-27.1 it fails with: 

Failed to handle action completion [error=Can not evaluate YAQL expression [expression=task(run_validation).result.stderr, error=Unknown function "#property#stderr", data={}], wf=tripleo.validations.v1.run_validation, task=set_status_failed, action=std.noop]:
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/mistral/engine/task_handler.py", line 110, in _on_action_complete
    task.on_action_complete(action_ex)
  File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 159, in wrapper
    result = f(*args, **kwargs)
  File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 381, in on_action_complete
    self.complete(state, state_info)
  File "/usr/lib/python2.7/site-packages/osprofiler/profiler.py", line 159, in wrapper
    result = f(*args, **kwargs)
  File "/usr/lib/python2.7/site-packages/mistral/engine/tasks.py", line 221, in complete
    data_flow.publish_variables(self.task_ex, self.task_spec)
  File "/usr/lib/python2.7/site-packages/mistral/workflow/data_flow.py", line 215, in publish_variables
    task_ex.published = expr.evaluate_recursively(branch_vars, expr_ctx)
  File "/usr/lib/python2.7/site-packages/mistral/expressions/__init__.py", line 100, in evaluate_recursively
    data[key] = _evaluate_item(data[key], context)
  File "/usr/lib/python2.7/site-packages/mistral/expressions/__init__.py", line 79, in _evaluate_item
    return evaluate(item, context)
  File "/usr/lib/python2.7/site-packages/mistral/expressions/__init__.py", line 71, in evaluate
    return evaluator.evaluate(expression, context)
  File "/usr/lib/python2.7/site-packages/mistral/expressions/yaql_expression.py", line 159, in evaluate
    cls).evaluate(trim_expr, data_context)
  File "/usr/lib/python2.7/site-packages/mistral/expressions/yaql_expression.py", line 113, in evaluate
    ", data=%s]" % (expression, str(e), data_context)
YaqlEvaluationException: Can not evaluate YAQL expression [expression=task(run_validation).result.stderr, error=Unknown function "#property#stderr", data={}]


Moving back to ON_DEV until all the dependent bugs are fixed.

Comment 16 Lon Hohberger 2019-07-30 10:42:27 UTC

According to our records, this should be resolved by openstack-tripleo-validations-9.3.2-0.20190420045626.361061f.el7ost.  This build is available now.