Activity log for bug #1793419

Date Who What changed Old value New value Message
2018-09-20 01:17:16 Jack Ding bug added bug
2018-09-20 01:38:09 Jack Ding description In our upgrade test, we hit a scenario where the marker instance from the online migration that was run during the Mitaka->Newton upgrade had been deleted and purged from the db by time we ran the Newton->Pike upgrade. This caused the online migration to fail as the marker instance couldn't be found. Description =========== During upgrade we run nova online migration that goes through the list of instances and creates a request spec record in the db if one does not exist. As the online migrations are batched, the request spec migration leaves a marker record in the request_specs table to indicate the last instance uuid that was processed. It continues processing starting from that instances on the next batch. In our upgrade test, we hit a scenario where the marker instance from the online migration that was run during the Mitaka->Newton upgrade had been deleted and purged from the db by time we ran the Newton->Pike upgrade. This caused the online migration to fail as the marker instance couldn't be found. Steps to reproduce ================== - run data online migration on installed Newton load. nova-manage db online_data_migrations - delete the instance referenced by the marker (instance_uuid 00000000-0000-0000-0000-000000000000) - purge db: nova-manage db purge - upgrade to Pike. Expected result =============== Upgrade successful with no exceptions. Actual result ============= Exceptions occur during upgrade with missing marker an upgrade failed. Error attempting to run <function migrate_instances_add_request_spec at 0x5151050> 14 rows matched query service_uuids_online_data_migration, 14 migrated 13 rows matched query migrate_quota_limits_to_api_db, 13 migrated Error attempting to run <function migrate_instances_add_request_spec at 0x5151050> +---------------------------------------------+--------------+-----------+ | Migration | Total Needed | Completed | +---------------------------------------------+--------------+-----------+ | delete_build_requests_with_no_instance_uuid | 0 | 0 | | migrate_aggregate_reset_autoincrement | 0 | 0 | | migrate_aggregates | 0 | 0 | | migrate_flavor_reset_autoincrement | 0 | 0 | | migrate_flavors | 0 | 0 | | migrate_instance_groups_to_api_db | 0 | 0 | | migrate_instance_keypairs | 0 | 0 | | migrate_instances_add_request_spec | 0 | 0 | | migrate_keypairs_to_api_db | 0 | 0 | | migrate_quota_classes_to_api_db | 0 | 0 | | migrate_quota_limits_to_api_db | 0 | 0 | | service_uuids_online_data_migration | 0 | 0 | +---------------------------------------------+--------------+-----------+
2018-09-22 16:45:31 Matt Riedemann tags upgrade
2018-09-22 16:50:14 Matt Riedemann nova: importance Undecided Low
2018-09-22 16:50:16 Matt Riedemann nova: status New Triaged
2018-09-22 16:51:19 Matt Riedemann nominated for series nova/pike
2018-09-22 16:51:19 Matt Riedemann bug task added nova/pike
2018-09-22 16:51:19 Matt Riedemann nominated for series nova/queens
2018-09-22 16:51:19 Matt Riedemann bug task added nova/queens
2018-09-22 16:51:19 Matt Riedemann nominated for series nova/rocky
2018-09-22 16:51:19 Matt Riedemann bug task added nova/rocky
2018-09-22 16:51:26 Matt Riedemann nova/pike: status New Triaged
2018-09-22 16:51:30 Matt Riedemann nova/queens: status New Triaged
2018-09-22 16:51:32 Matt Riedemann nova/rocky: status New Triaged
2018-09-23 11:48:41 Jack Ding nova: assignee Jack Ding (jackding)
2018-09-25 18:16:43 OpenStack Infra nova: status Triaged In Progress
2018-10-02 00:04:43 OpenStack Infra nova: assignee Jack Ding (jackding) Matt Riedemann (mriedem)
2018-10-04 13:50:22 OpenStack Infra nova: assignee Matt Riedemann (mriedem) Jack Ding (jackding)
2018-10-05 03:14:14 OpenStack Infra nova: status In Progress Fix Released
2018-10-08 05:38:32 OpenStack Infra nova/rocky: status Triaged In Progress
2018-10-08 05:38:32 OpenStack Infra nova/rocky: assignee Lee Yarwood (lyarwood)
2018-10-08 13:18:31 OpenStack Infra nova/rocky: assignee Lee Yarwood (lyarwood) Matt Riedemann (mriedem)
2018-10-16 08:13:42 OpenStack Infra nova/rocky: status In Progress Fix Committed
2018-10-16 13:42:26 OpenStack Infra nova/queens: status Triaged In Progress
2018-10-16 13:42:26 OpenStack Infra nova/queens: assignee Matt Riedemann (mriedem)
2018-10-16 13:42:47 Matt Riedemann nova/rocky: assignee Matt Riedemann (mriedem) Lee Yarwood (lyarwood)
2018-10-16 13:43:05 Matt Riedemann nova/pike: importance Undecided Low
2018-10-16 13:43:07 Matt Riedemann nova/queens: importance Undecided Low
2018-10-16 13:43:10 Matt Riedemann nova/rocky: importance Undecided Low
2018-10-17 14:52:25 OpenStack Infra nova/pike: status Triaged In Progress
2018-10-17 14:52:25 OpenStack Infra nova/pike: assignee Matt Riedemann (mriedem)
2018-11-30 22:27:29 OpenStack Infra nova/queens: status In Progress Fix Committed
2019-03-15 23:52:57 OpenStack Infra nova/pike: status In Progress Fix Committed