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

Reply via email to