+ echo 'Start Staffeln DB sync'
+ staffeln-db-manage upgrade
Start Staffeln DB sync
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 041d9a0f1159, Add volume_name and instance_name to queue_data
CRITI [staffeln] Unhandled error
Traceback (most recent call last):
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
             ^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 575, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 826, in _read_query_result
    result.read()
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 1203, in read
    first_packet = self.connection._read_packet()
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 782, in _read_packet
    packet.raise_for_error()
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'staffeln.queue_data' doesn't exist")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/var/lib/openstack/bin/staffeln-db-manage", line 10, in <module>
    sys.exit(main())
             ^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/cmd/dbmanage.py", line 64, in main
    CONF.command.func()
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/cmd/dbmanage.py", line 25, in do_upgrade
    migration.upgrade(CONF.command.revision)
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/db/migration.py", line 29, in upgrade
    return get_backend().upgrade(version)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/db/sqlalchemy/migration.py", line 53, in upgrade
    get_manager().upgrade(version)
  File "/var/lib/openstack/lib/python3.12/site-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 74, in upgrade
    results.append(plugin.upgrade(revision))
                   ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/oslo_db/sqlalchemy/migration_cli/ext_alembic.py", line 50, in upgrade
    return alembic.command.upgrade(self.config, version or 'head')
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/command.py", line 483, in upgrade
    script.run_env()
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/script/base.py", line 545, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/util/pyfiles.py", line 116, in load_python_file
    module = load_module_py(module_id, path)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/util/pyfiles.py", line 136, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 995, in exec_module
  File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/db/sqlalchemy/alembic/env.py", line 54, in <module>
    run_migrations_online()
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/db/sqlalchemy/alembic/env.py", line 51, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/runtime/environment.py", line 946, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
    step.migration_fn(**kw)
  File "/var/lib/openstack/lib/python3.12/site-packages/staffeln/db/sqlalchemy/alembic/versions/041d9a0f1159_backup_add_names.py", line 20, in upgrade
    op.add_column(
  File "<string>", line 8, in add_column
  File "<string>", line 3, in add_column
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/operations/ops.py", line 2186, in add_column
    return operations.invoke(op)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/operations/base.py", line 441, in invoke
    return fn(self, operation)
           ^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/operations/toimpl.py", line 175, in add_column
    operations.impl.add_column(
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/ddl/impl.py", line 378, in add_column
    self._exec(
  File "/var/lib/openstack/lib/python3.12/site-packages/alembic/ddl/impl.py", line 246, in _exec
    return conn.execute(construct, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
    return meth(
           ^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/sql/ddl.py", line 187, in _execute_on_connection
    return connection._execute_ddl(
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1530, in _execute_ddl
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception
    raise newraise.with_traceback(exc_info[2]) from e
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/var/lib/openstack/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
             ^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 575, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 826, in _read_query_result
    result.read()
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 1203, in read
    first_packet = self.connection._read_packet()
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/connections.py", line 782, in _read_packet
    packet.raise_for_error()
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/var/lib/openstack/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'staffeln.queue_data' doesn't exist")
[SQL: ALTER TABLE queue_data ADD COLUMN volume_name VARCHAR(100)]
(Background on this error at: https://sqlalche.me/e/20/f405)
+ staffeln-db-manage create_schema
Finished Staffeln DB sync
+ echo 'Finished Staffeln DB sync'