Bug 1955696 - [RFE] Migrate database migrations from sqlalchemy-migrate to alembic
Summary: [RFE] Migrate database migrations from sqlalchemy-migrate to alembic
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 17.0 (Wallaby)
Hardware: All
OS: Linux
medium
medium
Target Milestone: Upstream M3
: ---
Assignee: Stephen Finucane
QA Contact: OSP DFG:Compute
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-04-30 16:52 UTC by Stephen Finucane
Modified: 2023-04-14 18:52 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-04-14 18:50:12 UTC
Target Upstream Version: Xena
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 786291 0 None None None 2021-08-19 16:16:33 UTC
OpenStack gerrit 786292 0 None None None 2021-08-19 16:16:34 UTC
OpenStack gerrit 786293 0 None None None 2021-08-19 16:16:35 UTC
OpenStack gerrit 786295 0 None None None 2021-08-19 16:12:11 UTC
OpenStack gerrit 786296 0 None None None 2021-08-19 16:16:37 UTC
OpenStack gerrit 786297 0 None None None 2021-08-19 16:12:11 UTC
OpenStack gerrit 786298 0 None None None 2021-08-19 16:16:40 UTC
OpenStack gerrit 786299 0 None None None 2021-08-19 16:16:40 UTC
OpenStack gerrit 786300 0 None None None 2021-08-19 16:16:41 UTC
OpenStack gerrit 786301 0 None None None 2021-08-19 16:16:42 UTC
OpenStack gerrit 796519 0 None None None 2021-08-19 16:16:43 UTC
OpenStack gerrit 796814 0 None None None 2021-08-19 16:16:43 UTC
OpenStack gerrit 799518 0 None None None 2021-08-19 16:16:44 UTC
OpenStack gerrit 799519 0 None None None 2021-08-19 16:16:45 UTC
OpenStack gerrit 799520 0 None None None 2021-08-19 16:16:45 UTC
OpenStack gerrit 799521 0 None None None 2021-08-19 16:16:46 UTC
OpenStack gerrit 799522 0 None None None 2021-08-19 16:16:46 UTC
OpenStack gerrit 799523 0 None None None 2021-08-19 16:16:47 UTC
OpenStack gerrit 799524 0 None None None 2021-08-19 16:16:48 UTC
OpenStack gerrit 799525 0 None None None 2021-08-19 16:16:49 UTC
OpenStack gerrit 799526 0 None None None 2021-08-19 16:16:50 UTC
OpenStack gerrit 799527 0 None None None 2021-08-19 16:16:50 UTC
OpenStack gerrit 799528 0 None None None 2021-08-19 16:16:51 UTC
OpenStack gerrit 799529 0 None None None 2021-08-19 16:16:52 UTC
OpenStack gerrit 799530 0 None None None 2021-08-19 16:16:53 UTC
OpenStack gerrit 799684 0 None None None 2021-08-19 16:16:53 UTC
OpenStack gerrit 800076 0 None None None 2021-08-19 16:16:55 UTC
OpenStack gerrit 800077 0 None None None 2021-08-19 16:16:55 UTC
OpenStack gerrit 803778 0 None None None 2021-08-19 16:16:55 UTC
Red Hat Issue Tracker OSP-24213 0 None None None 2023-04-14 18:52:42 UTC
Red Hat Issue Tracker OSP-3520 0 None None None 2022-02-03 18:52:41 UTC

Description Stephen Finucane 2021-04-30 16:52:36 UTC
Description of problem:

nova's database migrations are implemented using sqlalchemy-migrate, a defunct and unmaintained library. alembic is the anointed successor that is developed and supported by the sqlalchemy community. The Network (neutron) and Image (glance) services already migrated to alembic some time ago. It is now time for Compute (nova) to do the same. Doing so will reduce some tech debt in the project and bring usability improvements to operators, who can use the same tooling to run database migrations across multiple projects. This RFE tracks the work to migrate the migrations, providing a way for both existing deployments and new deployments to start using alembic for all migrations going forward.

Comment 3 Artom Lifshitz 2023-04-14 18:50:12 UTC
Tracked in https://issues.redhat.com/browse/OSPRH-64


Note You need to log in before you can comment on or make changes to this bug.