git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Openstack] [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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20180713/c996a029/attachment.html>



( ! ) Warning: include(msgfooter.php): failed to open stream: No such file or directory in /var/www/git/openstack/msg39931.html on line 679
Call Stack
#TimeMemoryFunctionLocation
10.0012397304{main}( ).../msg39931.html:0

( ! ) Warning: include(): Failed opening 'msgfooter.php' for inclusion (include_path='.:/var/www/git') in /var/www/git/openstack/msg39931.html on line 679
Call Stack
#TimeMemoryFunctionLocation
10.0012397304{main}( ).../msg39931.html:0