Mailing List Archive

[networking-sfc] Create port pair post commit fails - sql null host_id cannot be null
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