It looks like one of the last change in neutron fixed it. Probably one
of these two:

https://review.openstack.org/#/c/271918/
https://review.openstack.org/#/c/272082/


** Changed in: neutron
       Status: New => Fix Released

** Changed in: networking-odl
       Status: New => 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/1537377

Title:
  sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such
  table

Status in networking-odl:
  Fix Released
Status in neutron:
  Fix Released

Bug description:
  When running too in project networking-old I most of tests py27 fail
  with errors like the one below:

  2016-01-23 16:49:16,515 | {2} 
networking_odl.tests.unit.ml2.test_driver.TestODLShim.test_update_port_postcommit
 [14.353879s] ... FAILED
  2016-01-23 16:49:16,515 |
  2016-01-23 16:49:16,516 | Captured traceback:
  2016-01-23 16:49:16,516 | ~~~~~~~~~~~~~~~~~~~
  2016-01-23 16:49:16,516 |     Traceback (most recent call last):
  2016-01-23 16:49:16,516 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/fixtures/fixture.py",
 line 125, in cleanUp
  2016-01-23 16:49:16,516 |         return 
self._cleanups(raise_errors=raise_first)
  2016-01-23 16:49:16,516 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/fixtures/callmany.py",
 line 88, in __call__
  2016-01-23 16:49:16,517 |         reraise(error[0], error[1], error[2])
  2016-01-23 16:49:16,517 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/fixtures/callmany.py",
 line 82, in __call__
  2016-01-23 16:49:16,517 |         cleanup(*args, **kwargs)
  2016-01-23 16:49:16,517 |       File 
"/opt/stack/networking-odl/.tox/py27/src/neutron/neutron/tests/unit/testlib_api.py",
 line 76, in clear_tables
  2016-01-23 16:49:16,517 |         conn.execute(table.delete())
  2016-01-23 16:49:16,517 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
 line 914, in execute
  2016-01-23 16:49:16,518 |         return meth(self, multiparams, params)
  2016-01-23 16:49:16,518 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py",
 line 323, in _execute_on_connection
  2016-01-23 16:49:16,518 |         return 
connection._execute_clauseelement(self, multiparams, params)
  2016-01-23 16:49:16,518 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
 line 1010, in _execute_clauseelement
  2016-01-23 16:49:16,518 |         compiled_sql, distilled_params
  2016-01-23 16:49:16,519 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
 line 1146, in _execute_context
  2016-01-23 16:49:16,519 |         context)
  2016-01-23 16:49:16,519 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
 line 1337, in _handle_dbapi_exception
  2016-01-23 16:49:16,519 |         util.raise_from_cause(newraise, exc_info)
  2016-01-23 16:49:16,519 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
 line 200, in raise_from_cause
  2016-01-23 16:49:16,519 |         reraise(type(exception), exception, 
tb=exc_tb)
  2016-01-23 16:49:16,520 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
 line 1139, in _execute_context
  2016-01-23 16:49:16,520 |         context)
  2016-01-23 16:49:16,520 |       File 
"/opt/stack/networking-odl/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
 line 450, in do_execute
  2016-01-23 16:49:16,520 |         cursor.execute(statement, parameters)
  2016-01-23 16:49:16,520 |     sqlalchemy.exc.OperationalError: 
(sqlite3.OperationalError) no such table: floatingipdnses [SQL: u'DELETE FROM 
floatingipdnses']
  2016-01-23 16:49:16,521 |
  2016-01-23 16:49:16,521 |
  2016-01-23 16:49:16,521 | Captured pythonlogging:
  2016-01-23 16:49:16,521 | ~~~~~~~~~~~~~~~~~~~~~~~
  2016-01-23 16:49:16,521 |      WARNING [neutron.agent.securitygroups_rpc] 
Driver configuration doesn't match with enable_security_group
  2016-01-23 16:49:16,521 |      WARNING [neutron.api.extensions] Extension dvr 
not supported by any of loaded plugins
  2016-01-23 16:49:16,522 |      WARNING [neutron.api.extensions] Extension 
extraroute not supported by any of loaded plugins
  2016-01-23 16:49:16,522 |      WARNING [neutron.api.extensions] Extension 
flavors not supported by any of loaded plugins
  2016-01-23 16:49:16,522 |      WARNING [neutron.api.extensions] Extension 
ext-gw-mode not supported by any of loaded plugins
  2016-01-23 16:49:16,522 |      WARNING [neutron.api.extensions] Extension 
l3-ha not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension 
l3_agent_scheduler not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension 
metering not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension 
port-security not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension qos 
not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension 
router_availability_zone not supported by any of loaded plugins
  2016-01-23 16:49:16,523 |      WARNING [neutron.api.extensions] Extension 
router-service-type not supported by any of loaded plugins
  2016-01-23 16:49:16,524 |      WARNING [neutron.api.extensions] Extension 
service-type not supported by any of loaded plugins
  2016-01-23 16:49:16,524 |      WARNING [neutron.api.extensions] Extension 
vlan-transparent not supported by any of loaded plugins
  2016-01-23 16:49:16,524 |        ERROR [neutron.api.extensions] Extension 
path 'neutron/tests/unit/extensions' doesn't exist!

To manage notifications about this bug go to:
https://bugs.launchpad.net/networking-odl/+bug/1537377/+subscriptions

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to