Lock wait timeout adding ipavailabilityranges

Bug #1330638 reported by Eugene Nikanorov
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
neutron
Expired
Medium
Unassigned
Revision history for this message
Salvatore Orlando (salvatore-orlando) wrote :

I unfortunately thought I filed a bug for this one bug I probably dreamt of that.

Changed in neutron:
status: New → Confirmed
tags: added: gate-failure
Revision history for this message
Angus Lees (gus) wrote :

So what's the plan with these "lock wait timeout" bugs?

Is the plan to A) squash each one separately, or B) squash the single underlying issue?

If A) it will mean preventing all eventlet-yielding calls while a transaction is open. I _think_ I can write a pylint check to find those cases for us.

If B) then I'd like to close all of these as duplicates of bug 1350149 - or some other central description of the problem.

I feel rather strongly that (B) is the right answer here, but the fact that multiple bugs were opened without linking to a single cause - and the general resistance I've been getting trying to abandon mysqldb(*) - makes me thing we (plural) want to go with (A) instead.

Thoughts?

(*) See for example Eugene's comment on bug 1350149. Not trying to highlight any particular incident, but I encountered such a total lack of enthusiasm from all directions for (B) that I went and worked on something else instead.

Revision history for this message
Eugene Nikanorov (enikanorov) wrote :

Writing such script might help.

There are known places where such yielding calls (usually, rpc calls) are made, but most of them are not the cause of those issues.

So each case requires it's own analysis.

The best solution is to move to non-blocking python client for mysql.

Revision history for this message
Cedric Brandily (cbrandily) wrote :

This bug is > 365 days without activity. We are unsetting assignee and milestone and setting status to Incomplete in order to allow its expiry in 60 days.

If the bug is still valid, then update the bug status.

Changed in neutron:
status: Confirmed → Incomplete
Revision history for this message
Ihar Hrachyshka (ihar-hrachyshka) wrote :

We moved to pymysql since L.

Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for neutron because there has been no activity for 60 days.]

Changed in neutron:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers