[openstack-dev] [Openstack] Errors in neutron-server while launching VM

Rahul Arora rahul1991.arora at gmail.com
Fri Oct 16 12:29:07 UTC 2015

Hi Nitish,

When i am trying to see table "networks" in the DB.I am not able to use
"show tables" command to see tables.looks like it this version does not
suppor that.

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing
binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

For server side help, type 'help contents'


Can you please redirect me how i can see this?



Rahul Arora

On Fri, Oct 16, 2015 at 3:52 PM, nithish B <bestofnithish at gmail.com> wrote:

> Hi Rahul,
> 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.
> Let me know.
> Thanks.
> Nitish B.
> Regards,
> Nitish B.
> On Fri, Oct 16, 2015 at 3:10 PM, Rahul Arora <rahul1991.arora at gmail.com>
> wrote:
>> Hi Team.
>> 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.
>> But when i am trying to launch VM using below command manually.
>> *nova boot --image 8f6e2973-c048-4445-8c31-38e159c930fc --flavor m1.tiny
>> "rahul"*
>> I am getting below error in *neutron-server *service.
>> =========================================
>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource
>> self.errorhandler(self, exc, value)
>> 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
>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource     raise
>> errorclass, errorvalue
>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource OperationalError:
>> (OperationalError) (1054, "Unknown column 'networks.mtu' in 'field list'")
>> 'SELECT networks.tenant_id AS networks_tenant_id, networks.id AS
>> networks_id, networks.name AS networks_name, networks.status AS
>> networks_status, 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,
>> ipallocationpools_1.id 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,
>> subnets_1.id AS subnets_1_id, subnets_1.name 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 networks.id = externalnetworks.network_id LEFT OUTER
>> JOIN subnets AS subnets_1 ON networks.id = subnets_1.network_id LEFT
>> OUTER JOIN ipallocationpools AS ipallocationpools_1 ON subnets_1.id =
>> ipallocationpools_1.subnet_id LEFT OUTER JOIN dnsnameservers AS
>> dnsnameservers_1 ON subnets_1.id = dnsnameservers_1.subnet_id LEFT OUTER
>> JOIN subnetroutes AS subnetroutes_1 ON subnets_1.id =
>> subnetroutes_1.subnet_id LEFT OUTER JOIN externalnetworks AS
>> externalnetworks_1 ON networks.id = externalnetworks_1.network_id
>> \nWHERE networks.tenant_id IN (%s) AND networks.shared IN (%s)'
>> ('75ee0e2b66e04287920904eb40351f57', 0)
>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource
>> NOTE: I am using ml2 plugins to run  the neutron-server service.
>> Please help me solving this issue.
>> Thanks for the help.
>> --
>> Regards
>> Rahul Arora
>> _______________________________________________
>> Mailing list:
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>> Post to     : openstack at lists.openstack.org
>> Unsubscribe :
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151016/03d60fe7/attachment.html>

More information about the OpenStack-dev mailing list