Hi everyone!

It seems like our db-init jobs are broken with the latest version of OpenStack because it doesn’t work with SQLAlchemy 2.0

2024-05-31 03:21:34,290 - OpenStack-Helm DB Init - INFO - Got DB root connection

2024-05-31 03:21:34,290 - OpenStack-Helm DB Init - INFO - Using /etc/keystone/keystone.conf as db config source

2024-05-31 03:21:34,292 - OpenStack-Helm DB Init - INFO - Trying to load db config from database:connection

2024-05-31 03:21:34,292 - OpenStack-Helm DB Init - INFO - Got config from /etc/keystone/keystone.conf

2024-05-31 03:21:34,331 - OpenStack-Helm DB Init - INFO - Tested connection to DB @ percona-xtradb-haproxy.openstack.svc.cluster.local:3306 as root

2024-05-31 03:21:34,332 - OpenStack-Helm DB Init - INFO - Got user db config

2024-05-31 03:21:34,332 - OpenStack-Helm DB Init - CRITICAL - Could not create database keystone

Traceback (most recent call last):

  File "/tmp/db-init.py", line 112, in <module>

    root_engine.execute("CREATE DATABASE IF NOT EXISTS {0}".format(database))

AttributeError: 'Engine' object has no attribute 'execute'

I was wondering if it makes sense to fix this, or if this is something that we should just take the time to simply replace with some sort of simple operator that creates manages/watches database CRs (if one doesn’t exist?)

Thanks

Mohammed