We can't bump the oslo.db version in Mitaka. As for Newton, it's already >=4.10.0. I guess we can close the bug.
** Changed in: neutron Status: In Progress => Won't Fix ** Tags removed: mitaka-backport-potential -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1599086 Title: Security groups: exception under load Status in neutron: Won't Fix Status in oslo.db: Fix Committed Bug description: For one of the iteration, adding router interface failed showing the below DB error. 2016-07-04 17:12:59.057 ERROR neutron.api.v2.resource [req-33bb4fd7-25a5-4460-82d0-ab5e5b8d574c ctx_rally_8204b9df57e44bcf9804a278c35bf2a4_user_0 8204b9df57e44bcf9804a278c35bf2a4] add_router_interface failed 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource Traceback (most recent call last): 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/resource.py", line 84, in resource 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource result = method(request=request, **args) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 148, in wrapper 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource ectxt.value = e.inner_exc 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.force_reraise() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 138, in wrapper 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource return f(*args, **kwargs) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/base.py", line 217, in _handle_action 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource ret_value = getattr(self._plugin, name)(*arg_list, **kwargs) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v3/plugin.py", line 1509, in add_router_interface 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource interface=info) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/dhcp_meta/rpc.py", line 121, in handle_router_metadata_access 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource plugin, ctx_elevated, router_id) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/dhcp_meta/rpc.py", line 171, in _create_metadata_access_network 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource {'network': net_data}) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v3/plugin.py", line 452, in create_network 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self._ensure_default_security_group(context, tenant_id) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 710, in _ensure_default_security_group 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource return self._create_default_security_group(context, tenant_id) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 721, in _create_default_security_group 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource context, security_group, default_sg=True) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v3/plugin.py", line 1759, in create_security_group 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource firewall.delete_section(section_id) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.force_reraise() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v3/plugin.py", line 1736, in create_security_group 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource context, security_group, default_sg)) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 189, in create_security_group 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource **kwargs) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.gen.next() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/api.py", line 89, in autonested_transaction 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource yield tx 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.rollback() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.commit() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self._prepare_impl() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self.session.flush() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self._flush(objects) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource transaction.rollback(_capture_exception=True) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource flush_context.execute() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource rec.execute(self) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource uow 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource mapper, table, insert) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource execute(statement, multiparams) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource return meth(self, multiparams, params) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource compiled_sql, distilled_params 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource context) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource util.raise_from_cause(newraise, exc_info) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb, cause=cause) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource context) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource cursor.execute(statement, parameters) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource result = self._query(query) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource conn.query(q) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource result.read() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource first_packet = self.connection._read_packet() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource packet.check_error() 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource err.raise_mysql_exception(self._data) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource _check_mysql_exception(errinfo) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource raise errorclass(errno, errorvalue) 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource DBError: (pymysql.err.IntegrityError) (1062, u"Duplicate entry '' for key 'PRIMARY'") [SQL: u'INSERT INTO default_security_group (tenant_id, security_group_id) VALUES (%(tenant_id)s, %(security_group_id)s)'] [parameters: {'tenant_id': '', 'security_group_id': '7e39244d-922c-4e3a-b93e-db6125bcb7e6'}] 2016-07-04 17:12:59.057 TRACE neutron.api.v2.resource To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1599086/+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