yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1209172] Re: db migraion script (ryu) create tunnelkey table with a wrong column name

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Thu, 05 Sep 2013 15:45:14 -0000
Reply-to: Bug 1209172 <1209172@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: neutron
       Status: Fix Committed => Fix Released

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

Title:
  db migraion script (ryu) create tunnelkey table with a wrong column
  name

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  last_key is wrong. It should be tunnel_key.

  2013-08-07 10:40:53.075 22287 TRACE neutron.service Traceback (most recent call last):
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/service.py", line 96, in serve_wsgi
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     service.start()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/service.py", line 65, in start
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     self.wsgi_app = _run_wsgi(self.app_name)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/service.py", line 109, in _run_wsgi
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     app = config.load_paste_app(app_name)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/common/config.py", line 144, in load_paste_app
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     app = deploy.loadapp("config:%s" % config_path, name=app_name)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return loadobj(APP, uri, name=name, **kw)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return context.create()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return self.object_type.invoke(self)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     **context.local_conf)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 56, in fix_call
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     val = callable(*args, **kw)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 25, in urlmap_factory
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     app = loader.get_app(app_name, global_conf=global_conf)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     name=name, global_conf=global_conf).create()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return self.object_type.invoke(self)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     **context.local_conf)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 56, in fix_call
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     val = callable(*args, **kw)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/auth.py", line 59, in pipeline_factory
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     app = loader.get_app(pipeline[-1])
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     name=name, global_conf=global_conf).create()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return self.object_type.invoke(self)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return fix_call(context.object, context.global_conf, **context.local_conf)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 56, in fix_call
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     val = callable(*args, **kw)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/api/v2/router.py", line 72, in factory
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return cls(**local_config)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/api/v2/router.py", line 76, in __init__
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     plugin = manager.NeutronManager.get_plugin()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/manager.py", line 206, in get_plugin
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return cls.get_instance().plugin
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/manager.py", line 201, in get_instance
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     cls._create_instance()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/openstack/common/lockutils.py", line 247, in inner
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     retval = f(*args, **kwargs)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/manager.py", line 195, in _create_instance
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     cls._instance = cls()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/manager.py", line 120, in __init__
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     self.plugin = plugin_klass()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/plugins/ryu/ryu_neutron_plugin.py", line 121, in __init__
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     self._create_all_tenant_network()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/plugins/ryu/ryu_neutron_plugin.py", line 134, in _create_all_tenant_network
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     for tun in self.tunnel_key.all_list():
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/opt/stack/neutron/neutron/plugins/ryu/db/api_v2.py", line 205, in all_list
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return session.query(ryu_models_v2.TunnelKey).all()
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return list(self)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     return self._execute_and_instances(context)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     result = conn.execute(querycontext.statement, self._params)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     params)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     compiled_sql, distilled_params
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     context)
  2013-08-07 10:40:53.075 22287 TRACE neutron.service   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1850, in _handle_dbapi_exception
  2013-08-07 10:40:53.075 22287 TRACE neutron.service     None, sys.exc_info()[2]
  2013-08-07 10:40:53.075 22287 TRACE neutron.service OperationalError: (OperationalError) (1054, "Unknown column 'tunnelkeys.tunnel_key' in 'field list'") 'SELECT tunnelkeys.network_id AS tunnelkeys_network_id, tunnelkeys.tunnel_key AS tunnelkeys_tunnel_key \nFROM tunnelkeys' ()

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