yahoo-eng-team team mailing list archive

[Aaron Rosen <arosen@xxxxxxxxxx>]

Since you don't have to use mysql-server with quantum I guess we
shouldn't add this to that file.  Marking as invalid.

** Changed in: quantum
       Status: In Progress => Won't Fix

** Changed in: quantum
       Status: Won't Fix => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to quantum.
https://bugs.launchpad.net/bugs/1179756

Title:
  add mysql-python 1.2.4 to  pip-requires

Status in OpenStack Quantum (virtual network service):
  Invalid

Bug description:
  When trying to debug the following exception:

  2013-05-13 13:23:25    ERROR [quantum.openstack.common.rpc.amqp] Exception during message handling
  Traceback (most recent call last):
    File "/opt/stack/quantum/quantum/openstack/common/rpc/amqp.py", line 433, in _process_data
      **args)
    File "/opt/stack/quantum/quantum/common/rpc.py", line 44, in dispatch
      quantum_ctxt, version, method, namespace, **kwargs)
    File "/opt/stack/quantum/quantum/openstack/common/rpc/dispatcher.py", line 148, in dispatch
      return getattr(proxyobj, method)(ctxt, **kwargs)
    File "/opt/stack/quantum/quantum/db/dhcp_rpc_base.py", line 231, in create_dhcp_port
      return plugin.create_port(context, port)
    File "/opt/stack/quantum/quantum/plugins/nicira/QuantumPlugin.py", line 1156, in create_port
      quantum_db = super(NvpPluginV2, self).create_port(context, port)
    File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 1303, in create_port
      self._recycle_expired_ip_allocations(context, network_id)
    File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 337, in _recycle_expired_ip_allocations
      for expired in expired_qry:
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2341, in instances
      fetch = cursor.fetchall()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 3204, in fetchall
      l = self.process_rows(self._fetchall_impl())
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 3173, in _fetchall_impl
      self._non_result()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 3178, in _non_result
      "This result object does not return rows. "
  ResourceClosedError: This result object does not return rows. It has been closed automatically.


  I came accross this : http://sourceforge.net/p/mysql-python/bugs/324/

  
  After I installed mysql-python-1.2.4 from 1.2.3 I am no longer getting the error above. I'm now getting this error: 

  
  2013-05-13 19:00:08    ERROR [quantum.openstack.common.rpc.amqp] Exception during message handling
  Traceback (most recent call last):
    File "/opt/stack/quantum/quantum/openstack/common/rpc/amqp.py", line 433, in _process_data
      **args)
    File "/opt/stack/quantum/quantum/common/rpc.py", line 44, in dispatch
      quantum_ctxt, version, method, namespace, **kwargs)
    File "/opt/stack/quantum/quantum/openstack/common/rpc/dispatcher.py", line 148, in dispatch
      return getattr(proxyobj, method)(ctxt, **kwargs)
    File "/opt/stack/quantum/quantum/db/dhcp_rpc_base.py", line 155, in create_dhcp_port
      return plugin.create_port(context, port)
    File "/opt/stack/quantum/quantum/plugins/nicira/QuantumPlugin.py", line 1158, in create_port
      quantum_db = super(NvpPluginV2, self).create_port(context, port)
    File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 1303, in create_port
      self._recycle_expired_ip_allocations(context, network_id)
    File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 337, in _recycle_expired_ip_allocations
      for expired in expired_qry:
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
      return self._execute_and_instances(context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
      result = conn.execute(querycontext.statement, self._params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
      params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
      compiled_sql, distilled_params
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
      context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1850, in _handle_dbapi_exception
      None, sys.exc_info()[2]
  OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'SELECT ipallocations.port_id AS ipallocations_port_id, ipallocations.ip_address AS ipallocations_ip_address, ipallocations.subnet_id AS ipallocations_subnet_id, ipallocations.network_id AS ipallocations_network_id, ipallocations.expiration AS ipallocations_expiration \nFROM ipallocations \nWHERE ipallocations.network_id = %s AND ipallocations.port_id IS NULL AND ipallocations.expiration <= %s FOR UPDATE' ('7414a13b-aa3a-4811-9c5d-650b71616eae', datetime.datetime(2013, 5, 14, 1, 59, 17, 808608))
  2013-05-13 19:00:08    ERROR [quantum.openstack.common.rpc.common] Returning exception (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'SELECT ipallocations.port_id AS ipallocations_port_id, ipallocations.ip_address AS ipallocations_ip_address, ipallocations.subnet_id AS ipallocations_subnet_id, ipallocations.network_id AS ipallocations_network_id, ipallocations.expiration AS ipallocations_expiration \nFROM ipallocations \nWHERE ipallocations.network_id = %s AND ipallocations.port_id IS NULL AND ipallocations.expiration <= %s FOR UPDATE' ('7414a13b-aa3a-4811-9c5d-650b71616eae', datetime.datetime(2013, 5, 14, 1, 59, 17, 808608)) to caller


  But this error happens a lot less frequent at high loads so requireing
  python-mysql >= 1.2.4 is helpful.

To manage notifications about this bug go to:
https://bugs.launchpad.net/quantum/+bug/1179756/+subscriptions