[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find. ** Information type changed from Public Security to Public -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
** Information type changed from Public to Public Security -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
** No longer affects: cloud-archive -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
I hit similar issue in trusty. The following error is repeated multiple
times in server.log:
2015-11-11 20:20:40.238 9354 TRACE neutron File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in
do_execute
2015-11-11 20:20:40.238 9354 TRACE neutron cursor.execute(statement,
parameters)
2015-11-11 20:20:40.238 9354 TRACE neutron OperationalError: (OperationalError)
no such table: ml2_vlan_allocations u'SELECT
ml2_vlan_allocations.physical_network AS ml2_vlan_allocations
_physical_network, ml2_vlan_allocations.vlan_id AS
ml2_vlan_allocations_vlan_id, ml2_vlan_allocations.allocated AS
ml2_vlan_allocations_allocated \nFROM ml2_vlan_allocations' ()
2015-11-11 20:20:40.238 9354 TRACE neutron
2015-11-11 20:20:41.166 9371 ERROR neutron.service [-] Unrecoverable error:
please check log for details.
2015-11-11 20:20:41.166 9371 TRACE neutron.service Traceback (most recent call
last):
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/neutron/service.py", line 102, in serve_wsgi
2015-11-11 20:20:41.166 9371 TRACE neutron.service service.start()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/neutron/service.py", line 73, in start
2015-11-11 20:20:41.166 9371 TRACE neutron.service self.wsgi_app =
_run_wsgi(self.app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/neutron/service.py", line 168, in _run_wsgi
2015-11-11 20:20:41.166 9371 TRACE neutron.service app =
config.load_paste_app(app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/neutron/common/config.py", line 183, in
load_paste_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service app =
deploy.loadapp("config:%s" % config_path, name=app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in
loadapp
2015-11-11 20:20:41.166 9371 TRACE neutron.service return loadobj(APP, uri,
name=name, **kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in
loadobj
2015-11-11 20:20:41.166 9371 TRACE neutron.service return context.create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return
self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-11-11 20:20:41.166 9371 TRACE neutron.service **context.local_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-11-11 20:20:41.166 9371 TRACE neutron.service val = callable(*args,
**kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 28, in urlmap_factory
2015-11-11 20:20:41.166 9371 TRACE neutron.service app =
loader.get_app(app_name, global_conf=global_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in
get_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service name=name,
global_conf=global_conf).create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return
self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-11-11 20:20:41.166 9371 TRACE neutron.service **context.local_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-11-11 20:20:41.166 9371 TRACE neutron.service val = callable(*args,
**kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/neutron/auth.py", line 71, in pipeline_factory
2015-11-11 20:20:41.166 9371 TRACE neutron.service app =
loader.get_app(pipeline[-1])
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in
get_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service name=name,
global_conf=global_conf).create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return
self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File
"/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146,
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
Attaching /var/log/neutron/server.log ** Attachment added: "server.log.gz" https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+attachment/4517291/+files/server.log.gz ** Tags added: oil -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
I was able to recreate. The errors are same on the retry. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
** Also affects: cloud-archive Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
** Changed in: neutron (Ubuntu Vivid) Status: New = In Progress -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
** Branch linked: lp:ubuntu/vivid-proposed/neutron -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
This bug was fixed in the package neutron - 1:2015.1~b2-0ubuntu4 --- neutron (1:2015.1~b2-0ubuntu4) vivid; urgency=medium * Trim back plugin tests to those that a) don't have out-of-archive dependencies, b) don't rely on external fixtures and c) don't try to create runtime directories in /etc/neutron. * Refactor plugin tests to use a common test helper, use shortnames for core_plugin configuration. * Allow services to settle prior to testing to ensure that any failures are correctly detected. * Grab last 100 lines of neutron log files if any tests fail to aid diagnosis. -- James Page james.p...@ubuntu.com Wed, 18 Mar 2015 21:50:25 + ** Changed in: neutron (Ubuntu Vivid) Status: In Progress = Fix Released -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1429739 Title: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1429739/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
In fact this happens also under upstart, so it's not init specific.
** Tags removed: systemd-boot
** Also affects: neutron (Ubuntu Vivid)
Importance: High
Status: New
** Changed in: neutron (Ubuntu Vivid)
Assignee: (unassigned) = James Page (james-page)
** Description changed:
- Installing neutron-server under systemd leads to several failed startup
- attemps and eventual failure. journalctl -u neutron-server shows:
+ Installing neutron-server (under systemd or upstart) leads to several
+ failed startup attemps and eventual failure. journalctl -u neutron-
+ server shows:
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron Traceback (most recent call last):
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File /usr/bin/neutron-server, line 10, in module
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron sys.exit(main())
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/server/__init__.py, line 46, in main
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron neutron_api =
service.serve_wsgi(service.NeutronApiService)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/service.py, line 106, in serve_wsgi
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron LOG.exception(_LE('Unrecoverable error: please check log
'
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py, line 82, in __exit__
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron six.reraise(self.type_, self.value, self.tb)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/service.py, line 103, in serve_wsgi
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron service.start()
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/service.py, line 74, in start
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron self.wsgi_app = _run_wsgi(self.app_name)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/service.py, line 169, in _run_wsgi
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron app = config.load_paste_app(app_name)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/neutron/common/config.py, line 192, in
load_paste_app
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron app = deploy.loadapp(config:%s % config_path,
name=app_name)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py, line 247, in
loadapp
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron return loadobj(APP, uri, name=name, **kw)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py, line 272, in
loadobj
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron return context.create()
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py, line 710, in create
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron return self.object_type.invoke(self)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py, line 144, in invoke
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron **context.local_conf)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
/usr/lib/python2.7/dist-packages/paste/deploy/util.py, line 55, in fix_call
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron val = callable(*args, **kw)
Mar 09 08:53:33 autopkgtest neutron-server[2776]: 2015-03-09 08:53:33.948
2776 TRACE neutron File
