<div dir="ltr">Hi Rahul,<div>Is the table "networks" available in the DB? Looks like it does not exist and thus when neutron queries the DB, it returns the error.</div><div>Let me know.</div><div><br></div><div>Thanks.</div><div>Nitish B.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div>Regards,<br></div>Nitish B.<br></div></div></div>
<br><div class="gmail_quote">On Fri, Oct 16, 2015 at 3:10 PM, Rahul Arora <span dir="ltr"><<a href="mailto:rahul1991.arora@gmail.com" target="_blank">rahul1991.arora@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div>Hi Team.<br><br></div>I am trying to run Openstack 
KILO release on my Ubuntu 14.04 x86 machine.I am able to run all the 
services.i.e glance,nova.keystone,neutron etc successfully.<br><br></div>But when i am trying to launch VM using below command manually.<br><br><b>nova boot --image 8f6e2973-c048-4445-8c31-38e159c930fc --flavor m1.tiny "rahul"</b><br><br></div>I am getting below error in <b>neutron-server </b>service.<br>=========================================<br><br><br>2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource     self.errorhandler(self, exc, value)<br>2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br>2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource     raise errorclass, errorvalue<br>2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource O<span style="background-color:rgb(255,0,0)">perationalError:
 (OperationalError) (1054, "Unknown column 'networks.mtu' in 'field 
list'") 'SELECT networks.tenant_id AS networks_tenant_id, <a href="http://networks.id" target="_blank">networks.id</a> AS networks_id, <a href="http://networks.name" target="_blank">networks.name</a> AS networks_name, networks.status AS networks_status, </span>networks.admin_state_up
 AS networks_admin_state_up, networks.shared AS networks_shared, 
networks.mtu AS networks_mtu, networks.vlan_transparent AS 
networks_vlan_transparent, <a href="http://ipallocationpools_1.id" target="_blank">ipallocationpools_1.id</a>
 AS ipallocationpools_1_id, ipallocationpools_1.subnet_id AS 
ipallocationpools_1_subnet_id, ipallocationpools_1.first_ip AS 
ipallocationpools_1_first_ip, ipallocationpools_1.last_ip AS 
ipallocationpools_1_last_ip, dnsnameservers_1.address AS 
dnsnameservers_1_address, dnsnameservers_1.subnet_id AS 
dnsnameservers_1_subnet_id, subnetroutes_1.destination AS 
subnetroutes_1_destination, subnetroutes_1.nexthop AS 
subnetroutes_1_nexthop, subnetroutes_1.subnet_id AS 
subnetroutes_1_subnet_id, subnets_1.tenant_id AS subnets_1_tenant_id, <a href="http://subnets_1.id" target="_blank">subnets_1.id</a> AS subnets_1_id, <a href="http://subnets_1.name" target="_blank">subnets_1.name</a>
 AS subnets_1_name, subnets_1.network_id AS subnets_1_network_id, 
subnets_1.subnetpool_id AS subnets_1_subnetpool_id, subnets_1.ip_version
 AS subnets_1_ip_version, subnets_1.cidr AS subnets_1_cidr, 
subnets_1.gateway_ip AS subnets_1_gateway_ip, subnets_1.enable_dhcp AS 
subnets_1_enable_dhcp, subnets_1.shared AS subnets_1_shared, 
subnets_1.ipv6_ra_mode AS subnets_1_ipv6_ra_mode, 
subnets_1.ipv6_address_mode AS subnets_1_ipv6_address_mode, 
externalnetworks_1.network_id AS externalnetworks_1_network_id \nFROM 
networks LEFT OUTER JOIN externalnetworks ON <a href="http://networks.id" target="_blank">networks.id</a> = externalnetworks.network_id LEFT OUTER JOIN subnets AS subnets_1 ON <a href="http://networks.id" target="_blank">networks.id</a> = subnets_1.network_id LEFT OUTER JOIN ipallocationpools AS ipallocationpools_1 ON <a href="http://subnets_1.id" target="_blank">subnets_1.id</a> = ipallocationpools_1.subnet_id LEFT OUTER JOIN dnsnameservers AS dnsnameservers_1 ON <a href="http://subnets_1.id" target="_blank">subnets_1.id</a> = dnsnameservers_1.subnet_id LEFT OUTER JOIN subnetroutes AS subnetroutes_1 ON <a href="http://subnets_1.id" target="_blank">subnets_1.id</a> = subnetroutes_1.subnet_id LEFT OUTER JOIN externalnetworks AS externalnetworks_1 ON <a href="http://networks.id" target="_blank">networks.id</a> = externalnetworks_1.network_id \nWHERE networks.tenant_id IN (%s) AND networks.shared IN (%s)' ('75ee0e2b66e04287920904eb40351f57', 0)<br>2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource <br><br></div>NOTE: I am using ml2 plugins to run  the neutron-server service.<br><br>Please help me solving this issue.<br><br>Thanks for the help.<br><br><br>--<br><br></div>Regards<span class="HOEnZb"><font color="#888888"><br><br><br></font></span></div><span class="HOEnZb"><font color="#888888">Rahul Arora<br></font></span></div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to     : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br></div>