[Expired for OpenStack Compute (nova) because there has been no activity
for 60 days.]
** Changed in: nova
Status: Incomplete => Expired
--
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/1854628
Title:
Got 'Duplicate entry' error when archive_deleted_rows
Status in OpenStack Compute (nova):
Expired
Bug description:
Description
===========
When archiving deleted rows of nova database, archive successfully at first
time.
Then archived again, got error.
Steps to reproduce
==================
* Execute `nova-manage db archive_deleted_rows --all-cells`
* Create some instances, stop, reboot, and delete it
* Execute `nova-manage db archive_deleted_rows --all-cells`
Expected result
===============
Archive successfully
Actual result
=============
Failed
Environment
===========
nova:
# git log
commit ab6834145f3fe1d33ce7f292727a6bc2be50efd9 (HEAD -> stable/train,
origin/stable/train)
Merge: 66585e8af1 821506a50c
Author: Zuul <[email protected]>
Date: Mon Oct 21 18:50:20 2019 +0000
Merge "Fix exception translation when creating volume" into
stable/train
Logs
===============
oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062,
"Duplicate entry '1' for key 'PRIMARY'")
[SQL: INSERT INTO shadow_instance_actions_events (created_at, updated_at,
deleted_at, deleted, id, event, action_id, start_time, finish_time, result,
traceback, host, details) SELECT instance_actions_events.created_at,
instance_actions_events.updated_at, instance_actions_events.deleted_at,
instance_actions_events.deleted, instance_actions_events.id,
instance_actions_events.event, instance_actions_events.action_id,
instance_actions_events.start_time, instance_actions_events.finish_time,
instance_actions_events.result, instance_actions_events.traceback,
instance_actions_events.host, instance_actions_events.details
FROM instance_actions_events, instances, instance_actions
WHERE instances.deleted != %(deleted_1)s AND instances.uuid =
instance_actions.instance_uuid AND instance_actions.id =
instance_actions_events.action_id ORDER BY instance_actions_events.id
LIMIT %(param_1)s]
[parameters: {'deleted_1': 0, 'param_1': 1000}]
(Background on this error at: http://sqlalche.me/e/gkpj)
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1854628/+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
