Added neutron because this exception was observed in the gate:
http://logs.openstack.org/43/298443/4/check/gate-grenade-dsvm-neutron-
dvr-
multinode/56112e8/logs/old/screen-q-svc.txt.gz?level=TRACE#_2016-07-31_00_21_14_938
** Also affects: neutron
Importance: Undecided
Status: New
** Changed in: neutron
Assignee: (unassigned) => Kevin Benton (kevinbenton)
** Changed in: neutron
Importance: Undecided => High
** Changed in: neutron
Status: New => Confirmed
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1608691
Title:
exception translation for pymysql "Lock wait timeout exceeded" broken
Status in neutron:
Confirmed
Status in oslo.db:
New
Bug description:
It looks like the classifier for "lock wait timeout exceeded" as a
DBDeadlock is not correct for pymysql. Snippet of traceback showing it
as the generic DBError:
2016-07-31 00:21:14.938 4145 ERROR neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in
raise_mysql_exception
2016-07-31 00:21:14.938 4145 ERROR neutron.api.v2.resource
_check_mysql_exception(errinfo)
2016-07-31 00:21:14.938 4145 ERROR neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 115, in
_check_mysql_exception
2016-07-31 00:21:14.938 4145 ERROR neutron.api.v2.resource raise
InternalError(errno, errorvalue)
2016-07-31 00:21:14.938 4145 ERROR neutron.api.v2.resource DBError:
(pymysql.err.InternalError) (1205, u'Lock wait timeout exceeded; try restarting
transaction') [SQL: u'SELECT ipavailabilityranges.allocation_pool_id AS
ipavailabilityranges_allocation_pool_id, ipavailabilityranges.first_ip AS
ipavailabilityranges_first_ip, ipavailabilityranges.last_ip AS
ipavailabilityranges_last_ip \nFROM ipavailabilityranges INNER JOIN
ipallocationpools ON ipallocationpools.id =
ipavailabilityranges.allocation_pool_id \nWHERE ipallocationpools.subnet_id =
%(subnet_id_1)s \n LIMIT %(param_1)s FOR UPDATE'] [parameters: {u'param_1': 1,
u'subnet_id_1': u'344485c9-e600-40c0-8acf-d9ba98dacf99'}]
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1608691/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
