Public bug reported:

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.

** Affects: neutron
     Importance: High
         Status: Confirmed


** Tags: db functional-tests gate-failure newton-rc-potential

-- 
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:
  Confirmed

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