nicira: Lock wait timeout exceeded on port operations

[Armando Migliaccio]

Stacktrace here:

http://paste.openstack.org/show/60785/

Occurence here:

http://162.209.83.206/logs/58017/16/logs/screen-q-svc.txt.gz

[Armando Migliaccio (armando-migliaccio)]

A different stacktrace:

http://paste.openstack.org/show/64714/

As observed here:

http://208.91.1.172/logs/neutron/66971/15/401354/logs/screen-q-svc.txt.gz

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/73695
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=85ddbde058d8bda0b938eb7a45ef73519a831b3b
Submitter: Jenkins
Branch: master

commit 85ddbde058d8bda0b938eb7a45ef73519a831b3b
Author: armando-migliaccio <email address hidden>
Date: Fri Feb 14 10:59:17 2014 -0800

    Fix request timeout errors during calls to NSX controller

    Sometimes two correlated exception traces are observed in
    the server log for the Neutron Server backed by NSX:
    RequestTimeout (The nsx request has timed out) and
    OperationalError (Lock wait timeout exceeded). This is
    generally described by Guru Salvatore Orlando as the,
    and I quote, the "infamous eventlet-mysql deadlock".

    This patch tries to address the issue by adding a
    cooperative yield in the nsx client code (it’s a good idea
    to call sleep(0) occasionally in any case) and also by
    avoiding the unnecessary spawning of another Greenthread
    within a call that is already executed in Greenthred
    itself.

    Closes-bug: #1267101
    Related-bug: #1279497

    Change-Id: I8e298468fb730f11a66fbd4211121ee7d3e2a548

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/havana
Review: https://review.openstack.org/75484

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/75484
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=c1942623a5ac0be5df83d9511b56bb6009b64e69
Submitter: Jenkins
Branch: stable/havana

commit c1942623a5ac0be5df83d9511b56bb6009b64e69
Author: armando-migliaccio <email address hidden>
Date: Fri Feb 14 10:59:17 2014 -0800

    Fix request timeout errors during calls to NSX controller

    Sometimes two correlated exception traces are observed in
    the server log for the Neutron Server backed by NSX:
    RequestTimeout (The nsx request has timed out) and
    OperationalError (Lock wait timeout exceeded). This is
    generally described by Guru Salvatore Orlando as the,
    and I quote, the "infamous eventlet-mysql deadlock".

    This patch tries to address the issue by adding a
    cooperative yield in the nsx client code (it’s a good idea
    to call sleep(0) occasionally in any case) and also by
    avoiding the unnecessary spawning of another Greenthread
    within a call that is already executed in Greenthred
    itself.

    Closes-bug: #1267101
    Related-bug: #1279497

    Change-Id: I8e298468fb730f11a66fbd4211121ee7d3e2a548
    (cherry picked from commit 85ddbde058d8bda0b938eb7a45ef73519a831b3b)