```
+ echo 'Running command: '\''/usr/bin/bootstrap_host_exec ironic_api su ironic -s /bin/bash -c '\''ironic-dbsync --config-file /etc/ironic/ironic.conf'\'''\'''
Running command: '/usr/bin/bootstrap_host_exec ironic_api su ironic -s /bin/bash -c 'ironic-dbsync --config-file /etc/ironic/ironic.conf''
+ exec /usr/bin/bootstrap_host_exec ironic_api su ironic -s /bin/bash -c ''\''ironic-dbsync' --config-file '/etc/ironic/ironic.conf'\'''
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> 2581ebaf0cb2, initial migration
INFO [alembic.runtime.migration] Running upgrade 2581ebaf0cb2 -> 21b331f883ef, Add provision_updated_at
INFO [alembic.runtime.migration] Running upgrade 21b331f883ef -> 3cb628139ea4, Nodes add console enabled
INFO [alembic.runtime.migration] Running upgrade 3cb628139ea4 -> 31baaf680d2b, Add Node instance info
INFO [alembic.runtime.migration] Running upgrade 31baaf680d2b -> 3bea56f25597, add unique constraint to instance_uuid
CRITI [ironic] Unhandled error
Traceback (most recent call last):
File "/usr/bin/ironic-dbsync", line 10, in <module>
sys.exit(main())
File "/usr/lib/python3.9/site-packages/ironic/cmd/dbsync.py", line 342, in main
CONF.command.func()
File "/usr/lib/python3.9/site-packages/ironic/cmd/dbsync.py", line 121, in upgrade
migration.upgrade(CONF.command.revision)
File "/usr/lib/python3.9/site-packages/ironic/db/migration.py", line 36, in upgrade
return get_backend().upgrade(version)
File "/usr/lib/python3.9/site-packages/ironic/db/sqlalchemy/migration.py", line 56, in upgrade
alembic.command.upgrade(config, revision or 'head')
File "/usr/lib/python3.9/site-packages/alembic/command.py", line 320, in upgrade
script.run_env()
File "/usr/lib/python3.9/site-packages/alembic/script/base.py", line 563, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 850, in exec_module
File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
File "/usr/lib/python3.9/site-packages/ironic/db/sqlalchemy/alembic/env.py", line 61, in <module>
run_migrations_online()
File "/usr/lib/python3.9/site-packages/ironic/db/sqlalchemy/alembic/env.py", line 58, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/usr/lib/python3.9/site-packages/alembic/runtime/environment.py", line 851, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/lib/python3.9/site-packages/alembic/runtime/migration.py", line 612, in run_migrations
step.migration_fn(**kw)
File "/usr/lib/python3.9/site-packages/ironic/db/sqlalchemy/alembic/versions/3bea56f25597_add_unique_constraint_to_instance_uuid.py", line 32, in upgrade
op.create_unique_constraint("uniq_nodes0instance_uuid", "nodes",
File "<string>", line 8, in create_unique_constraint
File "<string>", line 3, in create_unique_constraint
File "/usr/lib/python3.9/site-packages/alembic/operations/ops.py", line 478, in create_unique_constraint
return operations.invoke(op)
File "/usr/lib/python3.9/site-packages/alembic/operations/base.py", line 387, in invoke
return fn(self, operation)
File "/usr/lib/python3.9/site-packages/alembic/operations/toimpl.py", line 175, in create_constraint
operations.impl.add_constraint(
File "/usr/lib/python3.9/site-packages/alembic/ddl/sqlite.py", line 68, in add_constraint
raise NotImplementedError(
NotImplementedError: No support for ALTER of constraints in SQLite dialectPlease refer to the batch mode feature which allows for SQLite migrations using a copy-and-move strategy.
By testing with dnm patch https:/ /review. opendev. org/c/openstack /tripleo- quickstart/ +/837455/ with depends on https:/ /review. opendev. org/c/openstack /tripleo- heat-templates/ +/836596, the above issue is fixed but now undercloud-upgrade is failing with different error [1]. bootstrap' . rc=1, stdout=, stderr= c470-b3fd- 9b14-000000001b 51 | FATAL | Create containers managed by Podman for /var/lib/ tripleo- config/ container- startup- config/ step_3 | undercloud | error={"changed": false, "msg": "Failed containers: ironic_db_sync, keystone_ bootstrap" } /6ef3897d43ca5b 2f7eff- 13a1490981ac670 93979241f62e5a9 df.ssl. cf2.rackcdn. com/837455/ 1/check/ tripleo- ci-centos- 9-undercloud- upgrade/ 181b185/ logs/undercloud /var/log/ extra/podman/ containers/ ironic_ db_sync/ stdout. log
```
Failure running exec 'keystone_
2022-04-12 07:18:43 | 2022-04-12 07:18:43.486121 | fa163e9f-
```
and while taking a look at failed container logs
https:/
``` bin/bootstrap_ host_exec ironic_api su ironic -s /bin/bash -c '\''ironic-dbsync --config-file /etc/ironic/ ironic. conf'\' ''\''' bootstrap_ host_exec ironic_api su ironic -s /bin/bash -c 'ironic-dbsync --config-file /etc/ironic/ ironic. conf'' bootstrap_ host_exec ironic_api su ironic -s /bin/bash -c ''\''ironic-dbsync' --config-file '/etc/ironic/ ironic. conf'\' '' runtime. migration] Context impl SQLiteImpl. runtime. migration] Will assume non-transactional DDL. runtime. migration] Running upgrade -> 2581ebaf0cb2, initial migration runtime. migration] Running upgrade 2581ebaf0cb2 -> 21b331f883ef, Add provision_ updated_ at runtime. migration] Running upgrade 21b331f883ef -> 3cb628139ea4, Nodes add console enabled runtime. migration] Running upgrade 3cb628139ea4 -> 31baaf680d2b, Add Node instance info runtime. migration] Running upgrade 31baaf680d2b -> 3bea56f25597, add unique constraint to instance_uuid ironic- dbsync" , line 10, in <module> exit(main( )) python3. 9/site- packages/ ironic/ cmd/dbsync. py", line 342, in main command. func() python3. 9/site- packages/ ironic/ cmd/dbsync. py", line 121, in upgrade upgrade( CONF.command. revision) python3. 9/site- packages/ ironic/ db/migration. py", line 36, in upgrade ).upgrade( version) python3. 9/site- packages/ ironic/ db/sqlalchemy/ migration. py", line 56, in upgrade command. upgrade( config, revision or 'head') python3. 9/site- packages/ alembic/ command. py", line 320, in upgrade run_env( ) python3. 9/site- packages/ alembic/ script/ base.py" , line 563, in run_env load_python_ file(self. dir, "env.py") python3. 9/site- packages/ alembic/ util/pyfiles. py", line 92, in load_python_file py(module_ id, path) python3. 9/site- packages/ alembic/ util/pyfiles. py", line 108, in load_module_py loader. exec_module( module) # type: ignore _bootstrap_ external> ", line 850, in exec_module _bootstrap> ", line 228, in _call_with_ frames_ removed python3. 9/site- packages/ ironic/ db/sqlalchemy/ alembic/ env.py" , line 61, in <module> migrations_ online( ) python3. 9/site- packages/ ironic/ db/sqlalchemy/ alembic/ env.py" , line 58, in run_migrations_ online run_migrations( ) python3. 9/site- packages/ alembic/ runtime/ environment. py", line 851, in run_migrations get_context( ).run_migration s(**kw) python3. 9/site- packages/ alembic/ runtime/ migration. py", line 612, in run_migrations migration_ fn(**kw) python3. 9/site- packages/ ironic/ db/sqlalchemy/ alembic/ versions/ 3bea56f25597_ add_unique_ constraint_ to_instance_ uuid.py" , line 32, in upgrade create_ unique_ constraint( "uniq_nodes0ins tance_uuid" , "nodes", unique_ constraint unique_ constraint python3. 9/site- packages/ alembic/ operations/ ops.py" , line 478, in create_ unique_ constraint invoke( op) python3. 9/site- packages/ alembic/ operations/ base.py" , line 387, in invoke python3. 9/site- packages/ alembic/ operations/ toimpl. py", line 175, in create_constraint impl.add_ constraint( python3. 9/site- packages/ alembic/ ddl/sqlite. py", line 68, in add_constraint rror( rror: No support for ALTER of constraints in SQLite dialectPlease refer to the batch mode feature which allows for SQLite migrations using a copy-and-move strategy.
+ echo 'Running command: '\''/usr/
Running command: '/usr/bin/
+ exec /usr/bin/
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
INFO [alembic.
CRITI [ironic] Unhandled error
Traceback (most recent call last):
File "/usr/bin/
sys.
File "/usr/lib/
CONF.
File "/usr/lib/
migration.
File "/usr/lib/
return get_backend(
File "/usr/lib/
alembic.
File "/usr/lib/
script.
File "/usr/lib/
util.
File "/usr/lib/
module = load_module_
File "/usr/lib/
spec.
File "<frozen importlib.
File "<frozen importlib.
File "/usr/lib/
run_
File "/usr/lib/
context.
File "<string>", line 8, in run_migrations
File "/usr/lib/
self.
File "/usr/lib/
step.
File "/usr/lib/
op.
File "<string>", line 8, in create_
File "<string>", line 3, in create_
File "/usr/lib/
return operations.
File "/usr/lib/
return fn(self, operation)
File "/usr/lib/
operations.
File "/usr/lib/
raise NotImplementedE
NotImplementedE
```
[1]. https:/ /6ef3897d43ca5b 2f7eff- 13a1490981ac670 93979241f62e5a9 df.ssl. cf2.rackcdn. com/837455/ 1/check/ tripleo- ci-centos- 9-undercloud- upgrade/ 181b185/ logs/undercloud /home/zuul/ undercloud_ upgrade. log