Public bug reported:
On nova instance delete, the virtual interface records associated with
the instance are not getting marked as deleted on instance delete. This
leads to a DBDuplicateEntry traceback in n-cond.log when the port is
attempted to be used on another instance.
Steps to reproduce:
1. Boot up an instance with a network port.
2. Update the port with "device_id" blank.
3. Delete the nova instance.
4. Attempt to boot a new instance with the port.
Log entry of traceback:
n-cond.log:2016-07-07 20:19:24.587 TRACE nova.db.sqlalchemy.api
DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry
'fa:16:3e:45:4c:1a/44aa08c2-85e5-4d70-878d-7723d96484d1-0' for key
'uniq_virtual_interfaces0address0deleted'") [SQL: u'INSERT INTO
virtual_interfaces (created_at, updated_at, deleted_at, deleted, address,
network_id, instance_uuid, uuid, tag) VALUES (%(created_at)s, %(updated_at)s,
%(deleted_at)s, %(deleted)s, %(address)s, %(network_id)s, %(instance_uuid)s,
%(uuid)s, %(tag)s)'] [parameters: {'instance_uuid':
'34ca6eea-8921-4c1e-8c52-c1873e15898d', 'uuid':
'44aa08c2-85e5-4d70-878d-7723d96484d1', 'network_id': None, 'created_at':
datetime.datetime(2016, 7, 7, 20, 19, 24, 586359), 'updated_at': None,
'deleted': 0, 'tag': None, 'address':
u'fa:16:3e:45:4c:1a/44aa08c2-85e5-4d70-878d-7723d96484d1', 'deleted_at': None}]
** Affects: nova
Importance: High
Assignee: Matt Riedemann (mriedem)
Status: Triaged
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1602357
Title:
Nova is not marking virtual interfaces as deleted in db on instance
delete
Status in OpenStack Compute (nova):
Triaged
Bug description:
On nova instance delete, the virtual interface records associated with
the instance are not getting marked as deleted on instance delete.
This leads to a DBDuplicateEntry traceback in n-cond.log when the port
is attempted to be used on another instance.
Steps to reproduce:
1. Boot up an instance with a network port.
2. Update the port with "device_id" blank.
3. Delete the nova instance.
4. Attempt to boot a new instance with the port.
Log entry of traceback:
n-cond.log:2016-07-07 20:19:24.587 TRACE nova.db.sqlalchemy.api
DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry
'fa:16:3e:45:4c:1a/44aa08c2-85e5-4d70-878d-7723d96484d1-0' for key
'uniq_virtual_interfaces0address0deleted'") [SQL: u'INSERT INTO
virtual_interfaces (created_at, updated_at, deleted_at, deleted, address,
network_id, instance_uuid, uuid, tag) VALUES (%(created_at)s, %(updated_at)s,
%(deleted_at)s, %(deleted)s, %(address)s, %(network_id)s, %(instance_uuid)s,
%(uuid)s, %(tag)s)'] [parameters: {'instance_uuid':
'34ca6eea-8921-4c1e-8c52-c1873e15898d', 'uuid':
'44aa08c2-85e5-4d70-878d-7723d96484d1', 'network_id': None, 'created_at':
datetime.datetime(2016, 7, 7, 20, 19, 24, 586359), 'updated_at': None,
'deleted': 0, 'tag': None, 'address':
u'fa:16:3e:45:4c:1a/44aa08c2-85e5-4d70-878d-7723d96484d1', 'deleted_at': None}]
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1602357/+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
