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)