答复: [oslo][heat][masakari][senlin][venus][all] oslo.db 13.0.0 will remove sqlalchemy-migrate support

Sam Su (苏正伟) suzhengwei at inspur.com
Thu Mar 30 08:53:47 UTC 2023


Hi, Stephen,
I have tried to remove the dependency on sqlalchemy-migrate from Masakari. But obviously it is not easy to me.
Would you please to take this work? Any help would be very appreciated.


-----邮件原件-----
发件人: Stephen Finucane [mailto:stephenfin at redhat.com] 
发送时间: 2023年3月23日 0:38
收件人: openstack-discuss at lists.openstack.org
主题: [oslo][heat][masakari][senlin][venus][all] oslo.db 13.0.0 will remove sqlalchemy-migrate support

tl;dr: Projects still relying on sqlalchemy-migrate for migrations need to start their switch to alembic immediately. Projects with "legacy" sqlalchemy-migrated based migrations need to drop them.

A quick heads up that oslo.db 13.0.0 will be release in the next month or so and will remove sqlalchemy-migrate support and formally add support for sqlalchemy 2.x. The removal of sqlalchemy-migrate support should only affect projects using oslo.db's sqlalchemy-migrate wrappers, as opposed to using sqlalchemy-migrate directly. For any projects that rely on this functionality, a short-term fix is to vendor the removed code [1] in your project. However, I must emphasise that we're not removing sqlalchemy-migrate integration for the fun of it: it's not compatible with sqlalchemy 2.x and is no longer maintained. If your project uses sqlalchemy-migrate and you haven't migrated to alembic yet, you need to start doing so immediately. If you have migrated to alembic but still have sqlalchemy- migrate "legacy" migrations in-tree, you need to look at dropping these asap.
Anything less will result in broken master when we bump upper-constraints to allow sqlalchemy 2.x in Bobcat. I've listed projects in $subject that appear to be using the removed modules.

For more advice on migrating to sqlalchemy 2.x and alembic, please look at my previous post on the matter [2].

Cheers,
Stephen

[1] https://review.opendev.org/c/openstack/oslo.db/+/853025
[2] https://lists.openstack.org/pipermail/openstack-discuss/2021-August/024122.html


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3606 bytes
Desc: not available
URL: <https://lists.openstack.org/pipermail/openstack-discuss/attachments/20230330/9f99a6ee/attachment.bin>


More information about the openstack-discuss mailing list