The devstack zuul jobs for config are failing.
The error looks to be a database migration failure when initializing the glance DB
These are the DB components being installed
psycopg2 2.8.3
SQLAlchemy 1.3.6
Sqlalchemy_migrate 0.12.0
I think this may be due to this upstream commit which merged this morning
https://review.opendev.org/#/c/665606/
I don’t have any idea on how to fix this. We can disable the jobs, or remove glance from our devstack jobs, but we are blocked until this is resolved.
It may affect other flock repos as well, if they also have devstack jobs that are setting up glance.
Example stacktrace:
File "/opt/stack/glance/glance/db/sqlalchemy/alembic_migrations/data_migrations/train_migrate01_backend_to_store.py", line 28, in has_migrations
metadata_backend = con.execute(sql_query)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 982, in execute
return self._execute_text(object_, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _execute_text
parameters,
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1464, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 552, in do_execute
cursor.execute(statement, parameters)
DBError: (psycopg2.errors.UndefinedFunction) function instr(text, unknown) does not exist
LINE 1: select meta_data from image_locations where INSTR(meta_data,...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
[SQL: select meta_data from image_locations where INSTR(meta_data, '"backend":') > 0]
(Background on this error at: http://sqlalche.me/e/f405)
Upgraded database to: train_expand01, current revision(s): train_expand01