Here's the designate sink log for reference
`['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 865, in get_zone\n zone = self.storage.get_zone(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 447, in get_zone\n zone = self._find_zones(context, {\'id\': zone_id}, one=True,\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 374, in _find_zones\n zones = self._find(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/base.py", line 276, in _find\n resultproxy = session.execute(query.limit(2))\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 DISTINCT zones.id, zones.version, zones.created_at, zones.updated_at, zones.deleted, zones.deleted_at, zones.shard, zones.tenant_id, zones.name, zones.email, zones.description, zones.type, zones.transferred_at, zones.ttl, zones.serial, zones.refresh, zones.retry, zones.expire, zones.minimum, zones.status, zones.parent_zone_id, zones.action, zones.pool_id, zones.reverse_name, zones.delayed_notify, zones.increment_serial, CASE WHEN (shared_zones.target_project_id IS NULL) THEN False ELSE True END AS shared \nFROM zones LEFT OUTER JOIN shared_zones ON zones.id = shared_zones.zone_id \nWHERE zones.id < %(id_1)s AND zones.deleted = %(deleted_1)s \n LIMIT %(param_1)s]\n'].
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher Traceback (most recent call last):
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return callback(message["ctxt"],
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher handler.process_notification(context, event_type, payload)
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/notification_handler/nova.py", line 58, in process_notification
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher self._create(addresses=payload['fixed_ips'],
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/notification_handler/base.py", line 114, in _create
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher zone = self.get_zone(zone_id)
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/notification_handler/base.py", line 62, in get_zone
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return self.central_api.get_zone(context, zone_id)
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/central/rpcapi.py", line 153, in get_zone
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return self.client.call(context, 'get_zone', zone_id=zone_id)
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return self.prepare().call(ctxt, method, **kwargs)
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher result = self.transport._send(
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return self._driver.send(target, ctxt, message,
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher return self._send(target, ctxt, message, wait_for_reply, timeout,
2023-08-06 21:28:53.325 16 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 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher raise result
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher oslo_messaging.rpc.client.RemoteError: Remote error: DBError (builtins.ValueError) badly formed hexadecimal UUID string
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher [SQL: SELECT DISTINCT zones.id, zones.version, zones.created_at, zones.updated_at, zones.deleted, zones.deleted_at, zones.shard, zones.tenant_id, zones.name, zones.email, zones.description, zones.type, zones.transferred_at, zones.ttl, zones.serial, zones.refresh, zones.retry, zones.expire, zones.minimum, zones.status, zones.parent_zone_id, zones.action, zones.pool_id, zones.reverse_name, zones.delayed_notify, zones.increment_serial, CASE WHEN (shared_zones.target_project_id IS NULL) THEN False ELSE True END AS shared
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher FROM zones LEFT OUTER JOIN shared_zones ON zones.id = shared_zones.zone_id
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher WHERE zones.id < %(id_1)s AND zones.deleted = %(deleted_1)s
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher LIMIT %(param_1)s]
2023-08-06 21:28:53.325 16 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 865, in get_zone\n zone = self.storage.get_zone(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 447, in get_zone\n zone = self._find_zones(context, {\'id\': zone_id}, one=True,\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/__init__.py", line 374, in _find_zones\n zones = self._find(\n', ' File "/var/lib/kolla/venv/lib/python3.10/site-packages/designate/storage/sqlalchemy/base.py", line 276, in _find\n resultproxy = session.execute(query.limit(2))\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 DISTINCT zones.id, zones.version, zones.created_at, zones.updated_at, zones.deleted, zones.deleted_at, zones.shard, zones.tenant_id, zones.name, zones.email, zones.description, zones.type, zones.transferred_at, zones.ttl, zones.serial, zones.refresh, zones.retry, zones.expire, zones.minimum, zones.status, zones.parent_zone_id, zones.action, zones.pool_id, zones.reverse_name, zones.delayed_notify, zones.increment_serial, CASE WHEN (shared_zones.target_project_id IS NULL) THEN False ELSE True END AS shared \nFROM zones LEFT OUTER JOIN shared_zones ON zones.id = shared_zones.zone_id \nWHERE zones.id < %(id_1)s AND zones.deleted = %(deleted_1)s \n LIMIT %(param_1)s]\n'].
2023-08-06 21:28:53.325 16 ERROR oslo_messaging.notify.dispatcher `
