Lock wait timeout on delete port for DVR
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
High
|
Kevin Benton | ||
Juno |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
We run a script to configure networks, VMs, Routers and assigin floatingIP to the VM.
After it is created, then we run a script to clean all ports, networks, routers and gateway and FIP.
The issue is seen when there is a back to back call to router-
There are three calls to router-
At this time there is a db lock obtained for port delete and when the other delete comes in, it timeout.
2014-10-03 09:28:39.587 DEBUG neutron.
2014-10-03 09:29:30.777 INFO neutron.wsgi [-] (25888) accepted ('192.168.15.144', 54899)
2014-10-03 09:29:30.778 INFO neutron.wsgi [-] (25888) accepted ('192.168.15.144', 54900)
2014-10-03 09:29:30.778 INFO neutron.wsgi [-] (25888) accepted ('192.168.15.144', 54901)
2014-10-03 09:29:30.778 INFO neutron.wsgi [-] (25888) accepted ('192.168.15.144', 54902)
2014-10-03 09:29:30.780 ERROR neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
2014-10-03 09:29:30.780 TRACE neutron.
summary: |
- OperationalError: Lock wait timeout exceeded seen occasionally when we - run a script to clean all networks, ports and routers. This is seen with - DVR + Lock wait timeout on delete port for DVR |
Changed in neutron: | |
assignee: | Carl Baldwin (carl-baldwin) → Swaminathan Vasudevan (swaminathan-vasudevan) |
status: | Confirmed → In Progress |
Changed in neutron: | |
milestone: | none → kilo-1 |
status: | Fix Committed → Fix Released |
Changed in neutron: | |
milestone: | kilo-1 → 2015.1.0 |
Carl has something:
https:/ /review. openstack. org/#/c/ 122880/
Can you verify that this might be related/fixes what you're seeing?