Public bug reported: after Use network segment ranges for segment allocation https://github.com/openstack/neutron/commit/a01b7125cd965625316d9aec3a7408612b94fc08 #diff-441e123742581c5d1da67bf722508f1bR121 merged in neutron
many network unitest could not passed in tricirlce the detail info as follows: stack@trio-top:~/tricircle$ sudo stestr run tricircle.tests.unit.network.test_segment_plugin.PluginTest.test_create_segment Could not load 'NetworkSegmentRange': 'module' object has no attribute 'NetworkSegmentRange' Could not load 'NetworkSegmentRange': 'module' object has no attribute 'NetworkSegmentRange' Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. {0} tricircle.tests.unit.network.test_segment_plugin.PluginTest.test_create_segment [0.399660s] ... FAILED Captured traceback: ~~~~~~~~~~~~~~~~~~~ Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/mock/mock.py", line 1305, in patched return func(*args, **keywargs) File "tricircle/tests/unit/network/test_segment_plugin.py", line 228, in test_create_segment fake_plugin.central_plugin.create_network(neutron_context, network) File "tricircle/tests/unit/network/test_central_plugin.py", line 825, in create_network net = super(FakePlugin, self).create_network(context, network) File "tricircle/network/central_plugin.py", line 322, in create_network tenant_id) File "tricircle/network/managers.py", line 65, in create_network_segments segments = self._process_provider_create(network) File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 116, in _process_provider_create return [self._process_provider_segment(segment)] File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 102, in _process_provider_segment self.validate_provider_segment(segment) File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 258, in validate_provider_segment driver.obj.validate_provider_segment(segment) File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 238, in validate_provider_segment ranges = self.get_network_segment_ranges() File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 228, in get_network_segment_ranges ranges = self._get_network_segment_ranges_from_db() File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 139, in wrapped setattr(e, '_RETRY_EXCEEDED', True) File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 135, in wrapped return f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 183, in wrapped LOG.debug("Retry wrapper got retriable exception: %s", e) File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 179, in wrapped return f(*dup_args, **dup_kwargs) File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 182, in _get_network_segment_ranges_from_db ctx, network_type=self.get_type())) File "/opt/stack/neutron/neutron/objects/base.py", line 640, in get_objects cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs)) File "/opt/stack/neutron/neutron/objects/db/api.py", line 52, in get_objects **(_pager.to_kwargs(context, obj_cls) if _pager else {})) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/model_query.py", line 308, in get_collection for c in query File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3081, in __iter__ return self._execute_and_instances(context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 980, in execute return meth(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement distilled_params, File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception util.raise_from_cause(newraise, exc_info) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute cursor.execute(statement, parameters) oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: network_segment_ranges [SQL: u'SELECT network_segment_ranges.id AS network_segment_ranges_id, network_segment_ranges.name AS network_segment_ranges_name, network_segment_ranges."default" AS network_segment_ranges_default, network_segment_ranges.shared AS network_segment_ranges_shared, network_segment_ranges.project_id AS network_segment_ranges_project_id, network_segment_ranges.network_type AS network_segment_ranges_network_type, network_segment_ranges.physical_network AS network_segment_ranges_physical_network, network_segment_ranges.minimum AS network_segment_ranges_minimum, network_segment_ranges.maximum AS network_segment_ranges_maximum, network_segment_ranges.standard_attr_id AS network_segment_ranges_standard_attr_id, standardattributes_1.id AS standardattributes_1_id, standardattributes_1.resource_type AS standardattributes_1_resource_type, standardattributes_1.description AS standardattributes_1_description, standardattributes_1.revision_number AS standardattributes_1_revision_number, standardattributes_1.created_at AS standardattributes_1_created_at, standardattributes_1.updated_at AS standardattributes_1_updated_at \nFROM network_segment_ranges LEFT OUTER JOIN standardattributes AS standardattributes_1 ON standardattributes_1.id = network_segment_ranges.standard_attr_id \nWHERE network_segment_ranges.network_type IN (?)'] [parameters: ('vlan',)] (Background on this error at: http://sqlalche.me/e/e3q8) ** Affects: neutron Importance: Undecided Status: New ** Affects: tricircle Importance: Undecided Status: New ** Tags: neutron ** Also affects: neutron Importance: Undecided Status: New -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1821567 Title: network_segment_ranges could not load in tricirlce test Status in neutron: New Status in Tricircle: New Bug description: after Use network segment ranges for segment allocation https://github.com/openstack/neutron/commit/a01b7125cd965625316d9aec3a7408612b94fc08 #diff-441e123742581c5d1da67bf722508f1bR121 merged in neutron many network unitest could not passed in tricirlce the detail info as follows: stack@trio-top:~/tricircle$ sudo stestr run tricircle.tests.unit.network.test_segment_plugin.PluginTest.test_create_segment Could not load 'NetworkSegmentRange': 'module' object has no attribute 'NetworkSegmentRange' Could not load 'NetworkSegmentRange': 'module' object has no attribute 'NetworkSegmentRange' Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. Using RPC transport for notifications. Please use get_notification_transport to obtain a notification transport instance. {0} tricircle.tests.unit.network.test_segment_plugin.PluginTest.test_create_segment [0.399660s] ... FAILED Captured traceback: ~~~~~~~~~~~~~~~~~~~ Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/mock/mock.py", line 1305, in patched return func(*args, **keywargs) File "tricircle/tests/unit/network/test_segment_plugin.py", line 228, in test_create_segment fake_plugin.central_plugin.create_network(neutron_context, network) File "tricircle/tests/unit/network/test_central_plugin.py", line 825, in create_network net = super(FakePlugin, self).create_network(context, network) File "tricircle/network/central_plugin.py", line 322, in create_network tenant_id) File "tricircle/network/managers.py", line 65, in create_network_segments segments = self._process_provider_create(network) File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 116, in _process_provider_create return [self._process_provider_segment(segment)] File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 102, in _process_provider_segment self.validate_provider_segment(segment) File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 258, in validate_provider_segment driver.obj.validate_provider_segment(segment) File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 238, in validate_provider_segment ranges = self.get_network_segment_ranges() File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 228, in get_network_segment_ranges ranges = self._get_network_segment_ranges_from_db() File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 139, in wrapped setattr(e, '_RETRY_EXCEEDED', True) File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 135, in wrapped return f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 154, in wrapper ectxt.value = e.inner_exc File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 142, in wrapper return f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 183, in wrapped LOG.debug("Retry wrapper got retriable exception: %s", e) File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ self.force_reraise() File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise six.reraise(self.type_, self.value, self.tb) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/api.py", line 179, in wrapped return f(*dup_args, **dup_kwargs) File "/opt/stack/neutron/neutron/plugins/ml2/drivers/type_vlan.py", line 182, in _get_network_segment_ranges_from_db ctx, network_type=self.get_type())) File "/opt/stack/neutron/neutron/objects/base.py", line 640, in get_objects cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs)) File "/opt/stack/neutron/neutron/objects/db/api.py", line 52, in get_objects **(_pager.to_kwargs(context, obj_cls) if _pager else {})) File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/model_query.py", line 308, in get_collection for c in query File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3081, in __iter__ return self._execute_and_instances(context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 980, in execute return meth(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement distilled_params, File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context e, statement, parameters, cursor, context File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception util.raise_from_cause(newraise, exc_info) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context cursor, statement, parameters, context File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute cursor.execute(statement, parameters) oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: network_segment_ranges [SQL: u'SELECT network_segment_ranges.id AS network_segment_ranges_id, network_segment_ranges.name AS network_segment_ranges_name, network_segment_ranges."default" AS network_segment_ranges_default, network_segment_ranges.shared AS network_segment_ranges_shared, network_segment_ranges.project_id AS network_segment_ranges_project_id, network_segment_ranges.network_type AS network_segment_ranges_network_type, network_segment_ranges.physical_network AS network_segment_ranges_physical_network, network_segment_ranges.minimum AS network_segment_ranges_minimum, network_segment_ranges.maximum AS network_segment_ranges_maximum, network_segment_ranges.standard_attr_id AS network_segment_ranges_standard_attr_id, standardattributes_1.id AS standardattributes_1_id, standardattributes_1.resource_type AS standardattributes_1_resource_type, standardattributes_1.description AS standardattributes_1_description, standardattributes_1.revision_number AS standardattributes_1_revision_number, standardattributes_1.created_at AS standardattributes_1_created_at, standardattributes_1.updated_at AS standardattributes_1_updated_at \nFROM network_segment_ranges LEFT OUTER JOIN standardattributes AS standardattributes_1 ON standardattributes_1.id = network_segment_ranges.standard_attr_id \nWHERE network_segment_ranges.network_type IN (?)'] [parameters: ('vlan',)] (Background on this error at: http://sqlalche.me/e/e3q8) To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1821567/+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