`WHERE records.managed = true AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_resource_id = %(managed_resource_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.zone_id < %(zone_id_1)s ORDER BY records.created_at ASC, records.id ASC]
['Traceback (most recent call last):\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1800, in _execute_context\n context = constructor(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1120, in _init_compiled\n param = {\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1121, in <dictcomp>\n key: processors[key](compiled_params[key])\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1660, in process\n return process_param(value, dialect)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/types.py", line 46, in process_bind_param\n return "%.32x" % uuid.UUID(value).int\n', ' File "/usr/lib/python3.10/uuid.py", line 177, in __init__\n raise ValueError(\'badly formed hexadecimal UUID string\')\n', 'ValueError: badly formed hexadecimal UUID string\n', '\nThe above exception was the direct cause of the following exception:\n\n', 'Traceback (most recent call last):\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/server.py", line 165, in _process_incoming\n res = self.dispatcher.dispatch(message)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/dispatcher.py", line 309, in dispatch\n return self._do_dispatch(endpoint, method, ctxt, args)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/dispatcher.py", line 229, in _do_dispatch\n result = func(ctxt, **new_args)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/common/decorators/rpc.py", line 41, in exception_wrapper\n return f(cls, *args, **kwargs)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/central/service.py", line 1549, in delete_managed_records\n records = self.storage.find_records(context, criterion)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 1222, in find_records\n return self._find_records(context, criterion, marker=marker,\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 1165, in _find_records\n return self._find(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/base.py", line 305, in _find\n resultproxy = session.execute(query)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1712, in execute\n result = conn._execute_20(statement, params or {}, execution_options)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20\n return meth(self, args_10style, kwargs_10style, execution_options)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection\n return connection._execute_clauseelement(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement\n ret = self._execute_context(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1806, in _execute_context\n self._handle_dbapi_exception(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception\n util.raise_(newraise, with_traceback=exc_info[2], from_=e)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_\n raise exception\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1800, in _execute_context\n context = constructor(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1120, in _init_compiled\n param = {\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1121, in <dictcomp>\n key: processors[key](compiled_params[key])\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1660, in process\n return process_param(value, dialect)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/types.py", line 46, in process_bind_param\n return "%.32x" % uuid.UUID(value).int\n', ' File "/usr/lib/python3.10/uuid.py", line 177, in __init__\n raise ValueError(\'badly formed hexadecimal UUID string\')\n', 'oslo_db.exception.DBError: (builtins.ValueError) badly formed hexadecimal UUID string\n[SQL: SELECT records.id, records.version, records.created_at, records.updated_at, records.zone_shard, records.tenant_id, records.zone_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial \nFROM records \nWHERE records.managed = true AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_resource_id = %(managed_resource_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.zone_id < %(zone_id_1)s ORDER BY records.created_at ASC, records.id ASC]\n'].
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher Traceback (most recent call last):
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/notify/dispatcher.py", line 78, in _exec_callback
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher return callback(message["ctxt"],
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/sink/service.py", line 124, in info
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher handler.process_notification(context, event_type, payload)
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/notification_handler/neutron.py", line 54, in process_notification
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher self._delete(zone_id=zone_id,
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/notification_handler/base.py", line 180, in _delete
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher self.central_api.delete_managed_records(
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/central/rpcapi.py", line 242, in delete_managed_records
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher return self.client.call(context, 'delete_managed_records',
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/client.py", line 546, in call
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher return self.prepare().call(ctxt, method, **kwargs)
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/client.py", line 190, in call
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher result = self.transport._send(
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/transport.py", line 123, in _send
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher return self._driver.send(target, ctxt, message,
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 689, in send
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher return self._send(target, ctxt, message, wait_for_reply, timeout,
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/_drivers/amqpdriver.py", line 681, in _send
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher raise result
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher oslo_messaging.rpc.client.RemoteError: Remote error: DBError (builtins.ValueError) badly formed hexadecimal UUID string
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher [SQL: SELECT records.id, records.version, records.created_at, records.updated_at, records.zone_shard, records.tenant_id, records.zone_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher FROM records
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher WHERE records.managed = true AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_resource_id = %(managed_resource_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.zone_id < %(zone_id_1)s ORDER BY records.created_at ASC, records.id ASC]
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher ['Traceback (most recent call last):\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1800, in _execute_context\n context = constructor(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1120, in _init_compiled\n param = {\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1121, in <dictcomp>\n key: processors[key](compiled_params[key])\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1660, in process\n return process_param(value, dialect)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/types.py", line 46, in process_bind_param\n return "%.32x" % uuid.UUID(value).int\n', ' File "/usr/lib/python3.10/uuid.py", line 177, in __init__\n raise ValueError(\'badly formed hexadecimal UUID string\')\n', 'ValueError: badly formed hexadecimal UUID string\n', '\nThe above exception was the direct cause of the following exception:\n\n', 'Traceback (most recent call last):\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/server.py", line 165, in _process_incoming\n res = self.dispatcher.dispatch(message)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/dispatcher.py", line 309, in dispatch\n return self._do_dispatch(endpoint, method, ctxt, args)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/oslo_messaging/rpc/dispatcher.py", line 229, in _do_dispatch\n result = func(ctxt, **new_args)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/common/decorators/rpc.py", line 41, in exception_wrapper\n return f(cls, *args, **kwargs)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/central/service.py", line 1549, in delete_managed_records\n records = self.storage.find_records(context, criterion)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 1222, in find_records\n return self._find_records(context, criterion, marker=marker,\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 1165, in _find_records\n return self._find(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/base.py", line 305, in _find\n resultproxy = session.execute(query)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1712, in execute\n result = conn._execute_20(statement, params or {}, execution_options)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20\n return meth(self, args_10style, kwargs_10style, execution_options)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection\n return connection._execute_clauseelement(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement\n ret = self._execute_context(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1806, in _execute_context\n self._handle_dbapi_exception(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception\n util.raise_(newraise, with_traceback=exc_info[2], from_=e)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_\n raise exception\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1800, in _execute_context\n context = constructor(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1120, in _init_compiled\n param = {\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 1121, in <dictcomp>\n key: processors[key](compiled_params[key])\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1660, in process\n return process_param(value, dialect)\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/types.py", line 46, in process_bind_param\n return "%.32x" % uuid.UUID(value).int\n', ' File "/usr/lib/python3.10/uuid.py", line 177, in __init__\n raise ValueError(\'badly formed hexadecimal UUID string\')\n', 'oslo_db.exception.DBError: (builtins.ValueError) badly formed hexadecimal UUID string\n[SQL: SELECT records.id, records.version, records.created_at, records.updated_at, records.zone_shard, records.tenant_id, records.zone_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial \nFROM records \nWHERE records.managed = true AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_resource_id = %(managed_resource_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.zone_id < %(zone_id_1)s ORDER BY records.created_at ASC, records.id ASC]\n'].
2023-08-06 20:52:40.540 18 ERROR oslo_messaging.notify.dispatcher`
