Bug 1602840 - Excessive output from mistral workflows results in a DB update error during WorkflowTasks_Step2_Execution
Summary: Excessive output from mistral workflows results in a DB update error during W...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-common
Version: 13.0 (Queens)
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: z3
: 13.0 (Queens)
Assignee: Giulio Fidente
QA Contact: Yogev Rabl
URL:
Whiteboard:
: 1624254 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-07-18 15:30 UTC by Keith Schincke
Modified: 2022-08-16 08:38 UTC (History)
10 users (show)

Fixed In Version: openstack-tripleo-common-8.6.3-16.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-11-13 22:27:09 UTC
Target Upstream Version:
Embargoed:
lmarsh: needinfo-


Attachments (Terms of Use)
mistral engine.log errors (18.19 KB, text/plain)
2018-07-18 15:30 UTC, Keith Schincke
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1783740 0 None None None 2018-07-26 10:06:06 UTC
OpenStack gerrit 588083 0 'None' 'MERGED' 'Set trash_output for ceph-ansible playbook run' 2019-11-21 01:57:40 UTC
Red Hat Issue Tracker OSP-5118 0 None None None 2022-08-16 08:38:07 UTC
Red Hat Product Errata RHBA-2018:3587 0 None None None 2018-11-13 22:27:46 UTC

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


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