Public bug reported: 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 log: 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) ** Affects: nova Importance: Undecided Status: New -- 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): New 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 log: 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
