DB error in Cisco plugin

Bug #1052295 reported by Sumit Naiksatam
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Critical
Sumit Naiksatam

Bug Description

When the Cisco plugin is configured to support L3 extension, the get_network is failing with the following error:
2012-09-17 19:52:22 DEBUG [quantum.db.dhcp_rpc_base] Network list requested from vmwc
2012-09-17 19:52:22 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 275, in _process_data
    rval = self.proxy.dispatch(ctxt, version, method, **args)
  File "/opt/stack/quantum/quantum/openstack/common/rpc/dispatcher.py", line 145, in dispatch
    return getattr(proxyobj, method)(ctxt, **kwargs)
  File "/opt/stack/quantum/quantum/db/dhcp_rpc_base.py", line 47, in get_active_networks
    plugin.get_networks(context, filters=filters)]
  File "/opt/stack/quantum/quantum/plugins/openvswitch/ovs_quantum_plugin.py", line 471, in get_networks
    None)
  File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 922, in get_networks
    filters=filters, fields=fields)
  File "/opt/stack/quantum/quantum/db/db_base_plugin_v2.py", line 211, in _get_collection
    return [dict_func(c, fields) for c in collection.all()]
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
    return list(self)
  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 1691, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue

The likely reason is that the l3 db is not getting initialized correctly.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to quantum (master)

Fix proposed to branch: master
Review: https://review.openstack.org/13183

Changed in quantum:
status: New → In Progress
tags: added: folsom-rc-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote :

Fix proposed to branch: master
Review: https://review.openstack.org/13186

tags: removed: folsom-rc-potential
Changed in quantum:
milestone: none → folsom-rc2
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to quantum (master)

Reviewed: https://review.openstack.org/13186
Committed: http://github.com/openstack/quantum/commit/643afefa0f3b2b5c5f1f7af2e0cb7f5e04daf790
Submitter: Jenkins
Branch: master

commit 643afefa0f3b2b5c5f1f7af2e0cb7f5e04daf790
Author: Sumit Naiksatam <email address hidden>
Date: Mon Sep 17 23:16:15 2012 -0700

    Fix for DB error in the Cisco plugin

    Bug #1052295

    When the Cisco plugin is configured to support the L3 extension, the L3
    DB model is not getting loaded correctly. Adding this import fixes that
    issue.

    Change-Id: I736bd2e767595088de8ebee929258a88f5cbd238

Changed in quantum:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to quantum (milestone-proposed)

Fix proposed to branch: milestone-proposed
Review: https://review.openstack.org/13261

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to quantum (milestone-proposed)

Reviewed: https://review.openstack.org/13261
Committed: http://github.com/openstack/quantum/commit/03694682b7437f1f71ba0769e1c0962aacbb22e6
Submitter: Jenkins
Branch: milestone-proposed

commit 03694682b7437f1f71ba0769e1c0962aacbb22e6
Author: Sumit Naiksatam <email address hidden>
Date: Mon Sep 17 23:16:15 2012 -0700

    Fix for DB error in the Cisco plugin

    Bug #1052295

    When the Cisco plugin is configured to support the L3 extension, the L3
    DB model is not getting loaded correctly. Adding this import fixes that
    issue.

    Change-Id: I736bd2e767595088de8ebee929258a88f5cbd238

Changed in quantum:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in quantum:
milestone: folsom-rc2 → 2012.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.