Devstack and SQLAlchemy (Problems with stack.sh)

Stephen Finucane stephenfin at redhat.com
Tue May 16 14:05:44 UTC 2023


On Tue, 2023-05-16 at 11:31 +0100, Matt Watkins wrote:
> Folks,
> 
> I’m having problems running the devstack install script (stack.sh) under an Ubuntu-22.04.2 VM.
> 
> The same point in the script is causing the install to abort, but the exact error depends on some Python dependencies.
> 
> Anybody have a possible solution to this; it looks like some kind of Python dependency issue?
> 
> Error with SQLAlchemy==1.4.48
> 
> +lib/keystone:init_keystone:489            /usr/local/bin/keystone-manage --config-file /etc/keystone/keystone.conf db_sync
> CRITICAL keystone [-] Unhandled error: sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.plugins:dbcounter
> ERROR keystone   File "/home/devstack/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load
> ERROR keystone     raise exc.NoSuchModuleError(
> ERROR keystone sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.plugins:dbcounter
> 
> Error with SQLAlchemy==2.0.12
> 
> +lib/keystone:init_keystone:489            /usr/local/bin/keystone-manage --config-file /etc/keystone/keystone.conf db_sync
> Traceback (most recent call last):
>   File "/usr/local/lib/python3.10/dist-packages/migrate/changeset/databases/sqlite.py", line 13, in <module>
>     from sqlalchemy.databases import sqlite as sa_base
> ModuleNotFoundError: No module named 'sqlalchemy.databases'
> 
> Thanks in advance,
> 
> - Matt
> 

OpenStack as a whole doesn't support SQLAlchemy 2.x yet so that's the reason for
the second failure. Regarding the latter, has the plugin been installed (you
should see it in 'pip freeze')? We're not seeing this in the gate so my guess
would be that this is something environmental.

Stephen




More information about the openstack-discuss mailing list