Open Stack

Hi,

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.

Renat Akhmerov
@ Mirantis Inc.



> On 27 Jan 2016, at 19:30, Shtilman, Tomer (Nokia - IL) <tomer.shtilman at nokia.com> wrote:
> 
> Hi
> We are seeing an  error in task execution , transaction is rollbacked an I believe its causing problems in deletion (fk violation)
> Shouldn’t we have some kind of retry mechanism for deadlock ?
> Will be happy to get any thoughts on the matter
> Thanks
>  
>  
> [root at s54-0 ~(keystone_cb2)]# mistral task-get-result 1ef3e610-1731-45bb-847c-25f0804ca83d
> "RemoteError: Remote error: 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(). Original exception was: (mysql_exceptions.OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') [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')]\n[u'Traceback (most recent call last):
> n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 142, in _dispatch_and_reply
> n executor_callback))
> n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 186, in _dispatch
> n executor_callback)
> n', u' File \"/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py\", line 129, in _do_dispatch
> n result = func(ctxt, **new_args)
> n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/rpc.py\", line 144, in on_action_complete
> n return self._engine.on_action_complete(action_ex_id, result)
> n', u' File \"/usr/lib/python2.7/site-packages/mistral/utils/init_.py\", line 112, in _logged
> n return func(*args, **kw)
> n', u' File \"/usr/lib/python2.7/site-packages/mistral/engine/default_engine.py\", line 267, in on_action_complete
> n raise e
> 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().
>  
>  
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org <mailto:OpenStack-dev-request at lists.openstack.org>?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev <http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160129/3966afd1/attachment.html>