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
