Checking order of locked tables

[Alexander Kislitsky]

For deadlocks prevention we should not only select objects in the same order, but also check the order of tables lock.
Possible lock transitions should be defined and fixed in the logic of deadlock detector.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/93678

[Alexander Kislitsky (akislitsky)]

This bug is part deadlocks detection issue and related to bug #1308115

[Mike Scherbakov (mihgen)]

Moving this to 5.1. If it affects 5.0 tests further, then we will backport patch to stable/5.0.

[Evgeniy L (rustyrobot)]

We still have this problem

http://paste.openstack.org/show/85083/
http://paste.openstack.org/show/85084/
https://fuel-jenkins.mirantis.com/job/verify-fuel-web/81/consoleFull
https://fuel-jenkins.mirantis.com/job/verify-fuel-web/84/consoleFull

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/93678
Committed: https://git.openstack.org/cgit/stackforge/fuel-web/commit/?id=9e98e0bbb001724ee38f18320991b0145ebc6a15
Submitter: Jenkins
Branch: master

commit 9e98e0bbb001724ee38f18320991b0145ebc6a15
Author: Alexander Kislitsky <email address hidden>
Date: Thu May 15 11:22:29 2014 +0400

    Checking the tables order when rows are locking

    Deadlock detector checks the order of locked tables. In case of
    not allowed locking order exception with locks and traceback
    information is raised. Detection enabled only in DEVELOPMENT
    mode. Deadlock detector only prevents the posibility of deadlocks

    Change-Id: I4097aa2ad8942bf852d0e89054e13500fbfc6646
    Closes-Bug: #1319668