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'] [parameters: [{}]] 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server Traceback (most recent call last): 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/oslo_messaging/rpc/server.py", line 166, in _process_incoming 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server res = self.dispatcher.dispatch(message) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/rpc.py", line 167, in dispatch 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server return super(RPCDispatcher, self).dispatch(*args, **kwds) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 265, in dispatch 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server return self._do_dispatch(endpoint, method, ctxt, args) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 194, in _do_dispatch 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server result = func(ctxt, **new_args) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/central/service.py", line 955, in get_zone 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server zone = self.storage.get_zone(context, zone_id) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py", line 289, in get_zone 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server zone = self._find_zones(context, {'id': zone_id}, one=True) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/storage/impl_sqlalchemy/__init__.py", line 234, in _find_zones 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server sort_key, sort_dir) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/designate/sqlalchemy/base.py", line 243, in _find 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server resultproxy = self.session.execute(query.limit(2)) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1176, in execute 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server bind, close_with_result=True).execute(clause, params or {}) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server return meth(self, multiparams, params) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server return connection._execute_clauseelement(self, multiparams, params) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server compiled_sql, distilled_params 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1132, in _execute_context 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server None, None) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server util.raise_from_cause(newraise, exc_info) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server reraise(type(exception), exception, tb=exc_tb, cause=cause) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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.623 21 ERROR oslo_messaging.rpc.server context = constructor(dialect, self, conn, *args) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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.623 21 ERROR oslo_messaging.rpc.server for key in compiled_params 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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.623 21 ERROR oslo_messaging.rpc.server for key in compiled_params 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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.623 21 ERROR oslo_messaging.rpc.server return process_param(value, dialect) 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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.623 21 ERROR oslo_messaging.rpc.server return "%.32x" % uuid.UUID(value).int 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server File "/usr/lib/python2.7/uuid.py", line 136, in __init__ 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server raise ValueError('badly formed hexadecimal UUID string') 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server 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'] [parameters: [{}]] 2018-11-22 22:35:17.623 21 ERROR oslo_messaging.rpc.server
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 <== sqlalchemy. exc_filters [req-16681927- 0d74-4f0d- b60a-d72f0ed2f2 68 - - - - -] DB exception wrapped.: ValueError: badly formed hexadecimal UUID string sqlalchemy. exc_filters Traceback (most recent call last): sqlalchemy. exc_filters File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 1127, in _execute_context sqlalchemy. exc_filters context = constructor( dialect, self, conn, *args) sqlalchemy. exc_filters File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ default. py", line 695, in _init_compiled sqlalchemy. exc_filters for key in compiled_params sqlalchemy. exc_filters File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ default. py", line 695, in <genexpr> sqlalchemy. exc_filters for key in compiled_params sqlalchemy. exc_filters File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ sql/type_ api.py" , line 1182, in process sqlalchemy. exc_filters return process_ param(value, dialect) sqlalchemy. exc_filters File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ sqlalchemy/ types.py" , line 45, in process_bind_param sqlalchemy. exc_filters return "%.32x" % uuid.UUID( value). int sqlalchemy. exc_filters File "/usr/lib/ python2. 7/uuid. py", line 136, in __init__ sqlalchemy. exc_filters raise ValueError('badly formed hexadecimal UUID string') sqlalchemy. exc_filters ValueError: badly formed hexadecimal UUID string sqlalchemy. exc_filters rpc.server [req-16681927- 0d74-4f0d- b60a-d72f0ed2f2 68 - - - - -] 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.transferr ed_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'] [parameters: [{}]] rpc.server Traceback (most recent call last): rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ oslo_messaging/ rpc/server. py", line 166, in _process_incoming rpc.server res = self.dispatcher .dispatch( message) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ rpc.py" , line 167, in dispatch rpc.server return super(RPCDispat cher, self).dispatch( *args, **kwds) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ oslo_messaging/ rpc/dispatcher. py", line 265, in dispatch rpc.server return self._do_ dispatch( endpoint, method, ctxt, args) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ oslo_messaging/ rpc/dispatcher. py", line 194, in _do_dispatch rpc.server result = func(ctxt, **new_args) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ central/ service. py", line 955, in get_zone rpc.server zone = self.storage. get_zone( context, zone_id) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ storage/ impl_sqlalchemy /__init_ _.py", line 289, in get_zone rpc.server zone = self._find_ zones(context, {'id': zone_id}, one=True) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ storage/ impl_sqlalchemy /__init_ _.py", line 234, in _find_zones rpc.server sort_key, sort_dir) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ sqlalchemy/ base.py" , line 243, in _find rpc.server resultproxy = self.session. execute( query.limit( 2)) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ orm/session. py", line 1176, in execute rpc.server bind, close_with_ result= True).execute( clause, params or {}) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 948, in execute rpc.server return meth(self, multiparams, params) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ sql/elements. py", line 269, in _execute_ on_connection rpc.server return connection. _execute_ clauseelement( self, multiparams, params) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 1060, in _execute_ clauseelement rpc.server compiled_sql, distilled_params rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 1132, in _execute_context rpc.server None, None) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 1409, in _handle_ dbapi_exception rpc.server util.raise_ from_cause( newraise, exc_info) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ util/compat. py", line 265, in raise_from_cause rpc.server reraise( type(exception) , exception, tb=exc_tb, cause=cause) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ base.py" , line 1127, in _execute_context rpc.server context = constructor( dialect, self, conn, *args) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ default. py", line 695, in _init_compiled rpc.server for key in compiled_params rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ engine/ default. py", line 695, in <genexpr> rpc.server for key in compiled_params rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ sqlalchemy/ sql/type_ api.py" , line 1182, in process rpc.server return process_ param(value, dialect) rpc.server File "/var/lib/ kolla/venv/ local/lib/ python2. 7/site- packages/ designate/ sqlalchemy/ types.py" , line 45, in process_bind_param rpc.server return "%.32x" % uuid.UUID( value). int rpc.server File "/usr/lib/ python2. 7/uuid. py", line 136, in __init__ rpc.server raise ValueError('badly formed hexadecimal UUID string') rpc.server 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.transferr ed_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'] [parameters: [{}]] rpc.server
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.621 21 ERROR oslo_db.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.
2018-11-22 22:35:17.623 21 ERROR oslo_messaging.