← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 2098384] [NEW] VM creation fails if the image has a property with long name or value

 

Public bug reported:

Reproduction:
* start devstack from recent master
* add a property to the default cirros image with long name and or value
  $ openstack image set cirros-0.6.3-x86_64-disk --property $(printf %254s |tr " " "x")=$(printf %254s |tr " " "y")

* observe that glance accepted the new property
$ openstack image show cirros-0.6.3-x86_64-disk
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Field            | Value                                                                                                                                                                                         |
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| checksum         | 87617e24a5e30cb3b87fda8c0764838f                                                                                                                                                              |
| container_format | bare                                                                                                                                                                                          |
| created_at       | 2025-02-10T14:31:23Z                                                                                                                                                                          |
| disk_format      | qcow2                                                                                                                                                                                         |
| file             | /v2/images/f6b95606-af0d-451c-9347-aeb249361fd9/file                                                                                                                                          |
| id               | f6b95606-af0d-451c-9347-aeb249361fd9                                                                                                                                                          |
| min_disk         | 0                                                                                                                                                                                             |
| min_ram          | 0                                                                                                                                                                                             |
| name             | cirros-0.6.3-x86_64-disk                                                                                                                                                                      |
| owner            | cff27e1b5a814c28a633976ff32127e1                                                                                                                                                              |
| properties       | hw_rng_model='virtio', os_hash_algo='sha512',                                                                                                                                                 |
|                  | os_hash_value='9a9bce0083a00939ec17c11febbfc767aa211aaa54f51e75c5a8b271a9b5637c77205a518b7a2007cb391d23cceb01e0e4e8d64832317151bc85b734b92a7be0', os_hidden='False',                          |
|                  | owner_specified.openstack.md5='', owner_specified.openstack.object='images/cirros-0.6.3-x86_64-disk', owner_specified.openstack.sha256='', xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
|                  | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
|                  | xxxxxxxxxxxxxxx='yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy |
|                  | yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy'                                                                                                           |
| protected        | False                                                                                                                                                                                         |
| schema           | /v2/schemas/image                                                                                                                                                                             |
| size             | 21692416                                                                                                                                                                                      |
| status           | active                                                                                                                                                                                        |
| tags             |                                                                                                                                                                                               |
| updated_at       | 2025-02-13T14:52:16Z                                                                                                                                                                          |
| virtual_size     | 117440512                                                                                                                                                                                     |
| visibility       | public                                                                                                                                                                                        |
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+


* boot a VM with the image
$ openstack server create --image cirros-0.6.3-x86_64-disk --flavor c1 --nic none vm1 --wait

Expected:

VM boot successfully

Actual:

VM stuck in BUILD state and conductor logs the following ERROR:

Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [None req-ce433b30-d919-4bfb-b4e0-001b6a0e38b8 admin admin] Exception during message handling: oslo_db.exception.DBDataError: (pymysql.err.DataError) (1406, "Data too long for column 'key' at row 1")
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server Traceback (most recent call last):
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.dialect.do_execute(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     cursor.execute(statement, parameters)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = self._query(query)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     conn.query(q)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result.read()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     first_packet = self.connection._read_packet()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     packet.raise_for_error()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     err.raise_mysql_exception(self._data)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise errorclass(errno, errval)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server pymysql.err.DataError: (1406, "Data too long for column 'key' at row 1")
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server 
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server The above exception was the direct cause of the following exception:
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server 
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server Traceback (most recent call last):
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/server.py", line 174, in _process_incoming
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     res = self.dispatcher.dispatch(message)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/dispatcher.py", line 309, in dispatch
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return self._do_dispatch(endpoint, method, ctxt, args)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/dispatcher.py", line 229, in _do_dispatch
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = func(ctxt, **new_args)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/conductor/manager.py", line 1729, in schedule_and_build_instances
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     instance.create()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_versionedobjects/base.py", line 226, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return fn(self, *args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/objects/instance.py", line 652, in create
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     db_inst = db.instance_create(self._context, updates)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/utils.py", line 35, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py", line 144, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     with excutils.save_and_reraise_exception() as ectxt:
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_utils/excutils.py", line 227, in __exit__
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.force_reraise()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise self.value
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py", line 142, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 207, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(context, *args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 1291, in instance_create
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ec2_instance_create(context, instance_ref['uuid'])
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/utils.py", line 35, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 207, in wrapper
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(context, *args, **kwargs)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 4095, in ec2_instance_create
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ec2_instance_ref.save(context.session)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/sqlalchemy/models.py", line 38, in save
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     session.flush()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4353, in flush
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._flush(objects)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4488, in _flush
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     with util.safe_reraise():
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise exc_value.with_traceback(exc_tb)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4449, in _flush
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     flush_context.execute()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     rec.execute(self)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     util.preloaded.orm_persistence.save_obj(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     _emit_insert_statements(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = connection.execute(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return meth(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return connection._execute_clauseelement(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ret = self._execute_context(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server           ^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return self._exec_single_context(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._handle_dbapi_exception(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2349, in _handle_dbapi_exception
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise newraise.with_traceback(exc_info[2]) from e
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.dialect.do_execute(
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     cursor.execute(statement, parameters)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = self._query(query)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     conn.query(q)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result.read()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     first_packet = self.connection._read_packet()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     packet.raise_for_error()
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     err.raise_mysql_exception(self._data)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise errorclass(errno, errval)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server oslo_db.exception.DBDataError: (pymysql.err.DataError) (1406, "Data too long for column 'key' at row 1")
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [SQL: INSERT INTO instance_system_metadata (`key`, value, instance_uuid, created_at, updated_at, deleted_at, deleted) VALUES (%(key)s, %(value)s, %(instance_uuid)s, %(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s)]
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [parameters: {'key': 'image_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'value': 'yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy', 'instance_uuid': '52af5fa9-2ccf-40cf-ad6e-2b43c048ad0f', 'created_at': datetime.datetime(2025, 2, 13, 14, 57, 15, 549991), 'updated_at': None, 'deleted_at': None, 'deleted': 0}]
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server (Background on this error at: https://sqlalche.me/e/20/9h9h)
Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server

** Affects: nova
     Importance: Undecided
         Status: New


** Tags: db glance

** Tags added: db glance

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/2098384

Title:
  VM creation fails if the image has a property with long name or value

Status in OpenStack Compute (nova):
  New

Bug description:
  Reproduction:
  * start devstack from recent master
  * add a property to the default cirros image with long name and or value
    $ openstack image set cirros-0.6.3-x86_64-disk --property $(printf %254s |tr " " "x")=$(printf %254s |tr " " "y")

  * observe that glance accepted the new property
  $ openstack image show cirros-0.6.3-x86_64-disk
  +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | Field            | Value                                                                                                                                                                                         |
  +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | checksum         | 87617e24a5e30cb3b87fda8c0764838f                                                                                                                                                              |
  | container_format | bare                                                                                                                                                                                          |
  | created_at       | 2025-02-10T14:31:23Z                                                                                                                                                                          |
  | disk_format      | qcow2                                                                                                                                                                                         |
  | file             | /v2/images/f6b95606-af0d-451c-9347-aeb249361fd9/file                                                                                                                                          |
  | id               | f6b95606-af0d-451c-9347-aeb249361fd9                                                                                                                                                          |
  | min_disk         | 0                                                                                                                                                                                             |
  | min_ram          | 0                                                                                                                                                                                             |
  | name             | cirros-0.6.3-x86_64-disk                                                                                                                                                                      |
  | owner            | cff27e1b5a814c28a633976ff32127e1                                                                                                                                                              |
  | properties       | hw_rng_model='virtio', os_hash_algo='sha512',                                                                                                                                                 |
  |                  | os_hash_value='9a9bce0083a00939ec17c11febbfc767aa211aaa54f51e75c5a8b271a9b5637c77205a518b7a2007cb391d23cceb01e0e4e8d64832317151bc85b734b92a7be0', os_hidden='False',                          |
  |                  | owner_specified.openstack.md5='', owner_specified.openstack.object='images/cirros-0.6.3-x86_64-disk', owner_specified.openstack.sha256='', xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
  |                  | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
  |                  | xxxxxxxxxxxxxxx='yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy |
  |                  | yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy'                                                                                                           |
  | protected        | False                                                                                                                                                                                         |
  | schema           | /v2/schemas/image                                                                                                                                                                             |
  | size             | 21692416                                                                                                                                                                                      |
  | status           | active                                                                                                                                                                                        |
  | tags             |                                                                                                                                                                                               |
  | updated_at       | 2025-02-13T14:52:16Z                                                                                                                                                                          |
  | virtual_size     | 117440512                                                                                                                                                                                     |
  | visibility       | public                                                                                                                                                                                        |
  +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

  
  * boot a VM with the image
  $ openstack server create --image cirros-0.6.3-x86_64-disk --flavor c1 --nic none vm1 --wait

  Expected:

  VM boot successfully

  Actual:

  VM stuck in BUILD state and conductor logs the following ERROR:

  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [None req-ce433b30-d919-4bfb-b4e0-001b6a0e38b8 admin admin] Exception during message handling: oslo_db.exception.DBDataError: (pymysql.err.DataError) (1406, "Data too long for column 'key' at row 1")
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server Traceback (most recent call last):
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.dialect.do_execute(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     cursor.execute(statement, parameters)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = self._query(query)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     conn.query(q)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result.read()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     first_packet = self.connection._read_packet()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     packet.raise_for_error()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     err.raise_mysql_exception(self._data)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise errorclass(errno, errval)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server pymysql.err.DataError: (1406, "Data too long for column 'key' at row 1")
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server 
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server The above exception was the direct cause of the following exception:
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server 
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server Traceback (most recent call last):
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/server.py", line 174, in _process_incoming
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     res = self.dispatcher.dispatch(message)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/dispatcher.py", line 309, in dispatch
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return self._do_dispatch(endpoint, method, ctxt, args)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/oslo.messaging/oslo_messaging/rpc/dispatcher.py", line 229, in _do_dispatch
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = func(ctxt, **new_args)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/conductor/manager.py", line 1729, in schedule_and_build_instances
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     instance.create()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_versionedobjects/base.py", line 226, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return fn(self, *args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/objects/instance.py", line 652, in create
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     db_inst = db.instance_create(self._context, updates)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/utils.py", line 35, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py", line 144, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     with excutils.save_and_reraise_exception() as ectxt:
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_utils/excutils.py", line 227, in __exit__
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.force_reraise()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_utils/excutils.py", line 200, in force_reraise
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise self.value
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py", line 142, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 207, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(context, *args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 1291, in instance_create
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ec2_instance_create(context, instance_ref['uuid'])
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/utils.py", line 35, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(*args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 207, in wrapper
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return f(context, *args, **kwargs)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/nova/nova/db/main/api.py", line 4095, in ec2_instance_create
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ec2_instance_ref.save(context.session)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/sqlalchemy/models.py", line 38, in save
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     session.flush()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4353, in flush
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._flush(objects)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4488, in _flush
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     with util.safe_reraise():
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise exc_value.with_traceback(exc_tb)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4449, in _flush
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     flush_context.execute()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     rec.execute(self)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     util.preloaded.orm_persistence.save_obj(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     _emit_insert_statements(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = connection.execute(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return meth(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return connection._execute_clauseelement(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     ret = self._execute_context(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server           ^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     return self._exec_single_context(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server            ^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._handle_dbapi_exception(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2349, in _handle_dbapi_exception
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise newraise.with_traceback(exc_info[2]) from e
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self.dialect.do_execute(
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     cursor.execute(statement, parameters)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 153, in execute
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result = self._query(query)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server              ^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 322, in _query
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     conn.query(q)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 563, in query
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 825, in _read_query_result
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     result.read()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 1199, in read
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     first_packet = self.connection._read_packet()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/connections.py", line 775, in _read_packet
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     packet.raise_for_error()
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/protocol.py", line 219, in raise_for_error
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     err.raise_mysql_exception(self._data)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server   File "/opt/stack/data/venv/lib/python3.12/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server     raise errorclass(errno, errval)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server oslo_db.exception.DBDataError: (pymysql.err.DataError) (1406, "Data too long for column 'key' at row 1")
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [SQL: INSERT INTO instance_system_metadata (`key`, value, instance_uuid, created_at, updated_at, deleted_at, deleted) VALUES (%(key)s, %(value)s, %(instance_uuid)s, %(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s)]
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server [parameters: {'key': 'image_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'value': 'yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy', 'instance_uuid': '52af5fa9-2ccf-40cf-ad6e-2b43c048ad0f', 'created_at': datetime.datetime(2025, 2, 13, 14, 57, 15, 549991), 'updated_at': None, 'deleted_at': None, 'deleted': 0}]
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server (Background on this error at: https://sqlalche.me/e/20/9h9h)
  Feb 13 14:57:15 aio-tmp nova-conductor[100069]: ERROR oslo_messaging.rpc.server

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/2098384/+subscriptions