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)