Bug 1524518 - MySQL Open Files Limit validation - fails for access denied error from mysql
Summary: MySQL Open Files Limit validation - fails for access denied error from mysql
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-validations
Version: 12.0 (Pike)
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: Florian Fuchs
QA Contact: nlevinki
URL:
Whiteboard:
Depends On: 1648921
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-12-11 16:05 UTC by Ola Pavlenko
Modified: 2019-07-30 10:45 UTC (History)
8 users (show)

Fixed In Version: openstack-tripleo-validations-9.1.1-0.20180706135914.d21e7fa.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-07-30 10:42:27 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 554888 0 None None None 2018-03-28 13:15:10 UTC
OpenStack gerrit 555255 0 None None None 2018-03-28 13:14:03 UTC
OpenStack gerrit 555258 0 None None None 2018-03-28 12:16:47 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.