Lock wait timeout in update VIP status

[Salvatore Orlando]

Please note that this bug is similar to bug 1253822. Possibly included in it (but that one is now closed), but surely not a duplicate.

The root cause is a lock wait timeout occurring while updating VIPs.
given the nature of load balancing tests, this is non critical in 90% of cases, meaning the job succeeds anyway.

But this does not mean that it's not a bug when the job does not fail.

Occurences past 7 days: 141 (15 fails)

logstash queries:
http://logstash.openstack.org/#eyJzZWFyY2giOiJ0YWdzOlwic2NyZWVuLXEtc3ZjLnR4dFwiIEFORCBtZXNzYWdlOlwiTG9jayB3YWl0IHRpbWVvdXQgZXhjZWVkZWRcIiBBTkQgbWVzc2FnZTpcIlVQREFURSB2aXBzIFNFVCBzdGF0dXNcIiBBTkQgbWVzc2FnZTpcIlJldHVybmluZyBleGNlcHRpb24gKE9wZXJhdGlvbmFsRXJyb3IpXCIiLCJmaWVsZHMiOltdLCJvZmZzZXQiOjAsInRpbWVmcmFtZSI6IjYwNDgwMCIsImdyYXBobW9kZSI6ImNvdW50IiwidGltZSI6eyJ1c2VyX2ludGVydmFsIjowfSwic3RhbXAiOjEzOTU5MjQxMDg0NTksIm1vZGUiOiIiLCJhbmFseXplX2ZpZWxkIjoiIn0=

[Salvatore Orlando (salvatore-orlando)]

with 110 hits in the past 7 days, "update vips" is now accounting for about 20% of all "lock wait timeout" errors in neutron.
Overall failure rate for the jobs where this error is hit is 20.9%

The error however occurred only 9 times in gate queue and caused no failure.
Hits are evenly distributed among patches, so hits related to "bad patches" might be ruled out.

[Elena Ezhova (eezhova)]

This bug seems to be interconnected with https://bugs.launchpad.net/neutron/+bug/1312964
The failure happens when one test tries to delete VIP and its port while some other process tries to update the status of this port and both of them get semaphore "db-access" lock. [1]

The bug may be fixed by https://review.openstack.org/#/c/100934/8

http://logs.openstack.org/13/92013/3/check/check-tempest-dsvm-neutron-2/dc8b822/logs/screen-q-svc.txt.gz?#_2014-06-30_11_40_48_293

[Eugene Nikanorov (enikanorov)]

Not seeing in gate for quite a long time. Hopefully it was fixed by some other commit.
Setting as Incomplete.

Let's do nothing until it's expires.

[Joe Gordon (jogo)]

The expiration timer hasn't started for some reason.