Hi,
I am currently trying to implement the upgrade path for the image encryption in Glance.
This should change all rows in the image_properties table where the names star with `cinder_encryption*` to `os_encrypt*`
The patch is: https://review.opendev.org/c/openstack/glance/+/926905
When I try to execute the data-migration on my devstack it does
not work. I wonder why? What do I have to do to make it work?
Here is what I tried:
```
stack@devstack:~/devstack$ nano
../glance/glance/db/sqlalchemy/alembic_migrations/data_migrations/2024_2_migrate01_rename_encryption_metadata.py
stack@devstack:~/devstack$ source
/opt/stack/data/venv/bin/activate
(venv) stack@devstack:~/devstack$ glance-manage db migrate
2024_2_migrate01
INFO dbcounter [-] Registered counter for database glance
DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
{{(pid=1782997) _check_effective_sql_mode
/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/sqlalchemy/engines.py:342}}
DEBUG dbcounter [-] [1782997] Writer thread running
{{(pid=1782997) stat_writer
/opt/stack/data/venv/lib/python3.10/site-packages/dbcounter.py:102}}
INFO alembic.runtime.migration [-] Context impl MySQLImpl.
INFO alembic.runtime.migration [-] Will assume non-transactional
DDL.
Database is up to date. No migrations needed.
(venv) stack@devstack:~/devstack$ glance-manage db sync
INFO dbcounter [-] Registered counter for database glance
DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
{{(pid=1783029) _check_effective_sql_mode
/opt/stack/data/venv/lib/python3.10/site-packages/oslo_db/sqlalchemy/engines.py:342}}
DEBUG dbcounter [-] [1783029] Writer thread running
{{(pid=1783029) stat_writer
/opt/stack/data/venv/lib/python3.10/site-packages/dbcounter.py:102}}
INFO alembic.runtime.migration [-] Context impl MySQLImpl.
INFO alembic.runtime.migration [-] Will assume non-transactional
DDL.
Database is up to date. No migrations needed.
(venv) stack@devstack:~/devstack$ openstack image show enc-cirros
+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Field |
Value
|
+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| checksum |
581caa530df8ceecfe5d4a87b847d8fa
|
| container_format |
bare
|
| created_at |
2024-06-21T08:10:23Z
|
| disk_format |
raw
|
| file |
/v2/images/137d3237-3096-4b3f-b2c9-400819211b67/file
|
| id |
137d3237-3096-4b3f-b2c9-400819211b67
|
| min_disk |
0
|
| min_ram |
0
|
| name |
enc-cirros
|
| owner |
db05e1116cb04ac689d82c738a5f103c
|
| properties | cinder_encryption_key_deletion_policy='on_image_deletion',
cinder_encryption_key_id='cf3d7b02-c82c-4a95-b866-9a22af9f87f1',
hw_rng_model='virtio', locations='[{'url': |
```
thank you
Josephine (Luzi)