Reviewed: https://review.openstack.org/380371 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=438d4a83b0967f97bef2fc4c86f956e5fa6ca685 Submitter: Jenkins Branch: master
commit 438d4a83b0967f97bef2fc4c86f956e5fa6ca685 Author: Ihar Hrachyshka <ihrac...@redhat.com> Date: Thu Sep 29 20:11:07 2016 +0000 TestSanityCheck: drop test tables during cleanup The tests were creating tables in the memory but were not cleaning them up, making them clash on attempt to create floatingips table. Change-Id: If28ef4ce76cd36e7240d106b75e43d16f43e2c16 Closes-Bug: #1629347 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1629347 Title: test_check_sanity_6b461a21bcfc_dup_on_no_fixed_ip fails with "(sqlite3.OperationalError) table floatingips already exists" Status in neutron: Fix Released Bug description: http://logstash.openstack.org/#dashboard/file/logstash.json?query=message%3A%5C%22in%20test_check_sanity_6b461a21bcfc_dup_on_no_fixed_ip%5C%22 Traceback (most recent call last): File "neutron/tests/base.py", line 125, in func return f(self, *args, **kwargs) File "neutron/tests/functional/db/test_migrations.py", line 432, in test_check_sanity_6b461a21bcfc_dup_on_no_fixed_ip floatingips.create(conn) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 742, in create checkfirst=checkfirst) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1532, in _run_visitor **kwargs).traverse_single(element) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single return meth(obj, **kw) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 767, in visit_table include_foreign_key_constraints=include_foreign_key_constraints File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute return meth(self, multiparams, params) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl compiled File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context context) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1393, in _handle_dbapi_exception exc_info File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context context) File "/var/lib/jenkins/workspace/openstack/sqla_branch/rel_1_1/neutron/.tox/sqla_py27/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 462, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table floatingips already exists [SQL: u'\nCREATE TABLE floatingips (\n\tfloating_network_id VARCHAR(36), \n\tfixed_port_id VARCHAR(36), \n\tfixed_ip_address VARCHAR(64)\n)\n\n'] 7 hits since the test landed the tree. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1629347/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp