yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1264464] [NEW] issue after enable ml2 for neutron

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: "li,chen" <chen.li@xxxxxxxxx>
Date: Fri, 27 Dec 2013 08:35:00 -0000
Reply-to: Bug 1264464 <1264464@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Hi list,

Everything works fine when I'm working under plugin openvswitch.

While, after I enable ml2.

I met some issues:

1.After I start neutron-server, I get message in neutron-server, it
complains about can't create table 'ovs_ml2.networkdhcpagentbindings :

2013-12-27 08:27:53.840 32275 INFO neutron.plugins.ml2.managers [-] Configured mechanism driver names: []
2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Loaded mechanism driver names: []
2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Registered mechanism drivers: []
2013-12-27 08:27:53.994 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'flat'
2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.drivers.type_flat [-] ML2 FlatTypeDriver initialization complete
2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vlan'
2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_vlan [-] VlanTypeDriver initialization complete
2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'local'
2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'gre'
2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] gre ID ranges: []
2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vxlan'
2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] vxlan ID ranges: []
2013-12-27 08:27:54.079 32275 INFO neutron.openstack.common.rpc.impl_qpid [-] Connected to AMQP server on 192.168.11.11:5672
2013-12-27 08:27:54.084 32275 INFO neutron.plugins.ml2.plugin [-] Modular L2 Plugin initialization complete
2013-12-27 08:27:54.084 32275 INFO neutron.manager [-] Loading Plugin: neutron.services.l3_router.l3_router_plugin.L3RouterPlugin
2013-12-27 08:27:54.194 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()

2. table securitygroupportbindings missing.
Because I have booted instances in the cloud, then neutron-server keep reporting errors about can't find table securitygroupportbindings.

Anyone know why this happen ????

Thanks.
-chen

** Affects: neutron
     Importance: Undecided
         Status: New

** Description changed:

  Hi list,
  
  Everything works fine when I'm working under plugin openvswitch.
  
  While, after I enable ml2.
  
  I met some issues:
  
  1.After I start neutron-server, I get message in neutron-server, it
- complains aboutCan't create table 'ovs_ml2.networkdhcpagentbindings :
- 
+ complains about can't create table 'ovs_ml2.networkdhcpagentbindings :
  
  2013-12-27 08:27:53.840 32275 INFO neutron.plugins.ml2.managers [-] Configured mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Loaded mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Registered mechanism drivers: []
  2013-12-27 08:27:53.994 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'flat'
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.drivers.type_flat [-] ML2 FlatTypeDriver initialization complete
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vlan'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_vlan [-] VlanTypeDriver initialization complete
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'local'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'gre'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] gre ID ranges: []
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vxlan'
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] vxlan ID ranges: []
  2013-12-27 08:27:54.079 32275 INFO neutron.openstack.common.rpc.impl_qpid [-] Connected to AMQP server on 192.168.11.11:5672
  2013-12-27 08:27:54.084 32275 INFO neutron.plugins.ml2.plugin [-] Modular L2 Plugin initialization complete
  2013-12-27 08:27:54.084 32275 INFO neutron.manager [-] Loading Plugin: neutron.services.l3_router.l3_router_plugin.L3RouterPlugin
  2013-12-27 08:27:54.194 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  
- 
  2. table securitygroupportbindings missing.
  Because I have booted instances in the cloud, then neutron-server keep report errors about can't find table securitygroupportbindings.
- 
  
  Anyone know why this happen ????
  
  Thanks.
  -chen

** Description changed:

  Hi list,
  
  Everything works fine when I'm working under plugin openvswitch.
  
  While, after I enable ml2.
  
  I met some issues:
  
  1.After I start neutron-server, I get message in neutron-server, it
  complains about can't create table 'ovs_ml2.networkdhcpagentbindings :
  
  2013-12-27 08:27:53.840 32275 INFO neutron.plugins.ml2.managers [-] Configured mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Loaded mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Registered mechanism drivers: []
  2013-12-27 08:27:53.994 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'flat'
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.drivers.type_flat [-] ML2 FlatTypeDriver initialization complete
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vlan'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_vlan [-] VlanTypeDriver initialization complete
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'local'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'gre'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] gre ID ranges: []
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vxlan'
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] vxlan ID ranges: []
  2013-12-27 08:27:54.079 32275 INFO neutron.openstack.common.rpc.impl_qpid [-] Connected to AMQP server on 192.168.11.11:5672
  2013-12-27 08:27:54.084 32275 INFO neutron.plugins.ml2.plugin [-] Modular L2 Plugin initialization complete
  2013-12-27 08:27:54.084 32275 INFO neutron.manager [-] Loading Plugin: neutron.services.l3_router.l3_router_plugin.L3RouterPlugin
  2013-12-27 08:27:54.194 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  
  2. table securitygroupportbindings missing.
- Because I have booted instances in the cloud, then neutron-server keep report errors about can't find table securitygroupportbindings.
+ Because I have booted instances in the cloud, then neutron-server keep reporting errors about can't find table securitygroupportbindings.
  
  Anyone know why this happen ????
  
  Thanks.
  -chen

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

Title:
  issue after enable ml2 for neutron

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Hi list,

  Everything works fine when I'm working under plugin openvswitch.

  While, after I enable ml2.

  I met some issues:

  1.After I start neutron-server, I get message in neutron-server, it
  complains about can't create table 'ovs_ml2.networkdhcpagentbindings :

  2013-12-27 08:27:53.840 32275 INFO neutron.plugins.ml2.managers [-] Configured mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Loaded mechanism driver names: []
  2013-12-27 08:27:53.841 32275 INFO neutron.plugins.ml2.managers [-] Registered mechanism drivers: []
  2013-12-27 08:27:53.994 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'flat'
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.drivers.type_flat [-] ML2 FlatTypeDriver initialization complete
  2013-12-27 08:27:53.995 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vlan'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_vlan [-] VlanTypeDriver initialization complete
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'local'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'gre'
  2013-12-27 08:27:54.017 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] gre ID ranges: []
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vxlan'
  2013-12-27 08:27:54.019 32275 INFO neutron.plugins.ml2.drivers.type_tunnel [-] vxlan ID ranges: []
  2013-12-27 08:27:54.079 32275 INFO neutron.openstack.common.rpc.impl_qpid [-] Connected to AMQP server on 192.168.11.11:5672
  2013-12-27 08:27:54.084 32275 INFO neutron.plugins.ml2.plugin [-] Modular L2 Plugin initialization complete
  2013-12-27 08:27:54.084 32275 INFO neutron.manager [-] Loading Plugin: neutron.services.l3_router.l3_router_plugin.L3RouterPlugin
  2013-12-27 08:27:54.194 32275 INFO neutron.db.api [-] Database registration exception: (OperationalError) (1005, "Can't create table 'ovs_ml2.networkdhcpagentbindings' (errno: 150)") '\nCREATE TABLE networkdhcpagentbindings (\n\tnetwork_id VARCHAR(36) NOT NULL, \n\tdhcp_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (network_id, dhcp_agent_id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE, \n\tFOREIGN KEY(dhcp_agent_id) REFERENCES agents (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()

  2. table securitygroupportbindings missing.
  Because I have booted instances in the cloud, then neutron-server keep reporting errors about can't find table securitygroupportbindings.

  Anyone know why this happen ????

  Thanks.
  -chen

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

[Bug 1264464] [NEW] issue after enable ml2 for neutron
From: li,chen, 2013-12-27
References

[Bug 1264464] [NEW] issue after enable ml2 for neutron
From: li,chen, 2013-12-27