<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">We’re aware that some of that stuff happens once in a while. Please file a ticket, we’ll assign someone to get it investigated.</div><div class=""><br class=""><div class="">
<div class="">Renat Akhmerov</div><div class="">@ Mirantis Inc.</div><div class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On 27 Jan 2016, at 19:30, Shtilman, Tomer (Nokia - IL) <<a href="mailto:tomer.shtilman@nokia.com" class="">tomer.shtilman@nokia.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hi<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">We are seeing an error in task execution , transaction is rollbacked an I believe its causing problems in deletion (fk violation)<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Shouldn’t we have some kind of retry mechanism for deadlock ?<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Will be happy to get any thoughts on the matter<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Thanks<o:p class=""></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span class="error"><span style="font-size: 10.5pt; font-family: Arial, sans-serif; color: rgb(51, 51, 51); background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">[root@s54-0 ~(keystone_cb2)]</span></span><span style="font-size: 10.5pt; font-family: Arial, sans-serif; color: rgb(51, 51, 51); background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class=""># mistral task-get-result 1ef3e610-1731-45bb-847c-25f0804ca83d</span><span style="font-size: 10.5pt; font-family: Arial, sans-serif; color: rgb(51, 51, 51);" class=""><br class=""><span style="background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">"RemoteError: Remote error: InvalidRequestError This Session's<span class="Apple-converted-space"> </span><b class="">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 class=""><span style="font-family: Arial, sans-serif;" class="">mysql_exceptions.OperationalError) (1213,<span class="Apple-converted-space"> </span><b class="">'Deadlock found when trying to get lock; try restarting transaction</b>')</span></em><span class="apple-converted-space"><i class=""> </i></span><span class="error"><i class="">[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 class=""><span style="font-family: Arial, sans-serif;" class="">\n[u'Traceback (most recent call last):</span></em><i class=""><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 142, in _dispatch_and_reply</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n executor_callback))</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 186, in _dispatch</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n executor_callback)</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 129, in _do_dispatch</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n result = func(ctxt, **new_args)</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/rpc.py\", line 144, in on_action_complete</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n return self._engine.on_action_complete(action_ex_id, result)</span></em><br class=""><em class=""><span style="font-family: Arial, sans-serif;" class="">n', u' File \"/usr/lib/python2.7/site-packages/mistral/utils/init</span></em></i>_.py\", line 112, in _logged</span><br class=""><span style="background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">n return func(*args, **kw)</span><br class=""><span style="background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/default_engine.py\", line 267, in on_action_complete</span><br class=""><span style="background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">n raise e</span><br class=""><span style="background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class="">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 class=""></o:p></span></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 10.5pt; font-family: Arial, sans-serif; color: rgb(51, 51, 51); background-color: rgb(224, 240, 255); background-position: initial initial; background-repeat: initial initial;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">__________________________________________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">OpenStack Development Mailing List (not for usage questions)</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Unsubscribe:<span class="Apple-converted-space"> </span></span><a href="mailto:OpenStack-dev-request@lists.openstack.org" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">OpenStack-dev-request@lists.openstack.org</a><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">?subject:unsubscribe</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a></div></blockquote></div><br class=""></div></body></html>