yahoo-eng-team team mailing list archive

[Kevin Benton <1608691@xxxxxxxxxxxxxxxxxx>]

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