Hello, I'm having some difficulties with creating a port pair in the networking-sfc project. See below log file. Any help would be greatly appreciated. Thanks!
neutron-server.log 2018-07-13 23:13:26.965 3361 INFO neutron.wsgi [req-1e70ad3f-6bd7-4291-bb06-d5671cae4ef2 c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] 192.168.14.112 "GET /v2.0/ports?id=9a1a302e-c862-4683-80d0-e91d08b063d8 HTTP/1.1" status: 200 len: 1136 time: 0.6060951 2018-07-13 23:13:27.019 3361 INFO neutron.wsgi [req-367bbef4-9644-4c49-a050-b0f2fd2de2e6 c51f741dd6c34637a8b66bade75ed570 3a1091e3257a42398eda7b366cec3e7a - default default] 192.168.14.112 "GET /v2.0/ports?id=0fe15cd5-9a92-4d11-bf4e-206cf4b8deb5 HTTP/1.1" status: 200 len: 1132 time: 0.0466549 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
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack