PortBindingFailed: Binding failed for port xxxxxx，MaxRetriesExceeded: Exceeded maximum number of xxx

PortBindingFailed: Binding failed for port 3657e894-6aeb-4109-9e08-dba69f48802b, please check neutron logs for more information.

MaxRetriesExceeded: Exceeded maximum number of retries. Exhausted all hosts available for retrying build failures for instance 81ae1fed-d4b9-4fdf-ad1d-8efdafd6ee6e.

Exceeded maximum number of retries. Exhausted all hosts available for retrying build failures for instance 3b93faab-ac6d-471b-9b23-b6c8d2d86a14.

出现错误类似如下：

2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource [req-17112a6a-686d-49e5-a7ce-cf18ad120c7e 47492db609a74516a782288c57725ee0 975210ba4dcc443fa168f4d794d91186 - default default] create failed: No details.: DBReferenceError: (pymysql.err.IntegrityError) (1452, u’Cannot add or update a child row: a foreign key constraint fails (neutron.floatingips, CONSTRAINT floatingips_ibfk_1 FOREIGN KEY (fixed_port_id) REFERENCES ports (id))‘) [SQL: u’INSERT INTO floatingips (project_id, id, floating_ip_address, floating_network_id, floating_port_id, fixed_port_id, fixed_ip_address, router_id, last_known_router_id, status, standard_attr_id) VALUES (%(project_id)s, %(id)s, %(floating_ip_address)s, %(floating_network_id)s, %(floating_port_id)s, %(fixed_port_id)s, %(fixed_ip_address)s, %(router_id)s, %(last_known_router_id)s, %(status)s, %(standard_attr_id)s)’] [parameters: {‘status’: u’DOWN’, ‘router_id’: ‘550b0d8d-5d98-45e7-9ada-8d6441cf4f74’, ‘last_known_router_id’: None, ‘floating_port_id’: ‘d93530fe-e071-4142-8aa8-7d1ce3d18a63’, ‘fixed_port_id’: ‘3a6e2633-d85f-4e9b-a5c8-67cb022f0eaa’, ‘floating_network_id’: ‘ca6ad0e0-5448-49ac-8663-92e783e48e3a’, ‘fixed_ip_address’: ‘172.21.1.157’, ‘floating_ip_address’: ‘172.20.0.104’, ‘standard_attr_id’: 272, ‘project_id’: u’975210ba4dcc443fa168f4d794d91186’, ‘id’: ‘466a594b-af51-429e-a0cf-5e6a16ac5a97’}] (Background on this error at: http://sqlalche.me/e/gkpj)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource Traceback (most recent call last):
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py”, line 98, in resource
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource result = method(request=request, **args)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/api/v2/base.py”, line 437, in create
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return self.create(request, body, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 139, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource setattr(e, 'RETRY_EXCEEDED’, True)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 135, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_db/api.py”, line 154, in wrapper
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_db/api.py”, line 142, in wrapper
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 183, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource LOG.debug(“Retry wrapper got retriable exception: %s”, e)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 179, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*dup_args, **dup_kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/api/v2/base.py”, line 556, in create
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource obj = do_create(body)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/api/v2/base.py”, line 538, in do_create
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource request.context, reservation.reservation_id)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/api/v2/base.py”, line 531, in do_create
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return obj_creator(request.context, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/services/l3_router/l3_router_plugin.py”, line 185, in create_floatingip
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource initial_status=n_const.FLOATINGIP_STATUS_DOWN)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 233, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return method(*args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 139, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource setattr(e, ‘RETRY_EXCEEDED’, True)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 135, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_db/api.py”, line 154, in wrapper
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_db/api.py”, line 142, in wrapper
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 183, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource LOG.debug(“Retry wrapper got retriable exception: %s”, e)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 220, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.force_reraise()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/oslo_utils/excutils.py”, line 196, in force_reraise
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 179, in wrapped
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return f(*dup_args, **dup_kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/db/l3_dvr_db.py”, line 1216, in create_floatingip
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource context, floatingip, initial_status)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/db/l3_db.py”, line 1345, in _create_floatingip
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource floatingip_obj.create()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/objects/base.py”, line 337, in decorator
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return func(self, *args, **kwargs)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/objects/base.py”, line 867, in create
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self, self.obj_context, self.modify_fields_to_db(fields))
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron/objects/db/api.py”, line 69, in create_object
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource context.session.add(db_obj)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/contextlib.py”, line 24, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.gen.next()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 199, in autonested_transaction
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource yield tx
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 597, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.rollback()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py”, line 67, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 594, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.commit()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 487, in commit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self._prepare_impl()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 455, in _prepare_impl
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self.session.dispatch.before_commit(self.session)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/event/attr.py”, line 259, in call
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource fn(*args, **kw)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/neutron_lib/db/api.py”, line 316, in _load_one_to_manys
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource session.flush()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 2436, in flush
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self._flush(objects)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 2574, in _flush
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource transaction.rollback(_capture_exception=True)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py”, line 67, in exit
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py”, line 2534, in _flush
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource flush_context.execute()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py”, line 416, in execute
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource rec.execute(self)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py”, line 583, in execute
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource uow,
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py”, line 245, in save_obj
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource insert,
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py”, line 1063, in _emit_insert_statements
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource c = cached_connections[connection].execute(statement, multiparams)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 980, in execute
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return meth(self, multiparams, params)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py”, line 273, in _execute_on_connection
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1099, in _execute_clauseelement
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource distilled_params,
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1240, in _execute_context
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource e, statement, parameters, cursor, context
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1456, in _handle_dbapi_exception
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource util.raise_from_cause(newraise, exc_info)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py”, line 296, in raise_from_cause
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb, cause=cause)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py”, line 1236, in _execute_context
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource cursor, statement, parameters, context
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py”, line 536, in do_execute
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource cursor.execute(statement, parameters)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/cursors.py”, line 170, in execute
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource result = self._query(query)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/cursors.py”, line 328, in _query
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource conn.query(q)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 517, in query
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 732, in _read_query_result
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource result.read()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 1075, in read
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource first_packet = self.connection._read_packet()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/connections.py”, line 684, in _read_packet
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource packet.check_error()
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/protocol.py”, line 220, in check_error
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource err.raise_mysql_exception(self._data)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource File “/usr/lib/python2.7/site-packages/pymysql/err.py”, line 109, in raise_mysql_exception
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource raise errorclass(errno, errval)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource DBReferenceError: (pymysql.err.IntegrityError) (1452, u’Cannot add or update a child row: a foreign key constraint fails (neutron.floatingips, CONSTRAINT floatingips_ibfk_1 FOREIGN KEY (fixed_port_id) REFERENCES ports (id))’) [SQL: u’INSERT INTO floatingips (project_id, id, floating_ip_address, floating_network_id, floating_port_id, fixed_port_id, fixed_ip_address, router_id, last_known_router_id, status, standard_attr_id) VALUES (%(project_id)s, %(id)s, %(floating_ip_address)s, %(floating_network_id)s, %(floating_port_id)s, %(fixed_port_id)s, %(fixed_ip_address)s, %(router_id)s, %(last_known_router_id)s, %(status)s, %(standard_attr_id)s)‘] [parameters: {‘status’: u’DOWN’, ‘router_id’: ‘550b0d8d-5d98-45e7-9ada-8d6441cf4f74’, ‘last_known_router_id’: None, ‘floating_port_id’: ‘d93530fe-e071-4142-8aa8-7d1ce3d18a63’, ‘fixed_port_id’: ‘3a6e2633-d85f-4e9b-a5c8-67cb022f0eaa’, ‘floating_network_id’: ‘ca6ad0e0-5448-49ac-8663-92e783e48e3a’, ‘fixed_ip_address’: ‘172.21.1.157’, ‘floating_ip_address’: ‘172.20.0.104’, ‘standard_attr_id’: 272, ‘project_id’: u’975210ba4dcc443fa168f4d794d91186’, ‘id’: ‘466a594b-af51-429e-a0cf-5e6a16ac5a97’}] (Background on this error at: http://sqlalche.me/e/gkpj)
2023-05-29 14:54:35.282 230085 ERROR neutron.api.v2.resource

---

解决方案：

1、暴力方法：

登录openstack的mysql数据库；
删除neutron数据库；
使用packstack快速重装neutron组件；
对neutron网络进行配置，包括plugins下面的文件和dashboard上面管理网络管理；
创建虚拟机关联网络进行测试；

2、分析法，保留数据
查看neutron版本是否兼容，主要通过rpm查看安装的neutron版本；
进行版本降级或者升级，通过migrant进行合并；
查看neutron的vlan配置是否正确，主要是物理网卡的对应、plugins下面的映射名称、交换机上创建vlan范围的对应、网络类型以及子网的配置；
修改对应的错误，并重启所有neutron相关的组件；
重新创建虚拟机关联网络进行测试。