<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.error
{mso-style-name:error;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi<o:p></o:p></p>
<p class="MsoNormal">We are seeing an error in task execution , transaction is rollbacked an I believe its causing problems in deletion (fk violation)<o:p></o:p></p>
<p class="MsoNormal">Shouldn’t we have some kind of retry mechanism for deadlock ?
<o:p></o:p></p>
<p class="MsoNormal">Will be happy to get any thoughts on the matter<o:p></o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span class="error"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333;background:#E0F0FF">[root@s54-0 ~(keystone_cb2)]</span></span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333;background:#E0F0FF">#
mistral task-get-result 1ef3e610-1731-45bb-847c-25f0804ca83d</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333"><br>
<span style="background:#E0F0FF">"RemoteError: Remote error: InvalidRequestError This Session's
<b>transaction has been rolled back due to a previous exception during flush</b>. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (<em><span style="font-family:"Arial","sans-serif"">mysql_exceptions.OperationalError)
(1213, <b>'Deadlock found when trying to get lock; try restarting transaction</b>')</span></em><span class="apple-converted-space"><i> </i></span><span class="error"><i>[SQL: u'UPDATE executions_v2 SET updated_at=%s, state=%s WHERE executions_v2.id = %s'][parameters:
(datetime.datetime(2016, 1, 27, 0, 11, 30, 305004), 'SUCCESS', '1ef3e610-1731-45bb-847c-25f0804ca83d')]</i></span><em><span style="font-family:"Arial","sans-serif"">\n[u'Traceback (most recent call last):</span></em><i><br>
<em><span style="font-family:"Arial","sans-serif"">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 142, in _dispatch_and_reply</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n executor_callback))</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 186, in _dispatch</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n executor_callback)</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 129, in _do_dispatch</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n result = func(ctxt, **new_args)</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/rpc.py\", line 144, in on_action_complete</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n return self._engine.on_action_complete(action_ex_id, result)</span></em><br>
<em><span style="font-family:"Arial","sans-serif"">n', u' File \"/usr/lib/python2.7/site-packages/mistral/utils/init</span></em></i>_.py\", line 112, in _logged</span><br>
<span style="background:#E0F0FF">n return func(*args, **kw)</span><br>
<span style="background:#E0F0FF">n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/default_engine.py\", line 267, in on_action_complete</span><br>
<span style="background:#E0F0FF">n raise e</span><br>
<span style="background:#E0F0FF">n', u\"InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback().<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#333333;background:#E0F0FF"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>