Designate central complains ValueError: badly formed hexadecimal UUID string

[James McCarthy]

I'm not sure how to best describe the issue - there seems to be some issue wrt uuid formatting, a zone is created like so:

$ openstack zone create --email <email address hidden> sample.openstack.org.
+----------------+--------------------------------------+
| Field | Value |
+----------------+--------------------------------------+
| action | CREATE |
| attributes | |
| created_at | 2017-08-11T07:52:08.000000 |
| description | None |
| email | <email address hidden> |
| id | e30bc143-ab2d-4c18-a157-c71fed3e984e |
| masters | |
| name | sample.openstack.org. |
| pool_id | faad484c-c9d6-4941-a78a-19c613d1af25 |
| project_id | 7f492117e9534c87841c74417a1929eb |
| serial | 1502437927 |
| status | PENDING |
| transferred_at | None |
| ttl | 3600 |
| type | PRIMARY |
| updated_at | None |
| version | 1 |
+----------------+--------------------------------------+
$

A network is updated with the above zone:
$ openstack network list
+--------------------------------------+-----------+--------------------------------------+
| ID | Name | Subnets |
+--------------------------------------+-----------+--------------------------------------+
| 1a4d4f6a-c564-4db6-bc0e-64b11a06127a | demo-net | 086aeaa5-a0bc-4ee2-8d81-d0ae6a207fb4 |
| 7b311a85-0b09-4c97-92dc-7eec66b53f8f | public1 | de69e944-cd7e-4739-8079-5aa804ff4fd8 |
+--------------------------------------+-----------+--------------------------------------+
$

$ neutron net-update 1a4d4f6a-c564-4db6-bc0e-64b11a06127a --dns_domain sample.openstack.org.
neutron CLI is deprecated and will be removed in the future. Use openstack CLI instead.
Updated network: 1a4d4f6a-c564-4db6-bc0e-64b11a06127a
$

$ neutron net-show 1a4d4f6a-c564-4db6-bc0e-64b11a06127a
neutron CLI is deprecated and will be removed in the future. Use openstack CLI instead.
+---------------------------+--------------------------------------+
| Field | Value |
+---------------------------+--------------------------------------+
| admin_state_up | True |
| availability_zone_hints | |
| availability_zones | nova |
| created_at | 2017-08-10T17:09:30Z |
| description | |
| dns_domain | sample.openstack.org. |
| id | 1a4d4f6a-c564-4db6-bc0e-64b11a06127a |
| ipv4_address_scope | |
| ipv6_address_scope | |
| mtu | 1450 |
| name | demo-net1 |
| port_security_enabled | True |
| project_id | 7f492117e9534c87841c74417a1929eb |
| provider:network_type | vxlan |
| provider:physical_network | |
| provider:segmentation_id | 169 |
| revision_number | 3 |
| router:external | False |
| shared | False |
| status | ACTIVE |
| subnets | 086aeaa5-a0bc-4ee2-8d81-d0ae6a207fb4 |
| tags | |
| tenant_id | 7f492117e9534c87841c74417a1929eb |
| updated_at | 2017-08-11T08:10:45Z |
+---------------------------+--------------------------------------+
$

The zone list seems to show the correct id:
$ openstack zone list
+--------------------------------------+-----------------------+---------+------------+--------+--------+
| id | name | type | serial | status | action |
+--------------------------------------+-----------------------+---------+------------+--------+--------+
| e30bc143-ab2d-4c18-a157-c71fed3e984e | sample.openstack.org. | PRIMARY | 1502439493 | ERROR | UPDATE |
+--------------------------------------+-----------------------+---------+------------+--------+--------+
$

The record in the db looks like:
+----------------------------------+---------------------+---------------------+---------+----------------------------------------------------------------------------------+----------------------------------+---------+-----------------------+----------------------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+
| id | created_at | updated_at | version | data | zone_id | managed | managed_resource_type | managed_resource_id | managed_plugin_type | managed_plugin_name | hash | description | status | tenant_id | recordset_id | managed_tenant_id | managed_resource_region | managed_extra | action | serial | zone_shard |
+----------------------------------+---------------------+---------------------+---------+----------------------------------------------------------------------------------+----------------------------------+---------+-----------------------+----------------------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+
| c9848f7d282146cfb9ec655bafeabae6 | 2017-08-11 08:18:11 | 2017-08-11 08:20:47 | 2 | 10.20.0.8 | e30bc143ab2d4c18a157c71fed3e984e | 1 | instance | 10ef37ff678848a399e280ffdba84567 | handler | nova_fixed | 5838fb38ea34d3153ef8cb14e23d5b41 | NULL | ERROR | 7f492117e9534c87841c74417a1929eb | dedc2125eadc49eebe4d3504f3e9d8c9 | NULL | NULL | NULL | CREATE | 1502439491 | 3632 |
| dfd97e50943f45c49e71985eb55902d9 | 2017-08-11 07:52:08 | 2017-08-11 08:20:47 | 6 | sample.openstack.org. admin.sample.openstack.org. 1502439493 3503 600 86400 3600 | e30bc143ab2d4c18a157c71fed3e984e | 1 | NULL | NULL | NULL | NULL | 4a1397ffe98e0d9944319581e6ee1401 | NULL | ERROR | 7f492117e9534c87841c74417a1929eb | 97fdce87988d44f19b330a2f644e74ea | NULL | NULL | NULL | UPDATE | 1502439493 | 3632 |
| 25c8001eea234be89c6f993fc9dbc74c | 2017-08-11 07:52:08 | 2017-08-11 07:52:14 | 2 | sample.openstack.org. | e30bc143ab2d4c18a157c71fed3e984e | 1 | NULL | NULL | NULL | NULL | 8e4e0b8f15509c47b219da6ce4117946 | NULL | ACTIVE | 7f492117e9534c87841c74417a1929eb | c0f93fde4f6d44b9a48cffa2138f2da4 | NULL | NULL | NULL | NONE | 1502437927 | 3632 |
| 2610ffcbf42041adb575f519773a300c | 2017-08-11 08:18:12 | 2017-08-11 08:20:47 | 2 | 10.20.0.8 | e30bc143ab2d4c18a157c71fed3e984e | 1 | instance | 10ef37ff678848a399e280ffdba84567 | handler | nova_fixed | 0bc81142118b2fc9c6c3b1aa8424284e | NULL | ERROR | 7f492117e9534c87841c74417a1929eb | 4a2a1ecfe64044b997bf392603b7fea2 | NULL | NULL | NULL | CREATE | 1502439492 | 3632 |
| d10727f56f7c41e3ac8db134c186443d | 2017-08-11 08:18:12 | 2017-08-11 08:20:47 | 2 | 10.20.0.8 | e30bc143ab2d4c18a157c71fed3e984e | 1 | instance | 10ef37ff678848a399e280ffdba84567 | handler | nova_fixed | 9e53a8e587ce1e1d662274e8ea12bdf2 | NULL | ERROR | 7f492117e9534c87841c74417a1929eb | 0f8902dba5624cd6a400777da766f19d | NULL | NULL | NULL | CREATE | 1502439493 | 3632 |
+----------------------------------+---------------------+---------------------+---------+----------------------------------------------------------------------------------+----------------------------------+---------+-----------------------+----------------------------------+---------------------+---------------------+----------------------------------+-------------+--------+----------------------------------+----------------------------------+-------------------+-------------------------+---------------+--------+------------+------------+

However, there are complaints from designate central about 'ValueError: badly formed hexadecimal UUID string'

2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters [req-dc3c16cc-f3ef-4590-a146-57a23951f1fe - - - - -] DB exception wrapped.: ValueError: badly formed hexadecimal UUID string
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters context = constructor(dialect, self, conn, *args)
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 649, in _init_compiled
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters for key in compiled_params
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 649, in <genexpr>
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters for key in compiled_params
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py", line 1078, in process
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters return process_param(value, dialect)
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/sqlalchemy/types.py", line 45, in process_bind_param
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters return "%.32x" % uuid.UUID(value).int
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/uuid.py", line 134, in __init__
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters raise ValueError('badly formed hexadecimal UUID string')
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters ValueError: badly formed hexadecimal UUID string
2017-08-11 08:43:42.003 20 ERROR oslo_db.sqlalchemy.exc_filters
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server [req-dc3c16cc-f3ef-4590-a146-57a23951f1fe - - - - -] Exception during message handling: DBError: (exceptions.ValueError) badly formed hexadecimal UUID string [SQL: u'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.zone_id = %(zone_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_resource_id = %(managed_resource_id_1)s ORDER BY records.created_at ASC, records.id ASC'] [parameters: [{}]]
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server Traceback (most recent call last):
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 160, in _process_incoming
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server res = self.dispatcher.dispatch(message)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/rpc.py", line 167, in dispatch
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return super(RPCDispatcher, self).dispatch(*args, **kwds)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 213, in dispatch
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return self._do_dispatch(endpoint, method, ctxt, args)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 183, in _do_dispatch
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server result = func(ctxt, **new_args)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/central/service.py", line 1600, in find_records
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server sort_key, sort_dir)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py", line 837, in find_records
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server sort_dir=sort_dir)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py", line 806, in _find_records
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server sort_key, sort_dir)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/sqlalchemy/base.py", line 261, in _find
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server resultproxy = self.session.execute(query)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1139, in execute
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server bind, close_with_result=True).execute(clause, params or {})
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return meth(self, multiparams, params)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return connection._execute_clauseelement(self, multiparams, params)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server compiled_sql, distilled_params
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1121, in _execute_context
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server None, None)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server util.raise_from_cause(newraise, exc_info)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server context = constructor(dialect, self, conn, *args)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 649, in _init_compiled
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server for key in compiled_params
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py", line 1078, in process
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return process_param(value, dialect)
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/lib/python2.7/site-packages/designate/sqlalchemy/types.py", line 45, in process_bind_param
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server return "%.32x" % uuid.UUID(value).int
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server File "/usr/lib64/python2.7/uuid.py", line 134, in __init__
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server raise ValueError('badly formed hexadecimal UUID string')
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server DBError: (exceptions.ValueError) badly formed hexadecimal UUID string [SQL: u'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.zone_id = %(zone_id_1)s AND records.managed_resource_type = %(managed_resource_type_1)s AND records.managed_plugin_type = %(managed_plugin_type_1)s AND records.managed_plugin_name = %(managed_plugin_name_1)s AND records.managed_resource_id = %(managed_resource_id_1)s ORDER BY records.created_at ASC, records.id ASC'] [parameters: [{}]]
2017-08-11 08:43:42.012 20 ERROR oslo_messaging.rpc.server

[James McCarthy (jmccarthy)]

I have since reconfigured and redeployed designate without hitting the above errors.

It seems this issue is not to do with designate per se, but rather something in my environment
(I cannot quite say what at the moment, I don't yet know the root cause)

Marking this bug as invalid.

[Nguyen Van Trung (trungnv)]

By default, we will get random UUID [1] then write into DB. I believe zone_id is correct. Please re-install and try again.

[1] https://github.com/openstack/designate/blob/master/designate/storage/impl_sqlalchemy/tables.py#L105

[Gaëtan Trellu (goldyfruit)]

I got the same error as above.

I created a DNS zone, a Neutron network with a subnet and update the subnet with the DNS create previously.

The zone is ACTIVE but when I try to create an instance (so a Neutron port) I got this error in the log.

==> /var/lib/docker/volumes/kolla_logs/_data/designate/designate-central.log <==
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters [req-16681927-0d74-4f0d-b60a-d72f0ed2f268 - - - - -] DB exception wrapped.: ValueError: badly formed hexadecimal UUID string
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1127, in _execute_context
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters context = constructor(dialect, self, conn, *args)
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 695, in _init_compiled
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters for key in compiled_params
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 695, in <genexpr>
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters for key in compiled_params
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/type_api.py", line 1182, in process
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters return process_param(value, dialect)
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/sqlalchemy/types.py", line 45, in process_bind_param
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters return "%.32x" % uuid.UUID(value).int
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/uuid.py", line 136, in __init__
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters raise ValueError('badly formed hexadecimal UUID string')
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters ValueError: badly formed hexadecimal UUID string
2018-11-22 22:35:17.621 21 ERROR oslo_db.sqlalchemy.exc_filters
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server [req-16681927-0d74-4f0d-b60a-d72f0ed2f268 - - - - -] Exception during message handling: DBError: (exceptions.ValueError) badly formed hexadecimal UUID string [SQL: u'SELECT 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 \nFROM zones \nWHERE zones.id = %(id_1)s AND zones.deleted = %(deleted_1)s \n LIMIT %(param_1)s'] [pa...

[Weiguo Kuang (szkwg)]

After creating zone from openstack client, got the same exception when using the following cmd to create network:
openstack network create --share --dns-domain ${DOMAIN}. --provider-physical-network physnet1 --provider-network-type vlan --provider-segment $VLAN vl$VLAN

So retrieving zone id, reconfigure with config file like the following (as designate document):
(env) [root@deploy env]# cat /etc/kolla/config/designate.conf
[network_api:neutron]
insecure = true

[handler:nova_fixed]
zone_id = 264e67c2-ddaf-4581-80db-9d1daab8fe91
zone_id = a1ff8f97-80de-4d11-bf68-a868794f8d8c
[handler:neutron_floatingip]
zone_id = 264e67c2-ddaf-4581-80db-9d1daab8fe91
zone_id = a1ff8f97-80de-4d11-bf68-a868794f8d8c

RESULT: the exception is gone. But got exception "ERROR oslo_messaging.notify.dispatcher DuplicateRecord: Duplicate Record".

removing/recreating network as the following (without '--dns-domain'):
openstack network create --share --provider-physical-network physnet1 --provider-network-type vlan --provider-segment $VLAN vl$VLAN

RESULT: no error now

my environment is stable/rocky deployed with kolla-ansible. it seems like a thing between neutron cmd line and designate configuration.

[Boris Lukashev (rageltman)]

Just got this in Wallaby:
```
oslo_messaging.rpc.client.RemoteError: Remote error: DBError (builtins.ValueError) badly formed hexadecimal UUID string
```
on a zone which otherwise shows up correctly in the CLI and Horizon. Other zones work just fine, resolution and control plane; but this one specific pair of zones created in this one specific project both produce this issue and do not resolve.

[Bartosz Bezak (bbezak)]

This persists in Wallaby as well:

Callback raised an exception.: oslo_messaging.rpc.client.RemoteError: Remote error: DBError (builtins.ValueError) badly formed hexadecimal UUID string
[SQL: SELECT 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
FROM zones
WHERE zones.id = %(id_1)s AND zones.deleted = %(deleted_1)s
 LIMIT %(param_1)s]
[parameters: [{}]]

[Junbo Jiang (junbo)]

this bug https://bugs.launchpad.net/designate/+bug/1977826 could cause the same issue.

try check the designate-sink service.