Creating port pair fails because host_id cannot be null in database. I verified the neutron ports were active when trying. I am using the stable/queens release. I deployed using kolla-ansible.
2018-07-13 23:13:27.483 3361 WARNING networking_sfc.services.sfc.drivers.ovs.driver [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] Currently only support vxlan network
2018-07-13 23:13:27.582 3361 WARNING networking_sfc.services.sfc.drivers.ovs.driver [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] Currently only support vxlan network
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] DBAPIError exception wrapped from (pymysql.err.IntegrityError) (1048, u"Column 'host_id' cannot be null") [SQL: u'INSERT INTO sfc_portpair_details (project_id, id, ingress, egress, host_id, in_mac_address, mac_address, network_type, segment_id, local_endpoint, correlation) VALUES (%(project_id)s, %(id)s, %(ingress)s, %(egress)s, %(host_id)s, %(in_mac_address)s, %(mac_address)s, %(network_type)s, %(segment_id)s, %(local_endpoint)s, %(correlation)s)'] [parameters: {'ingress': u'9a1a302e-c862-4683-80d0-e91d08b063d8', 'segment_id': None, 'correlation': None, 'id': '7e6ad744-fd8d-4a58-9606-cfe8d00587c1', 'local_endpoint': None, 'in_mac_address': None, 'egress': u'0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5', 'mac_address': None, 'host_id': None, 'project_id': u'3a1091e3257a42398eda7b366cec3e7a', 'network_type': None}]: IntegrityError: (1048, u"Column 'host_id' cannot be null")
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters context)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 470, in do_execute
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 856, in query
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1057, in _read_query_result
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1340, in read
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1014, in _read_packet
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters IntegrityError: (1048, u"Column 'host_id' cannot be null")
2018-07-13 23:13:27.585 3361 ERROR oslo_db.sqlalchemy.exc_filters
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] (pymysql.err.IntegrityError) (1048, u"Column 'host_id' cannot be null") [SQL: u'INSERT INTO sfc_portpair_details (project_id, id, ingress, egress, host_id, in_mac_address, mac_address, network_type, segment_id, local_endpoint, correlation) VALUES (%(project_id)s, %(id)s, %(ingress)s, %(egress)s, %(host_id)s, %(in_mac_address)s, %(mac_address)s, %(network_type)s, %(segment_id)s, %(local_endpoint)s, %(correlation)s)'] [parameters: {'ingress': u'9a1a302e-c862-4683-80d0-e91d08b063d8', 'segment_id': None, 'correlation': None, 'id': '7e6ad744-fd8d-4a58-9606-cfe8d00587c1', 'local_endpoint': None, 'in_mac_address': None, 'egress': u'0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5', 'mac_address': None, 'host_id': None, 'project_id': u'3a1091e3257a42398eda7b366cec3e7a', 'network_type': None}]: DBError: (pymysql.err.IntegrityError) (1048, u"Column 'host_id' cannot be null") [SQL: u'INSERT INTO sfc_portpair_details (project_id, id, ingress, egress, host_id, in_mac_address, mac_address, network_type, segment_id, local_endpoint, correlation) VALUES (%(project_id)s, %(id)s, %(ingress)s, %(egress)s, %(host_id)s, %(in_mac_address)s, %(mac_address)s, %(network_type)s, %(segment_id)s, %(local_endpoint)s, %(correlation)s)'] [parameters: {'ingress': u'9a1a302e-c862-4683-80d0-e91d08b063d8', 'segment_id': None, 'correlation': None, 'id': '7e6ad744-fd8d-4a58-9606-cfe8d00587c1', 'local_endpoint': None, 'in_mac_address': None, 'egress': u'0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5', 'mac_address': None, 'host_id': None, 'project_id': u'3a1091e3257a42398eda7b366cec3e7a', 'network_type': None}]
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager Traceback (most recent call last):
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/driver_manager.py", line 100, in _call_drivers
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager getattr(driver.obj, method_name)(context)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/drivers/base.py", line 79, in create_port_pair_postcommit
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.create_port_pair(context)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_log/helpers.py", line 67, in wrapper
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager return method(*args, **kwargs)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/drivers/ovs/driver.py", line 1168, in create_port_pair
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self._create_port_pair_detail(port_pair)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_log/helpers.py", line 67, in wrapper
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager return method(*args, **kwargs)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/drivers/ovs/driver.py", line 1161, in _create_port_pair_detail
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager r = self.create_port_pair_detail(portpair_detail)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/drivers/ovs/db.py", line 244, in create_port_pair_detail
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager return self._make_port_detail_dict(port_obj)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.gen.next()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1029, in _transaction_scope
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager yield resource
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/contextlib.py", line 24, in __exit__
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.gen.next()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 641, in _session
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.session.rollback()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.force_reraise()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 638, in _session
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self._end_session_transaction(self.session)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 666, in _end_session_transaction
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager session.commit()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 921, in commit
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.transaction.commit()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 461, in commit
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self._prepare_impl()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 430, in _prepare_impl
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self.session.dispatch.before_commit(self.session)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/event/attr.py", line 218, in __call__
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager fn(*args, **kw)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 267, in load_one_to_manys
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager session.flush()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2192, in flush
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self._flush(objects)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2312, in _flush
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager transaction.rollback(_capture_exception=True)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager compat.reraise(exc_type, exc_value, exc_tb)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2276, in _flush
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager flush_context.execute()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager rec.execute(self)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager uow
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager mapper, table, insert)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 799, in _emit_insert_statements
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager execute(statement, multiparams)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 945, in execute
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager return meth(self, multiparams, params)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager return connection._execute_clauseelement(self, multiparams, params)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager compiled_sql, distilled_params
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager context)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager util.raise_from_cause(newraise, exc_info)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager reraise(type(exception), exception, tb=exc_tb, cause=cause)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager context)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 470, in do_execute
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager cursor.execute(statement, parameters)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager result = self._query(query)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager conn.query(q)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 856, in query
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1057, in _read_query_result
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager result.read()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1340, in read
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager first_packet = self.connection._read_packet()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1014, in _read_packet
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager packet.check_error()
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager err.raise_mysql_exception(self._data)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager raise errorclass(errno, errval)
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager DBError: (pymysql.err.IntegrityError) (1048, u"Column 'host_id' cannot be null") [SQL: u'INSERT INTO sfc_portpair_details (project_id, id, ingress, egress, host_id, in_mac_address, mac_address, network_type, segment_id, local_endpoint, correlation) VALUES (%(project_id)s, %(id)s, %(ingress)s, %(egress)s, %(host_id)s, %(in_mac_address)s, %(mac_address)s, %(network_type)s, %(segment_id)s, %(local_endpoint)s, %(correlation)s)'] [parameters: {'ingress': u'9a1a302e-c862-4683-80d0-e91d08b063d8', 'segment_id': None, 'correlation': None, 'id': '7e6ad744-fd8d-4a58-9606-cfe8d00587c1', 'local_endpoint': None, 'in_mac_address': None, 'egress': u'0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5', 'mac_address': None, 'host_id': None, 'project_id': u'3a1091e3257a42398eda7b366cec3e7a', 'network_type': None}]
2018-07-13 23:13:27.599 3361 ERROR networking_sfc.services.sfc.driver_manager
2018-07-13 23:13:27.603 3361 ERROR networking_sfc.services.sfc.driver_manager [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] SFC driver 'ovs' failed in create_port_pair_postcommit: DBError: (pymysql.err.IntegrityError) (1048, u"Column 'host_id' cannot be null") [SQL: u'INSERT INTO sfc_portpair_details (project_id, id, ingress, egress, host_id, in_mac_address, mac_address, network_type, segment_id, local_endpoint, correlation) VALUES (%(project_id)s, %(id)s, %(ingress)s, %(egress)s, %(host_id)s, %(in_mac_address)s, %(mac_address)s, %(network_type)s, %(segment_id)s, %(local_endpoint)s, %(correlation)s)'] [parameters: {'ingress': u'9a1a302e-c862-4683-80d0-e91d08b063d8', 'segment_id': None, 'correlation': None, 'id': '7e6ad744-fd8d-4a58-9606-cfe8d00587c1', 'local_endpoint': None, 'in_mac_address': None, 'egress': u'0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5', 'mac_address': None, 'host_id': None, 'project_id': u'3a1091e3257a42398eda7b366cec3e7a', 'network_type': None}]
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] create_port_pair_postcommit failed.: SfcDriverError: create_port_pair_postcommit failed.
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin Traceback (most recent call last):
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/plugin.py", line 118, in create_port_pair
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin self.driver_manager.create_port_pair_postcommit(portpair_context)
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/driver_manager.py", line 141, in create_port_pair_postcommit
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin self._call_drivers("create_port_pair_postcommit", context)
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/driver_manager.py", line 112, in _call_drivers
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin method=method_name
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin SfcDriverError: create_port_pair_postcommit failed.
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin
2018-07-13 23:13:27.604 3361 ERROR networking_sfc.services.sfc.plugin [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] Create port pair failed, deleting port_pair '4392a1c0-5e36-4c2f-a477-03767e8140dd': SfcDriverError: create_port_pair_postcommit failed.
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource [req-e059eb52-c097-4e8f-8444-c3d1d280e47c c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] create failed: No details.: SfcDriverError: create_port_pair_postcommit failed.
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource Traceback (most recent call last):
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 98, in resource
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource result = method(request=request, **args)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 435, in create
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return self._create(request, body, **kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 93, in wrapped
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource setattr(e, '_RETRY_EXCEEDED', True)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.force_reraise()
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 89, in wrapped
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_db/api.py", line 150, in wrapper
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.force_reraise()
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_db/api.py", line 138, in wrapper
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 128, in wrapped
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource LOG.debug("Retry wrapper got retriable exception: %s", e)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.force_reraise()
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 124, in wrapped
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return f(*dup_args, **dup_kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 548, in _create
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource obj = do_create(body)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 530, in do_create
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource request.context, reservation.reservation_id)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.force_reraise()
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 523, in do_create
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return obj_creator(request.context, **kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_log/helpers.py", line 67, in wrapper
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource return method(*args, **kwargs)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/plugin.py", line 125, in create_port_pair
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.delete_port_pair(context, portpair_db['id'])
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.force_reraise()
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/plugin.py", line 118, in create_port_pair
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self.driver_manager.create_port_pair_postcommit(portpair_context)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/driver_manager.py", line 141, in create_port_pair_postcommit
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource self._call_drivers("create_port_pair_postcommit", context)
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/networking_sfc/services/sfc/driver_manager.py", line 112, in _call_drivers
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource method=method_name
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource SfcDriverError: create_port_pair_postcommit failed.
2018-07-13 23:13:27.747 3361 ERROR neutron.api.v2.resource
I run into the same error with an RDO install. Does a workaround exist?