Public bug reported: The failure was found from Heat gate:
http://logs.openstack.org/03/559803/2/gate/heat-functional-convg- mysql-lbaasv2/825236e/logs/screen-q-svc.txt.gz#_Apr_23_10_02_01_252456 The error message and traceback is as following: Apr 23 10:02:01.252456 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service [None req-494752bd-c98f-45d2-9a16-8e6c9dd02b8e None None] Unrecoverable error: please check log for details.: NoForeignKeysError: Could not determine join condition between parent/child tables on relationship ProviderResourceAssociation._provider_backref - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression. Apr 23 10:02:01.253089 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service Traceback (most recent call last): Apr 23 10:02:01.253204 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 86, in serve_wsgi Apr 23 10:02:01.253315 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service service.start() Apr 23 10:02:01.253425 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 62, in start Apr 23 10:02:01.253541 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.wsgi_app = _run_wsgi(self.app_name) Apr 23 10:02:01.253661 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 290, in _run_wsgi Apr 23 10:02:01.253787 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = config.load_paste_app(app_name) Apr 23 10:02:01.253918 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/common/config.py", line 122, in load_paste_app Apr 23 10:02:01.254024 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.load_app(app_name) Apr 23 10:02:01.254128 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/oslo_service/wsgi.py", line 353, in load_app Apr 23 10:02:01.254231 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return deploy.loadapp("config:%s" % self.config_path, name=name) Apr 23 10:02:01.254351 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp Apr 23 10:02:01.254456 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return loadobj(APP, uri, name=name, **kw) Apr 23 10:02:01.254573 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj Apr 23 10:02:01.254700 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return context.create() Apr 23 10:02:01.254831 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.254954 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.255108 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke Apr 23 10:02:01.255392 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **context.local_conf) Apr 23 10:02:01.255616 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.255851 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.256092 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/urlmap.py", line 31, in urlmap_factory Apr 23 10:02:01.256312 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.get_app(app_name, global_conf=global_conf) Apr 23 10:02:01.256582 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app Apr 23 10:02:01.256821 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service name=name, global_conf=global_conf).create() Apr 23 10:02:01.257047 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.257267 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.257489 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke Apr 23 10:02:01.257753 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **context.local_conf) Apr 23 10:02:01.257976 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.258194 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.258411 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/auth.py", line 47, in pipeline_factory Apr 23 10:02:01.258693 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.get_app(pipeline[-1]) Apr 23 10:02:01.258925 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app Apr 23 10:02:01.259187 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service name=name, global_conf=global_conf).create() Apr 23 10:02:01.259431 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.259659 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.259989 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke Apr 23 10:02:01.260102 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return fix_call(context.object, context.global_conf, **context.local_conf) Apr 23 10:02:01.260209 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.260336 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.260453 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/api/v2/router.py", line 25, in _factory Apr 23 10:02:01.260588 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return pecan_app.v2_factory(global_config, **local_config) Apr 23 10:02:01.260696 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/pecan_wsgi/app.py", line 47, in v2_factory Apr 23 10:02:01.260886 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service startup.initialize_all() Apr 23 10:02:01.261074 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/pecan_wsgi/startup.py", line 39, in initialize_all Apr 23 10:02:01.261262 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service manager.init() Apr 23 10:02:01.261389 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 296, in init Apr 23 10:02:01.261498 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service NeutronManager.get_instance() Apr 23 10:02:01.261638 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 247, in get_instance Apr 23 10:02:01.261747 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service cls._create_instance() Apr 23 10:02:01.261934 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py", line 274, in inner Apr 23 10:02:01.262212 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return f(*args, **kwargs) Apr 23 10:02:01.262328 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 233, in _create_instance Apr 23 10:02:01.262437 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service cls._instance = cls() Apr 23 10:02:01.262536 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 141, in __init__ Apr 23 10:02:01.262692 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._load_service_plugins() Apr 23 10:02:01.262857 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 203, in _load_service_plugins Apr 23 10:02:01.262969 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service provider) Apr 23 10:02:01.263140 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 166, in _get_plugin_instance Apr 23 10:02:01.263253 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return plugin_class() Apr 23 10:02:01.263351 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 90, in __init__ Apr 23 10:02:01.263465 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._load_drivers() Apr 23 10:02:01.263574 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 118, in _load_drivers Apr 23 10:02:01.263729 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._check_orphan_loadbalancer_associations(ctx, self.drivers.keys()) Apr 23 10:02:01.263870 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 127, in _check_orphan_loadbalancer_associations Apr 23 10:02:01.264053 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service loadbalancers = self.db.get_loadbalancers(context) Apr 23 10:02:01.264206 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/db/loadbalancer/loadbalancer_dbv2.py", line 396, in get_loadbalancers Apr 23 10:02:01.264401 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service filters=filters) Apr 23 10:02:01.264582 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/db/loadbalancer/loadbalancer_dbv2.py", line 98, in _get_resources Apr 23 10:02:01.264809 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service filters=filters) Apr 23 10:02:01.264967 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/common_db_mixin.py", line 82, in _get_collection_query Apr 23 10:02:01.265143 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service page_reverse) Apr 23 10:02:01.265302 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/_model_query.py", line 256, in get_collection_query Apr 23 10:02:01.265470 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service collection = query_with_hooks(context, model) Apr 23 10:02:01.265630 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/_model_query.py", line 137, in query_with_hooks Apr 23 10:02:01.265797 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service query = context.session.query(model) Apr 23 10:02:01.265909 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1399, in query Apr 23 10:02:01.266021 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self._query_cls(entities, self, **kwargs) Apr 23 10:02:01.266157 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 141, in __init__ Apr 23 10:02:01.266295 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._set_entities(entities) Apr 23 10:02:01.266423 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 152, in _set_entities Apr 23 10:02:01.266553 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._set_entity_selectables(self._entities) Apr 23 10:02:01.266663 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 182, in _set_entity_selectables Apr 23 10:02:01.266910 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service ent.setup_entity(*d[entity]) Apr 23 10:02:01.267097 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3630, in setup_entity Apr 23 10:02:01.267231 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._with_polymorphic = ext_info.with_polymorphic_mappers Apr 23 10:02:01.267363 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 767, in __get__ Apr 23 10:02:01.267535 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service obj.__dict__[self.__name__] = result = self.fget(obj) Apr 23 10:02:01.267719 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2011, in _with_polymorphic_mappers Apr 23 10:02:01.267896 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service configure_mappers() Apr 23 10:02:01.268010 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 3029, in configure_mappers Apr 23 10:02:01.268113 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service mapper._post_configure_properties() Apr 23 10:02:01.268225 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1831, in _post_configure_properties Apr 23 10:02:01.268334 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service prop.post_instrument_class(self) Apr 23 10:02:01.268437 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/interfaces.py", line 544, in post_instrument_class Apr 23 10:02:01.268557 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.strategy.init_class_attribute(mapper) Apr 23 10:02:01.268670 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 507, in init_class_attribute Apr 23 10:02:01.268782 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service active_history=active_history Apr 23 10:02:01.268903 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 106, in _register_attribute Apr 23 10:02:01.269005 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **kw Apr 23 10:02:01.269124 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 1524, in register_attribute_impl Apr 23 10:02:01.269241 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service manager.post_configure_attribute(key) Apr 23 10:02:01.269354 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/instrumentation.py", line 278, in post_configure_attribute Apr 23 10:02:01.269448 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service attribute_instrument(self.class_, key, self[key]) Apr 23 10:02:01.269540 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/event/attr.py", line 284, in __call__ Apr 23 10:02:01.269653 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service fn(*args, **kw) Apr 23 10:02:01.269765 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/events.py", line 71, in listen Apr 23 10:02:01.269872 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return fn(target_cls, *arg) Apr 23 10:02:01.269978 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/api.py", line 403, in _listen_for_changes Apr 23 10:02:01.270085 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service remote_mapper.add_property(name, backref_prop) Apr 23 10:02:01.270217 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1854, in add_property Apr 23 10:02:01.270321 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._configure_property(key, prop, init=self.configured) Apr 23 10:02:01.270425 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1731, in _configure_property Apr 23 10:02:01.270528 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service prop.init() Apr 23 10:02:01.270648 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/interfaces.py", line 184, in init Apr 23 10:02:01.270788 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.do_init() Apr 23 10:02:01.270897 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1656, in do_init Apr 23 10:02:01.271003 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._setup_join_conditions() Apr 23 10:02:01.271168 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1731, in _setup_join_conditions Apr 23 10:02:01.271292 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service can_be_synced_fn=self._columns_are_mapped Apr 23 10:02:01.271396 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1998, in __init__ Apr 23 10:02:01.271510 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._determine_joins() Apr 23 10:02:01.271630 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 2103, in _determine_joins Apr 23 10:02:01.271736 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service "specify a 'primaryjoin' expression." % self.prop) Apr 23 10:02:01.271853 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service NoForeignKeysError: Could not determine join condition between parent/child tables on relationship ProviderResourceAssociation._provider_backref - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression. ** Affects: neutron Importance: Undecided Assignee: Hongbin Lu (hongbin.lu) Status: In Progress -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1766267 Title: neutron server failed with 'NoForeignKeysError' Status in neutron: In Progress Bug description: The failure was found from Heat gate: http://logs.openstack.org/03/559803/2/gate/heat-functional-convg- mysql-lbaasv2/825236e/logs/screen-q-svc.txt.gz#_Apr_23_10_02_01_252456 The error message and traceback is as following: Apr 23 10:02:01.252456 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service [None req-494752bd-c98f-45d2-9a16-8e6c9dd02b8e None None] Unrecoverable error: please check log for details.: NoForeignKeysError: Could not determine join condition between parent/child tables on relationship ProviderResourceAssociation._provider_backref - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression. Apr 23 10:02:01.253089 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service Traceback (most recent call last): Apr 23 10:02:01.253204 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 86, in serve_wsgi Apr 23 10:02:01.253315 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service service.start() Apr 23 10:02:01.253425 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 62, in start Apr 23 10:02:01.253541 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.wsgi_app = _run_wsgi(self.app_name) Apr 23 10:02:01.253661 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/service.py", line 290, in _run_wsgi Apr 23 10:02:01.253787 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = config.load_paste_app(app_name) Apr 23 10:02:01.253918 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/common/config.py", line 122, in load_paste_app Apr 23 10:02:01.254024 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.load_app(app_name) Apr 23 10:02:01.254128 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/oslo_service/wsgi.py", line 353, in load_app Apr 23 10:02:01.254231 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return deploy.loadapp("config:%s" % self.config_path, name=name) Apr 23 10:02:01.254351 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp Apr 23 10:02:01.254456 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return loadobj(APP, uri, name=name, **kw) Apr 23 10:02:01.254573 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj Apr 23 10:02:01.254700 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return context.create() Apr 23 10:02:01.254831 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.254954 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.255108 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke Apr 23 10:02:01.255392 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **context.local_conf) Apr 23 10:02:01.255616 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.255851 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.256092 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/urlmap.py", line 31, in urlmap_factory Apr 23 10:02:01.256312 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.get_app(app_name, global_conf=global_conf) Apr 23 10:02:01.256582 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app Apr 23 10:02:01.256821 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service name=name, global_conf=global_conf).create() Apr 23 10:02:01.257047 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.257267 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.257489 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke Apr 23 10:02:01.257753 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **context.local_conf) Apr 23 10:02:01.257976 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.258194 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.258411 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/auth.py", line 47, in pipeline_factory Apr 23 10:02:01.258693 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service app = loader.get_app(pipeline[-1]) Apr 23 10:02:01.258925 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app Apr 23 10:02:01.259187 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service name=name, global_conf=global_conf).create() Apr 23 10:02:01.259431 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create Apr 23 10:02:01.259659 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self.object_type.invoke(self) Apr 23 10:02:01.259989 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke Apr 23 10:02:01.260102 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return fix_call(context.object, context.global_conf, **context.local_conf) Apr 23 10:02:01.260209 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call Apr 23 10:02:01.260336 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service val = callable(*args, **kw) Apr 23 10:02:01.260453 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/api/v2/router.py", line 25, in _factory Apr 23 10:02:01.260588 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return pecan_app.v2_factory(global_config, **local_config) Apr 23 10:02:01.260696 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/pecan_wsgi/app.py", line 47, in v2_factory Apr 23 10:02:01.260886 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service startup.initialize_all() Apr 23 10:02:01.261074 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/pecan_wsgi/startup.py", line 39, in initialize_all Apr 23 10:02:01.261262 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service manager.init() Apr 23 10:02:01.261389 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 296, in init Apr 23 10:02:01.261498 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service NeutronManager.get_instance() Apr 23 10:02:01.261638 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 247, in get_instance Apr 23 10:02:01.261747 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service cls._create_instance() Apr 23 10:02:01.261934 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py", line 274, in inner Apr 23 10:02:01.262212 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return f(*args, **kwargs) Apr 23 10:02:01.262328 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 233, in _create_instance Apr 23 10:02:01.262437 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service cls._instance = cls() Apr 23 10:02:01.262536 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 141, in __init__ Apr 23 10:02:01.262692 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._load_service_plugins() Apr 23 10:02:01.262857 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 203, in _load_service_plugins Apr 23 10:02:01.262969 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service provider) Apr 23 10:02:01.263140 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/manager.py", line 166, in _get_plugin_instance Apr 23 10:02:01.263253 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return plugin_class() Apr 23 10:02:01.263351 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 90, in __init__ Apr 23 10:02:01.263465 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._load_drivers() Apr 23 10:02:01.263574 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 118, in _load_drivers Apr 23 10:02:01.263729 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._check_orphan_loadbalancer_associations(ctx, self.drivers.keys()) Apr 23 10:02:01.263870 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/services/loadbalancer/plugin.py", line 127, in _check_orphan_loadbalancer_associations Apr 23 10:02:01.264053 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service loadbalancers = self.db.get_loadbalancers(context) Apr 23 10:02:01.264206 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/db/loadbalancer/loadbalancer_dbv2.py", line 396, in get_loadbalancers Apr 23 10:02:01.264401 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service filters=filters) Apr 23 10:02:01.264582 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron-lbaas/neutron_lbaas/db/loadbalancer/loadbalancer_dbv2.py", line 98, in _get_resources Apr 23 10:02:01.264809 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service filters=filters) Apr 23 10:02:01.264967 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/common_db_mixin.py", line 82, in _get_collection_query Apr 23 10:02:01.265143 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service page_reverse) Apr 23 10:02:01.265302 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/_model_query.py", line 256, in get_collection_query Apr 23 10:02:01.265470 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service collection = query_with_hooks(context, model) Apr 23 10:02:01.265630 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/_model_query.py", line 137, in query_with_hooks Apr 23 10:02:01.265797 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service query = context.session.query(model) Apr 23 10:02:01.265909 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1399, in query Apr 23 10:02:01.266021 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return self._query_cls(entities, self, **kwargs) Apr 23 10:02:01.266157 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 141, in __init__ Apr 23 10:02:01.266295 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._set_entities(entities) Apr 23 10:02:01.266423 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 152, in _set_entities Apr 23 10:02:01.266553 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._set_entity_selectables(self._entities) Apr 23 10:02:01.266663 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 182, in _set_entity_selectables Apr 23 10:02:01.266910 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service ent.setup_entity(*d[entity]) Apr 23 10:02:01.267097 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3630, in setup_entity Apr 23 10:02:01.267231 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._with_polymorphic = ext_info.with_polymorphic_mappers Apr 23 10:02:01.267363 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 767, in __get__ Apr 23 10:02:01.267535 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service obj.__dict__[self.__name__] = result = self.fget(obj) Apr 23 10:02:01.267719 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2011, in _with_polymorphic_mappers Apr 23 10:02:01.267896 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service configure_mappers() Apr 23 10:02:01.268010 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 3029, in configure_mappers Apr 23 10:02:01.268113 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service mapper._post_configure_properties() Apr 23 10:02:01.268225 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1831, in _post_configure_properties Apr 23 10:02:01.268334 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service prop.post_instrument_class(self) Apr 23 10:02:01.268437 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/interfaces.py", line 544, in post_instrument_class Apr 23 10:02:01.268557 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.strategy.init_class_attribute(mapper) Apr 23 10:02:01.268670 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 507, in init_class_attribute Apr 23 10:02:01.268782 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service active_history=active_history Apr 23 10:02:01.268903 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 106, in _register_attribute Apr 23 10:02:01.269005 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service **kw Apr 23 10:02:01.269124 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 1524, in register_attribute_impl Apr 23 10:02:01.269241 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service manager.post_configure_attribute(key) Apr 23 10:02:01.269354 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/instrumentation.py", line 278, in post_configure_attribute Apr 23 10:02:01.269448 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service attribute_instrument(self.class_, key, self[key]) Apr 23 10:02:01.269540 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/event/attr.py", line 284, in __call__ Apr 23 10:02:01.269653 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service fn(*args, **kw) Apr 23 10:02:01.269765 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/events.py", line 71, in listen Apr 23 10:02:01.269872 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service return fn(target_cls, *arg) Apr 23 10:02:01.269978 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/opt/stack/new/neutron/neutron/db/api.py", line 403, in _listen_for_changes Apr 23 10:02:01.270085 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service remote_mapper.add_property(name, backref_prop) Apr 23 10:02:01.270217 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1854, in add_property Apr 23 10:02:01.270321 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._configure_property(key, prop, init=self.configured) Apr 23 10:02:01.270425 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 1731, in _configure_property Apr 23 10:02:01.270528 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service prop.init() Apr 23 10:02:01.270648 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/interfaces.py", line 184, in init Apr 23 10:02:01.270788 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self.do_init() Apr 23 10:02:01.270897 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1656, in do_init Apr 23 10:02:01.271003 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._setup_join_conditions() Apr 23 10:02:01.271168 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1731, in _setup_join_conditions Apr 23 10:02:01.271292 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service can_be_synced_fn=self._columns_are_mapped Apr 23 10:02:01.271396 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 1998, in __init__ Apr 23 10:02:01.271510 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service self._determine_joins() Apr 23 10:02:01.271630 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/relationships.py", line 2103, in _determine_joins Apr 23 10:02:01.271736 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service "specify a 'primaryjoin' expression." % self.prop) Apr 23 10:02:01.271853 ubuntu-xenial-ovh-gra1-0003676293 neutron-server[10199]: ERROR neutron.service NoForeignKeysError: Could not determine join condition between parent/child tables on relationship ProviderResourceAssociation._provider_backref - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1766267/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
