← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #45420

[Bug 1537377] Re: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table

  Thread Previous • Date Previous • • Thread Next 
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
  Thread Previous • Date Previous • • Thread Next