yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1630257] [NEW] DBDeadlock occurs during test_dualnet_multi_prefix_dhcpv6_stateless

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Sergey Belous <sbelous@xxxxxxxxxxxx>
Date: Tue, 04 Oct 2016 14:17:22 -0000
Reply-to: Bug 1630257 <1630257@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

The test test_dualnet_multi_prefix_dhcpv6_stateless
(tempest.scenario.test_network_v6.TestGettingAddress.test_dualnet_multi_prefix_dhcpv6_stateless[compute
,id-cf1c4425-766b-45b8-be35-e2959728eb00,network]) failed with error on
python-openstackclient gates:

2016-10-04 13:59:59.811433 | Captured traceback:
2016-10-04 13:59:59.811450 | ~~~~~~~~~~~~~~~~~~~
2016-10-04 13:59:59.811471 |     Traceback (most recent call last):
2016-10-04 13:59:59.811513 |       File "tempest/test.py", line 107, in wrapper
2016-10-04 13:59:59.811558 |         return f(self, *func_args, **func_kwargs)
2016-10-04 13:59:59.811616 |       File "tempest/scenario/test_network_v6.py", line 256, in test_dualnet_multi_prefix_dhcpv6_stateless
2016-10-04 13:59:59.811640 |         dualnet=True)
2016-10-04 13:59:59.811672 |       File "tempest/scenario/test_network_v6.py", line 203, in _prepare_and_test
2016-10-04 13:59:59.811696 |         self.subnets_v6[i]['gateway_ip'])
2016-10-04 13:59:59.811728 |       File "tempest/scenario/test_network_v6.py", line 213, in _check_connectivity
2016-10-04 13:59:59.811751 |         (dest, source.ssh_client.host)
2016-10-04 13:59:59.811794 |       File "/opt/stack/new/tempest/.tox/tempest/local/lib/python2.7/site-packages/unittest2/case.py", line 702, in assertTrue
2016-10-04 13:59:59.811818 |         raise self.failureException(msg)
2016-10-04 13:59:59.811857 |     AssertionError: False is not true : Timed out waiting for 2003::1 to become reachable from 172.24.5.14

http://logs.openstack.org/11/376311/3/check/gate-tempest-dsvm-neutron-
src-python-openstackclient/04dabcd/console.html

At this time in neutron-server logs DBDeadlock occurs:

2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers Traceback (most recent call last):
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/managers.py", line 433, in _call_on_drivers
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     getattr(driver.obj, method_name)(context)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 60, in create_port_precommit
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._insert_provisioning_block(context)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 83, in _insert_provisioning_block
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     provisioning_blocks.L2_AGENT_ENTITY)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/api.py", line 159, in wrapped
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return method(*args, **kwargs)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/provisioning_blocks.py", line 74, in add_provisioning_component
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context.session.add(record)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.rollback()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.commit()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._prepare_impl()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.session.flush()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._flush(objects)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     transaction.rollback(_capture_exception=True)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     flush_context.execute()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     rec.execute(self)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     uow
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     mapper, table, insert)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     execute(statement, multiparams)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return meth(self, multiparams, params)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return connection._execute_clauseelement(self, multiparams, params)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compiled_sql, distilled_params
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     util.raise_from_cause(newraise, exc_info)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     cursor.execute(statement, parameters)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     result = self._query(query)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     conn.query(q)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     result.read()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     first_packet = self.connection._read_packet()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     packet.check_error()
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     err.raise_mysql_exception(self._data)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     raise errorclass(errno, errval)
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO provisioningblocks (standard_attr_id, entity) VALUES (%(standard_attr_id)s, %(entity)s)'] [parameters: {'standard_attr_id': 1726, 'entity': 'L2'}]
2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers 
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers Traceback (most recent call last):
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/managers.py", line 433, in _call_on_drivers
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     getattr(driver.obj, method_name)(context)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 60, in create_port_precommit
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._insert_provisioning_block(context)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 83, in _insert_provisioning_block
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     provisioning_blocks.L2_AGENT_ENTITY)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/api.py", line 159, in wrapped
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return method(*args, **kwargs)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/provisioning_blocks.py", line 74, in add_provisioning_component
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context.session.add(record)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.rollback()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.commit()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._prepare_impl()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.session.flush()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._flush(objects)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     transaction.rollback(_capture_exception=True)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     flush_context.execute()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     rec.execute(self)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     uow
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     mapper, table, insert)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     execute(statement, multiparams)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return meth(self, multiparams, params)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return connection._execute_clauseelement(self, multiparams, params)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compiled_sql, distilled_params
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     util.raise_from_cause(newraise, exc_info)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     cursor.execute(statement, parameters)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     result = self._query(query)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     conn.query(q)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     result.read()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     first_packet = self.connection._read_packet()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     packet.check_error()
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     err.raise_mysql_exception(self._data)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     raise errorclass(errno, errval)
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO provisioningblocks (standard_attr_id, entity) VALUES (%(standard_attr_id)s, %(entity)s)'] [parameters: {'standard_attr_id': 2254, 'entity': 'L2'}]
2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers 

http://logs.openstack.org/11/376311/3/check/gate-tempest-dsvm-neutron-
src-python-openstackclient/04dabcd/logs/screen-q-svc.txt.gz?level=ERROR

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1630257

Title:
  DBDeadlock occurs during test_dualnet_multi_prefix_dhcpv6_stateless

Status in neutron:
  New

Bug description:
  The test test_dualnet_multi_prefix_dhcpv6_stateless
  (tempest.scenario.test_network_v6.TestGettingAddress.test_dualnet_multi_prefix_dhcpv6_stateless[compute
  ,id-cf1c4425-766b-45b8-be35-e2959728eb00,network]) failed with error
  on python-openstackclient gates:

  2016-10-04 13:59:59.811433 | Captured traceback:
  2016-10-04 13:59:59.811450 | ~~~~~~~~~~~~~~~~~~~
  2016-10-04 13:59:59.811471 |     Traceback (most recent call last):
  2016-10-04 13:59:59.811513 |       File "tempest/test.py", line 107, in wrapper
  2016-10-04 13:59:59.811558 |         return f(self, *func_args, **func_kwargs)
  2016-10-04 13:59:59.811616 |       File "tempest/scenario/test_network_v6.py", line 256, in test_dualnet_multi_prefix_dhcpv6_stateless
  2016-10-04 13:59:59.811640 |         dualnet=True)
  2016-10-04 13:59:59.811672 |       File "tempest/scenario/test_network_v6.py", line 203, in _prepare_and_test
  2016-10-04 13:59:59.811696 |         self.subnets_v6[i]['gateway_ip'])
  2016-10-04 13:59:59.811728 |       File "tempest/scenario/test_network_v6.py", line 213, in _check_connectivity
  2016-10-04 13:59:59.811751 |         (dest, source.ssh_client.host)
  2016-10-04 13:59:59.811794 |       File "/opt/stack/new/tempest/.tox/tempest/local/lib/python2.7/site-packages/unittest2/case.py", line 702, in assertTrue
  2016-10-04 13:59:59.811818 |         raise self.failureException(msg)
  2016-10-04 13:59:59.811857 |     AssertionError: False is not true : Timed out waiting for 2003::1 to become reachable from 172.24.5.14

  http://logs.openstack.org/11/376311/3/check/gate-tempest-dsvm-neutron-
  src-python-openstackclient/04dabcd/console.html

  At this time in neutron-server logs DBDeadlock occurs:

  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers Traceback (most recent call last):
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/managers.py", line 433, in _call_on_drivers
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     getattr(driver.obj, method_name)(context)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 60, in create_port_precommit
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._insert_provisioning_block(context)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 83, in _insert_provisioning_block
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     provisioning_blocks.L2_AGENT_ENTITY)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/api.py", line 159, in wrapped
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return method(*args, **kwargs)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/provisioning_blocks.py", line 74, in add_provisioning_component
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context.session.add(record)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.rollback()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.commit()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._prepare_impl()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self.session.flush()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._flush(objects)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     transaction.rollback(_capture_exception=True)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     flush_context.execute()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     rec.execute(self)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     uow
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     mapper, table, insert)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     execute(statement, multiparams)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return meth(self, multiparams, params)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     return connection._execute_clauseelement(self, multiparams, params)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     compiled_sql, distilled_params
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     util.raise_from_cause(newraise, exc_info)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     context)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     cursor.execute(statement, parameters)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     result = self._query(query)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     conn.query(q)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     result.read()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     first_packet = self.connection._read_packet()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     packet.check_error()
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     err.raise_mysql_exception(self._data)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers     raise errorclass(errno, errval)
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO provisioningblocks (standard_attr_id, entity) VALUES (%(standard_attr_id)s, %(entity)s)'] [parameters: {'standard_attr_id': 1726, 'entity': 'L2'}]
  2016-10-04 13:34:51.346 21473 ERROR neutron.plugins.ml2.managers 
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers Traceback (most recent call last):
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/managers.py", line 433, in _call_on_drivers
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     getattr(driver.obj, method_name)(context)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 60, in create_port_precommit
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._insert_provisioning_block(context)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/plugins/ml2/drivers/mech_agent.py", line 83, in _insert_provisioning_block
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     provisioning_blocks.L2_AGENT_ENTITY)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/api.py", line 159, in wrapped
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return method(*args, **kwargs)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/opt/stack/new/neutron/neutron/db/provisioning_blocks.py", line 74, in add_provisioning_component
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context.session.add(record)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.rollback()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.commit()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._prepare_impl()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self.session.flush()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._flush(objects)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     transaction.rollback(_capture_exception=True)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compat.reraise(exc_type, exc_value, exc_tb)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     flush_context.execute()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     rec.execute(self)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     uow
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     mapper, table, insert)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     execute(statement, multiparams)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return meth(self, multiparams, params)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     return connection._execute_clauseelement(self, multiparams, params)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     compiled_sql, distilled_params
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     util.raise_from_cause(newraise, exc_info)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     context)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     cursor.execute(statement, parameters)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     result = self._query(query)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     conn.query(q)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     result.read()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     first_packet = self.connection._read_packet()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     packet.check_error()
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     err.raise_mysql_exception(self._data)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers     raise errorclass(errno, errval)
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers DBDeadlock: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'INSERT INTO provisioningblocks (standard_attr_id, entity) VALUES (%(standard_attr_id)s, %(entity)s)'] [parameters: {'standard_attr_id': 2254, 'entity': 'L2'}]
  2016-10-04 13:37:17.265 21473 ERROR neutron.plugins.ml2.managers 

  http://logs.openstack.org/11/376311/3/check/gate-tempest-dsvm-neutron-
  src-python-
  openstackclient/04dabcd/logs/screen-q-svc.txt.gz?level=ERROR

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1630257/+subscriptions
Follow ups

[Bug 1630257] Re: DBDeadlock occurs during test_dualnet_multi_prefix_dhcpv6_stateless
From: Ihar Hrachyshka, 2017-03-10