** Changed in: neutron
Status: Fix Committed => Fix Released
** Changed in: neutron
Milestone: None => kilo-1
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1367032
Title:
NSX: unabled to delete provider network
Status in OpenStack Neutron (virtual network service):
Fix Released
Bug description:
2014-09-08 14:56:29.981 TRACE neutron.api.v2.resource
2014-09-08 14:59:52.729 ERROR oslo.db.sqlalchemy.exc_filters
[req-95d62444-0b6f-4710-93f1-c5718b257762 admin
236c7a84a5b24a5b93053b9649e09b47] DBAPIError exception wrapped from
(IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key
constraint fails (`neutron`.`tz_network_bindings`, CONSTRAINT
`tz_network_bindings_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks`
(`id`))') 'DELETE FROM networks WHERE networks.id = %s'
('7e6f7301-faf8-4e7b-b635-1f91d22aa955',)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters Traceback (most
recent call last):
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py",
line 59, in _handle_dbapi_exception
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters e,
statement, parameters, cursor, context)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in
_handle_dbapi_exception
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters exc_info
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in
raise_from_cause
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters
reraise(type(exception), exception, tb=exc_tb)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in
_execute_context
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters context)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in
do_execute
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters
self.errorhandler(self, exc, value)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters raise
errorclass, errorvalue
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters IntegrityError:
(IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key
constraint fails (`neutron`.`tz_network_bindings`, CONSTRAINT
`tz_network_bindings_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks`
(`id`))') 'DELETE FROM networks WHERE networks.id = %s'
('7e6f7301-faf8-4e7b-b635-1f91d22aa955',)
2014-09-08 14:59:52.729 TRACE oslo.db.sqlalchemy.exc_filters
2014-09-08 14:59:52.804 ERROR neutron.api.v2.resource
[req-95d62444-0b6f-4710-93f1-c5718b257762 admin
236c7a84a5b24a5b93053b9649e09b47] delete failed
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource Traceback (most recent
call last):
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/opt/stack/neutron/neutron/api/v2/resource.py", line 87, in resource
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource result =
method(request=request, **args)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/opt/stack/neutron/neutron/api/v2/base.py", line 476, in delete
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
obj_deleter(request.context, id, **kwargs)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/opt/stack/neutron/neutron/plugins/vmware/plugins/base.py", line 1005, in
delete_network
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource super(NsxPluginV2,
self).delete_network(context, id)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 912, in
delete_network
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
context.session.delete(network)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 447, in
__exit__
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource self.rollback()
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 58, in
__exit__
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
compat.reraise(exc_type, exc_value, exc_tb)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 444, in
__exit__
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource self.commit()
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 354, in
commit
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource self._prepare_impl()
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 334, in
_prepare_impl
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource self.session.flush()
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1818, in
flush
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource self._flush(objects)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1936, in
_flush
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
transaction.rollback(_capture_exception=True)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 58, in
__exit__
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
compat.reraise(exc_type, exc_value, exc_tb)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1900, in
_flush
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
flush_context.execute()
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in
execute
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource rec.execute(self)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 553, in
execute
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource uow
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 116, in
delete_obj
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource cached_connections,
mapper, table, delete)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 681, in
_emit_delete_statements
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
connection.execute(statement, del_objects)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in
execute
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource params)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in
_execute_clauseelement
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource compiled_sql,
distilled_params
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in
_execute_context
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource context)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py",
line 125, in _handle_dbapi_exception
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
six.reraise(type(newraise), newraise, sys.exc_info()[2])
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py",
line 102, in _handle_dbapi_exception
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource per_fn = fn(ctx)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py",
line 323, in handler
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource
context.is_disconnect)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource File
"/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py",
line 278, in _raise_for_remaining_DBAPIError
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource raise
exception.DBError(error)
2014-09-08 14:59:52.804 TRACE neutron.api.v2.resource DBError:
(IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key
constraint fails (`neutron`.`tz_network_bindings`, CONSTRAINT
`tz_network_bindings_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks`
(`id`))') 'DELETE FROM networks WHERE networks.id = %s'
('7e6f7301-faf8-4e7b-b635-1f91d22aa955',)
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1367032/+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
