gistfile1.txt

2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers [req-70ca43dc-aedc-4728-bbc4-35dd92b24489 2bf652a959b34bd8bace4c2569c53751 506512685fc842c5b189e9c6226a7e16 - default default] Mechanism driver 'opendaylight_v2' failed in delete_network_precommit: DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron`.`opendaylight_journal_deps`, CONSTRAINT `opendaylight_journal_deps_ibfk_1` FOREIGN KEY (`depends_on`) REFERENCES `opendaylightjournal` (`seqnum`) ON DELETE CASCADE)') [SQL: u'INSERT INTO opendaylight_journal_deps (depends_on, dependent) VALUES (%(depends_on)s, %(dependent)s)'] [parameters: {'dependent': 1761, 'depends_on': 1731}]
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers Traceback (most recent call last):
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/managers.py", line 426, in _call_on_drivers
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     getattr(driver.obj, method_name)(context)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/oslo_log/helpers.py", line 67, in wrapper
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     return method(*args, **kwargs)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/networking_odl/ml2/mech_driver_v2.py", line 144, in delete_network_precommit
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     context, odl_const.ODL_NETWORK, odl_const.ODL_DELETE, data=[])
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/networking_odl/ml2/mech_driver_v2.py", line 109, in _record_in_journal
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     ml2_context=context)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/networking_odl/journal/journal.py", line 97, in record
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     operation, data, depending_on=depending_on)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 150, in wrapper
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     ectxt.value = e.inner_exc
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     self.force_reraise()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     six.reraise(self.type_, self.value, self.tb)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     return f(*args, **kwargs)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/networking_odl/db/db.py", line 146, in create_pending_row
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     session.flush()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     self._flush(objects)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     transaction.rollback(_capture_exception=True)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     flush_context.execute()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     rec.execute(self)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 503, in execute
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     self.dependency_processor.process_saves(uow, states)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/dependency.py", line 1092, in process_saves
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     secondary_update, secondary_delete)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/dependency.py", line 1136, in _run_crud
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     connection.execute(statement, secondary_insert)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     return meth(self, multiparams, params)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     return connection._execute_clauseelement(self, multiparams, params)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     compiled_sql, distilled_params
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     context)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398, in _handle_dbapi_exception
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     util.raise_from_cause(newraise, exc_info)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     context)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     cursor.execute(statement, parameters)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     result = self._query(query)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     conn.query(q)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     result.read()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     first_packet = self.connection._read_packet()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     packet.check_error()
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     err.raise_mysql_exception(self._data)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers     raise errorclass(errno, errval)
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`ovs_neutron`.`opendaylight_journal_deps`, CONSTRAINT `opendaylight_journal_deps_ibfk_1` FOREIGN KEY (`depends_on`) REFERENCES `opendaylightjournal` (`seqnum`) ON DELETE CASCADE)') [SQL: u'INSERT INTO opendaylight_journal_deps (depends_on, dependent) VALUES (%(depends_on)s, %(dependent)s)'] [parameters: {'dependent': 1761, 'depends_on': 1731}]
2017-09-14 06:45:39.910 202364 ERROR neutron.plugins.ml2.managers