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 -- 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