yahoo-eng-team team mailing list archive

[Itsuro Oda <oda@xxxxxxxxxxxxx>]

Public bug reported:

operation:
$ mysql
> create database neutron_ml2 character set utf8;
> exit
$ neutron-server --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini

error:
2014-02-28 15:02:46.550 TRACE neutron ProgrammingError: (ProgrammingError) (1146, "Table 'neutron_ml2.ml2_vlan_allocations' doesn't exist") '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 FOR UPDATE' ()

investigation:
This problem introduced by https://review.openstack.org/#/c/74896/ .

Not that this problem does not occur if nuetron-db-manage is run before
running neutron-server since ml2_vlan_allocations table is created by
neutron-db-manage.

I did skip running neutron-db-manage usually and it was no problem. Is
it prohibited now ?

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1285993

Title:
  neutron-server crashes when running on an empty database

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  operation:
  $ mysql
  > create database neutron_ml2 character set utf8;
  > exit
  $ neutron-server --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini

  error:
  2014-02-28 15:02:46.550 TRACE neutron ProgrammingError: (ProgrammingError) (1146, "Table 'neutron_ml2.ml2_vlan_allocations' doesn't exist") '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 FOR UPDATE' ()

  investigation:
  This problem introduced by https://review.openstack.org/#/c/74896/ .

  Not that this problem does not occur if nuetron-db-manage is run
  before running neutron-server since ml2_vlan_allocations table is
  created by neutron-db-manage.

  I did skip running neutron-db-manage usually and it was no problem. Is
  it prohibited now ?

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1285993/+subscriptions