Public bug reported:
Ubuntu 24.04
Package-based deployment
controller01:~# apt-cache policy heat-api
heat-api:
Installed: 1:26.0.0-0ubuntu1~cloud0
Candidate: 1:26.0.0-0ubuntu1~cloud0
controller01:~# apt-cache policy python3-heat
python3-heat:
Installed: 1:26.0.0-0ubuntu1~cloud0
Candidate: 1:26.0.0-0ubuntu1~cloud0
While testing the SLURP upgrade from E to G the heat-manage db sync
command fails on the first controller node. According to the upgrade
notes [0] a new table should be created, but it fails:
controller01:~# heat-manage db_sync
2026-06-05 14:44:36.662 970322 INFO heat.db.migration [-] Applying migration(s)
2026-06-05 14:44:36.689 970322 INFO alembic.runtime.migration [-] Context impl
MySQLImpl.
2026-06-05 14:44:36.690 970322 INFO alembic.runtime.migration [-] Will assume
non-transactional DDL.
2026-06-05 14:44:36.699 970322 INFO alembic.runtime.migration [-] Context impl
MySQLImpl.
2026-06-05 14:44:36.699 970322 INFO alembic.runtime.migration [-] Will assume
non-transactional DDL.
2026-06-05 14:44:36.706 970322 INFO alembic.runtime.migration [-] Running
upgrade c6214ca60943 -> d2db381e3324, Add extra_data column to sync_point table
2026-06-05 14:44:36.778 970322 INFO alembic.runtime.migration [-] Running
upgrade d2db381e3324 -> 88be64598c0f, Add resource_snapshot table
ERROR: (pymysql.err.OperationalError) (1005, 'Can\'t create table
`heat`.`resource_snapshot` (errno: 150 "Foreign key constraint is incorrectly
formed")')
[SQL:
CREATE TABLE resource_snapshot (
id VARCHAR(36) NOT NULL,
snapshot_id VARCHAR(36) NOT NULL,
resource_name VARCHAR(255) NOT NULL,
created_at DATETIME,
updated_at DATETIME,
data LONGTEXT,
PRIMARY KEY (id),
FOREIGN KEY(snapshot_id) REFERENCES snapshot (id)
)ENGINE=InnoDB
]
[0] https://docs.openstack.org/releasenotes/heat/2026.1.html#upgrade-notes
** Affects: heat (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2155643
Title:
Upgrade Epoxy to Gazpacho: heat-manage db sync fails creating new
table resource_snapshot
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/heat/+bug/2155643/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
