Bug 1602840

Summary: Excessive output from mistral workflows results in a DB update error during WorkflowTasks_Step2_Execution
Product: Red Hat OpenStack Reporter: Keith Schincke <kschinck>
Component: openstack-tripleo-commonAssignee: Giulio Fidente <gfidente>
Status: CLOSED ERRATA QA Contact: Yogev Rabl <yrabl>
Severity: medium Docs Contact:
Priority: medium    
Version: 13.0 (Queens)CC: adhingra, fiezzi, gfidente, jjoyce, johfulto, jschluet, lmarsh, mburns, slinaber, tvignaud
Target Milestone: z3Keywords: Triaged, ZStream
Target Release: 13.0 (Queens)Flags: lmarsh: needinfo-
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-tripleo-common-8.6.3-16.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-11-13 22:27:09 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:
Attachments:
Description Flags
mistral engine.log errors none

Description Keith Schincke 2018-07-18 15:30:25 UTC
Created attachment 1459739 [details]
mistral engine.log errors

Description of problem:
Completed mistral tasks attempt to  update the action_executions_v2 table with too much BLOB/TEXT information. This raises an SQL error resulting in the completion of the task not being recorded. The mistral execution does not complete and WorkflowTasks_Step2_Execution never completes. 

Version-Release number of selected component (if applicable):
RHOSP 13 GA
rpm -qa | grep mistral
openstack-mistral-executor-6.0.2-1.el7ost.noarch
python2-mistralclient-3.3.0-1.el7ost.noarch
puppet-mistral-12.4.0-0.20180329035643.ab885c4.el7ost.noarch
python2-mistral-lib-0.4.0-1.el7ost.noarch
openstack-mistral-api-6.0.2-1.el7ost.noarch
openstack-mistral-common-6.0.2-1.el7ost.noarch
python-mistral-6.0.2-1.el7ost.noarch
openstack-mistral-engine-6.0.2-1.el7ost.noarch


How reproducible:
Variable. Depends on the amount of data attempted. 

Steps to Reproduce:
1. Configure overcloud to use Ceph and use ceph-ansible to deploy
2. CephAnsiblePlaybookVerbosity to 5
3. Attempt to deploy. 

Actual results:
Overcloud deploy time out during WorkflowTasks_Step2_Execution

Expected results:
Successful overcloud deployment


Additional info:

Comment 4 Giulio Fidente 2018-10-10 12:27:45 UTC
*** Bug 1624254 has been marked as a duplicate of this bug. ***

Comment 10 Yogev Rabl 2018-10-26 17:33:20 UTC
Verified with openstack-tripleo-common-8.6.6-2.el7ost.noarch

Comment 13 errata-xmlrpc 2018-11-13 22:27:09 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/RHBA-2018:3587