yahoo-eng-team team mailing list archive

[Salvatore Orlando <1313794@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

This bug is an instance of the infamous and dreadful issue with evenlet
yielding within a transaction and causing a lock wait timeout in mysql.

In this instance the lock wait timeout error occurs because during
delete_port a yield occurs to another thread which tries to update the
status for the VIP port locked by delete_port.

Traceback here: http://logs.openstack.org/57/88057/8/check/check-
tempest-dsvm-neutron-
full/ed58255/logs/screen-q-svc.txt.gz#_2014-04-27_21_44_59_865

Occurences in past 7 days: 231 (100% failure rate, 26% of total lock
wait timeout errors)

Logstash details:
http://logstash.openstack.org/#eyJmaWVsZHMiOltdLCJzZWFyY2giOiJtZXNzYWdlOlwiKE9wZXJhdGlvbmFsRXJyb3IpICgxMjA1LCAnTG9jayB3YWl0IHRpbWVvdXQgZXhjZWVkZWQ7IHRyeSByZXN0YXJ0aW5nIHRyYW5zYWN0aW9uJylcIiBBTkQgTk9UIG1lc3NhZ2U6XCJUcmFjZWJhY2sgKG1vc3QgcmVjZW50IGNhbGwgbGFzdFwiIEFORCB0YWdzOlwic2NyZWVuLXEtc3ZjLnR4dFwiIEFORCBtZXNzYWdlOlwiVVBEQVRFIHBvcnRzIFNFVCBhZG1pbl9zdGF0ZV91cFwiIiwidGltZWZyYW1lIjoiNjA0ODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJvZmZzZXQiOjAsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxMzk4Njk5MzEwOTU4fQ==

** Affects: neutron
     Importance: High
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1313794

Title:
  lock_wait timeout caused by plug_vip_port

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  This bug is an instance of the infamous and dreadful issue with
  evenlet yielding within a transaction and causing a lock wait timeout
  in mysql.

  In this instance the lock wait timeout error occurs because during
  delete_port a yield occurs to another thread which tries to update the
  status for the VIP port locked by delete_port.

  Traceback here: http://logs.openstack.org/57/88057/8/check/check-
  tempest-dsvm-neutron-
  full/ed58255/logs/screen-q-svc.txt.gz#_2014-04-27_21_44_59_865

  Occurences in past 7 days: 231 (100% failure rate, 26% of total lock
  wait timeout errors)

  Logstash details:
  http://logstash.openstack.org/#eyJmaWVsZHMiOltdLCJzZWFyY2giOiJtZXNzYWdlOlwiKE9wZXJhdGlvbmFsRXJyb3IpICgxMjA1LCAnTG9jayB3YWl0IHRpbWVvdXQgZXhjZWVkZWQ7IHRyeSByZXN0YXJ0aW5nIHRyYW5zYWN0aW9uJylcIiBBTkQgTk9UIG1lc3NhZ2U6XCJUcmFjZWJhY2sgKG1vc3QgcmVjZW50IGNhbGwgbGFzdFwiIEFORCB0YWdzOlwic2NyZWVuLXEtc3ZjLnR4dFwiIEFORCBtZXNzYWdlOlwiVVBEQVRFIHBvcnRzIFNFVCBhZG1pbl9zdGF0ZV91cFwiIiwidGltZWZyYW1lIjoiNjA0ODAwIiwiZ3JhcGhtb2RlIjoiY291bnQiLCJvZmZzZXQiOjAsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxMzk4Njk5MzEwOTU4fQ==

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1313794/+subscriptions