Hi Thomas,

We discussed SQLAlchemy 2.x compatibility for cloudkitty in recent IRC meetings and also in the PTG.

I volunteered to start the effort, it would be great if you are able to help/review/test.

Cheers, Pierre Riteau (priteau)

On Wed, 8 Nov 2023 at 13:47, Thomas Goirand zigo@debian.org wrote:

Hi,

As in Debian, a few packages need SQLAlchemy 2.x, I am working toward adding all SQLA 2.x patches as backport to Bobcat. So far, I managed to backport patches for Heat and Glance, and I'll work on Cinder and Manila next.

However, a few packages are failing when using SQLAlchemy 2.x, as per the experimental pseudo-excuse page for sqlalchemy:

https://qa.debian.org/excuses.php?experimental=1&package=sqlalchemy

So, the list of packages is (in alphabetical order):

• cloudkitty
• ironic-inspector
• masakari
• murano
• trove
• sahara
• senlin
• vitrage
• zaqar

These projects need to urgently work toward supporting SQLAlchemy 2.x, both because SQLA 2 will be in distros, and because the OpenStack project requirements needs to move on and bump SQLA to 2.0.

Is there anyone working on this? I'm especially interested having Cloudkitty fixed, since we use it in production, but I'm not sure I have the skills for it. Stephen, who wrote the patches for Cinder, Manila, Glance, Heat and Nova at least, doesn't have the time to work on these, he told me on IRC.

Cheers,

Thomas Goirand (zigo)

Greetings,

Regarding ironic-inspector, I thought we were done, but it seems we never removed autocommit from the actual unit test database initialization code, nor was a force sqlalchemy 2.0 test ever added. I've proposed https://review.opendev.org/900413 and https://review.opendev.org/900414 to address these items.

Also, please be aware that ironic-inspector won't be around much longer. Its core functionality is in the process of being moved into Ironic itself.

-Julia

On Wed, Nov 8, 2023 at 4:55 AM Thomas Goirand zigo@debian.org wrote:

Hi,

As in Debian, a few packages need SQLAlchemy 2.x, I am working toward adding all SQLA 2.x patches as backport to Bobcat. So far, I managed to backport patches for Heat and Glance, and I'll work on Cinder and Manila next.

However, a few packages are failing when using SQLAlchemy 2.x, as per the experimental pseudo-excuse page for sqlalchemy:

https://qa.debian.org/excuses.php?experimental=1&package=sqlalchemy

So, the list of packages is (in alphabetical order):

• cloudkitty
• ironic-inspector
• masakari
• murano
• trove
• sahara
• senlin
• vitrage
• zaqar

These projects need to urgently work toward supporting SQLAlchemy 2.x, both because SQLA 2 will be in distros, and because the OpenStack project requirements needs to move on and bump SQLA to 2.0.

Is there anyone working on this? I'm especially interested having Cloudkitty fixed, since we use it in production, but I'm not sure I have the skills for it. Stephen, who wrote the patches for Cinder, Manila, Glance, Heat and Nova at least, doesn't have the time to work on these, he told me on IRC.

Cheers,

Thomas Goirand (zigo)