<div dir="ltr"><div><div><div><div><div><div><div>Hi Nasir,<br><br></div>While doing installation/configuration when i was trying to run neutron-server service.I got following errors. <br><br>2015-10-05 06:48:12.549 17209 TRACE neutron   File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br>2015-10-05 06:48:12.549 17209 TRACE neutron     raise errorclass, errorvalue<br><span style="background-color:rgb(255,0,0)">2015-10-05 06:48:12.549 17209 TRACE neutron ProgrammingError: (ProgrammingError) (1146, "Table 'neutron.ml2_gre_allocations' doesn't exist") 'SELECT ml2_gre_allocations.gre_id AS ml2_gre_allocations_gre_id, ml2_gre_allocations.allocated AS ml2_gre_allocations_allocated \nFROM ml2_gre_allocations' ()<br>2015-10-05 06:48:12.549 17209 TRACE neutron </span><br><br></div>To fix this from internet i got one command to upgrade database.Below is the command i used.<br><br>$ neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head<br><br>INFO  [alembic.runtime.migration] Context impl MySQLImpl.<br>INFO  [alembic.runtime.migration] Will assume non-transactional DDL.<br>INFO  [alembic.runtime.migration] Context impl MySQLImpl.<br>INFO  [alembic.runtime.migration] Will assume non-transactional DDL.<br>INFO  [alembic.runtime.migration] Running upgrade  -> havana, havana_initial<br>INFO  [alembic.runtime.migration] Running upgrade havana -> e197124d4b9, add unique constraint to members<br>/usr/lib/python2.7/site-packages/alembic/util/langhelpers.py:122: UserWarning: Argument 'name' is now named 'constraint_name' for method create<br>_unique_constraint().<br>  oldname, newname, fn_name<br>/usr/lib/python2.7/site-packages/alembic/util/langhelpers.py:122: UserWarning: Argument 'source' is now named 'table_name' for method create_un<br>ique_constraint().<br>  oldname, newname, fn_name<br>/usr/lib/python2.7/site-packages/alembic/util/langhelpers.py:122: UserWarning: Argument 'local_cols' is now named 'columns' for method create_u<br>nique_constraint().<br>  oldname, newname, fn_name<br>INFO  [alembic.runtime.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a unique constraint on (agent_type, host) columns to prevent<br> a race<br>condition when an agent entry is 'upserted'.<br>INFO  [alembic.runtime.migration] Running upgrade 1fcfc149aca4 -> 50e86cb2637a, nsx_mappings<br>INFO  [alembic.runtime.migration] Running upgrade 50e86cb2637a -> 1421183d533f, NSX DHCP/metadata support<br>INFO  [alembic.runtime.migration] Running upgrade 1421183d533f -> 3d3cb89d84ee, nsx_switch_mappings<br>INFO  [alembic.runtime.migration] Running upgrade 3d3cb89d84ee -> 4ca36cfc898c, nsx_router_mappings<br>INFO  [alembic.runtime.migration] Running upgrade 4ca36cfc898c -> 27cc183af192, ml2_vnic_type<br>INFO  [alembic.runtime.migration] Running upgrade 27cc183af192 -> 50d5ba354c23, ml2 binding:vif_details<br>INFO  [alembic.runtime.migration] Running upgrade 50d5ba354c23 -> 157a5d299379, ml2 binding:profile<br>INFO  [alembic.runtime.migration] Running upgrade 157a5d299379 -> 3d2585038b95, VMware NSX rebranding<br>INFO  [alembic.runtime.migration] Running upgrade 3d2585038b95 -> abc88c33f74f, lb stats<br>INFO  [alembic.runtime.migration] Running upgrade abc88c33f74f -> 1b2580001654, nsx_sec_group_mapping<br>INFO  [alembic.runtime.migration] Running upgrade 1b2580001654 -> e766b19a3bb, nuage_initial<br>INFO  [alembic.runtime.migration] Running upgrade e766b19a3bb -> 2eeaf963a447, floatingip_status<br>INFO  [alembic.runtime.migration] Running upgrade 2eeaf963a447 -> 492a106273f8, Brocade ML2 Mech. Driver<br>INFO  [alembic.runtime.migration] Running upgrade 492a106273f8 -> 24c7ea5160d7, Cisco CSR VPNaaS<br>INFO  [alembic.runtime.migration] Running upgrade 24c7ea5160d7 -> 81c553f3776c, bsn_consistencyhashes<br>INFO  [alembic.runtime.migration] Running upgrade 81c553f3776c -> 117643811bca, nec: delete old ofc mapping tables<br>INFO  [alembic.runtime.migration] Running upgrade 117643811bca -> 19180cf98af6, nsx_gw_devices<br>INFO  [alembic.runtime.migration] Running upgrade 19180cf98af6 -> 33dd0a9fa487, embrane_lbaas_driver<br>INFO  [alembic.runtime.migration] Running upgrade 33dd0a9fa487 -> 2447ad0e9585, Add IPv6 Subnet properties<br>INFO  [alembic.runtime.migration] Running upgrade 2447ad0e9585 -> 538732fa21e1, NEC Rename quantum_id to neutron_id<br>INFO  [alembic.runtime.migration] Running upgrade 538732fa21e1 -> 5ac1c354a051, n1kv segment allocs for cisco n1kv plugin<br>/usr/lib/python2.7/site-packages/alembic/util/langhelpers.py:122: UserWarning: Argument 'source' is now named 'source_table' for method create_<br>foreign_key().<br>  oldname, newname, fn_name<br>/usr/lib/python2.7/site-packages/alembic/util/langhelpers.py:122: UserWarning: Argument 'referent' is now named 'referent_table' for method cre<br>ate_foreign_key().<br>  oldname, newname, fn_name<br>INFO  [alembic.runtime.migration] Running upgrade 5ac1c354a051 -> icehouse, icehouse<br>INFO  [alembic.runtime.migration] Running upgrade icehouse -> 54f7549a0e5f, set_not_null_peer_address<br>INFO  [alembic.runtime.migration] Running upgrade 54f7549a0e5f -> 1e5dd1d09b22, set_not_null_fields_lb_stats<br>INFO  [alembic.runtime.migration] Running upgrade 1e5dd1d09b22 -> b65aa907aec, set_length_of_protocol_field<br>INFO  [alembic.runtime.migration] Running upgrade b65aa907aec -> 33c3db036fe4, set_length_of_description_field_metering<br>INFO  [alembic.runtime.migration] Running upgrade 33c3db036fe4 -> 4eca4a84f08a, Remove ML2 Cisco Credentials DB<br>INFO  [alembic.runtime.migration] Running upgrade 4eca4a84f08a -> d06e871c0d5, set_admin_state_up_not_null_ml2<br>INFO  [alembic.runtime.migration] Running upgrade d06e871c0d5 -> 6be312499f9, set_not_null_vlan_id_cisco<br>INFO  [alembic.runtime.migration] Running upgrade 6be312499f9 -> 1b837a7125a9, Cisco APIC Mechanism Driver<br>INFO  [alembic.runtime.migration] Running upgrade 1b837a7125a9 -> 10cd28e692e9, nuage_extraroute<br>INFO  [alembic.runtime.migration] Running upgrade 10cd28e692e9 -> 2db5203cb7a9, nuage_floatingip<br>INFO  [alembic.runtime.migration] Running upgrade 2db5203cb7a9 -> 5446f2a45467, set_server_default<br>INFO  [alembic.runtime.migration] Running upgrade 5446f2a45467 -> db_healing, Include all tables and make migrations unconditional.<br>INFO  [alembic.runtime.migration] Context impl MySQLImpl.<br>INFO  [alembic.runtime.migration] Will assume non-transactional DDL.<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'cisco_ml2_apic_epgs.provider'<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'cisco_n1kv_vxlan_allocations.allocated'<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'cisco_network_profiles.multicast_ip_index'<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'meteringlabelrules.excluded'<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'ml2_port_bindings.host'<br>INFO  [alembic.autogenerate.compare] Detected removed foreign key (router_id)(id) on table nuage_floatingip_pool_mapping<br>INFO  [alembic.autogenerate.compare] Detected added column 'nuage_routerroutes_mapping.destination'<br>INFO  [alembic.autogenerate.compare] Detected added column 'nuage_routerroutes_mapping.nexthop'<br>INFO  [alembic.autogenerate.compare] Detected server default on column 'poolmonitorassociations.status'<br>INFO  [alembic.autogenerate.compare] Detected added index 'ix_quotas_tenant_id' on '['tenant_id']'<br>Traceback (most recent call last):<br>  File "/usr/bin/neutron-db-manage", line 10, in <module><br>    sys.exit(main())<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 238, in main<br>    CONF.command.func(config, <a href="http://CONF.command.name">CONF.command.name</a>)<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 106, in do_upgrade<br>    do_alembic_command(config, cmd, revision, sql=CONF.command.sql)<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 72, in do_alembic_command<br>    getattr(alembic_command, cmd)(config, *args, **kwargs)<br>  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade<br>    script.run_env()<br>  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env<br>    util.load_python_file(self.dir, 'env.py')<br>  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file<br>    module = load_module_py(module_id, path)<br>  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py<br>    mod = imp.load_source(module_id, path, fp)<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 109, in <module><br>    run_migrations_online()<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 100, in run_migrations_online<br>    context.run_migrations()<br>  File "<string>", line 8, in run_migrations<br>  File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations<br>    self.get_context().run_migrations(**kw)<br>  File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations<br>    step.migration_fn(**kw)<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/1d6ee1ae5da5_db_healing.py", line 32, in upgrade<br>    heal_script.heal()<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/heal_script.py", line 76, in heal<br>    execute_alembic_command(el)<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/heal_script.py", line 88, in execute_alembic_command<br>    METHODS[command[0]](*command[1:])<br>  File "/usr/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/heal_script.py", line 173, in add_column<br>    op.add_column(table_name, column.copy(), schema=schema)<br>  File "<string>", line 8, in add_column<br>  File "<string>", line 3, in add_column<br>  File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1535, in add_column<br>    return operations.invoke(op)<br>  File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke<br>    return fn(self, operation)<br>  File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 123, in add_column<br>    schema=schema<br>  File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 172, in add_column<br>    self._exec(base.AddColumn(table_name, column, schema=schema))<br>  File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec<br>    return conn.execute(construct, *multiparams, **params)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 841, in execute<br>    return meth(self, multiparams, params)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection<br>    return connection._execute_ddl(self, multiparams, params)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 895, in _execute_ddl<br>    compiled<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1070, in _execute_context<br>    context)<br>  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/compat/handle_error.py", line 261, in _handle_dbapi_exception<br>    e, statement, parameters, cursor, context)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1267, in _handle_dbapi_exception<br>    util.raise_from_cause(newraise, exc_info)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause<br>    reraise(type(exception), exception, tb=exc_tb)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context<br>    context)<br>  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute<br>    cursor.execute(statement, parameters)<br>  File "/usr/lib/python2.7/site-packages/MySQLdb/cursors.py", line 201, in execute<br>    self.errorhandler(self, exc, value)<br>  File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br>    raise errorclass, errorvalue<br>oslo_db.exception.DBConnectionError: (OperationalError) (2013, 'Lost connection to MySQL server during query') 'ALTER TABLE nuage_routerroutes_<br>mapping ADD COLUMN destination VARCHAR(64) NOT NULL' ()<br>root@t1040rdb:~# <br> CTRL-A Z for help |115200 8N1 | NOR | Minicom 2.5    | VT102 |      Offline                                                                  <br><br></div>I got errors after running this command but my error in RED part got solved after running this command.<br><br></div>Is this the cause of my error which i mentioned in another email?<br><br></div>Thanks for the help<br><br>..<br><br></div>Regards<br><br></div>Rahul Arora<br><div><div><div><div><div><div><br><div><div><div><div><br></div></div></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 4:25 PM, Nasir Mahmood <span dir="ltr"><<a href="mailto:nasir.mahmood@gmail.com" target="_blank">nasir.mahmood@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">Rahul,<div><br></div><div>You may need to re-create neutron DB...this error should never be seen in your logs if your installation/configuration is gone good,</div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 3:22 PM, nithish B <span dir="ltr"><<a href="mailto:bestofnithish@gmail.com" target="_blank">bestofnithish@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">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><div dir="ltr"><div>Regards,<br></div>Nitish B.<br></div></div></div>
<br><div class="gmail_quote"><div><div>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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><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><font color="#888888"><br><br><br></font></span></div><span><font color="#888888">Rahul Arora<br></font></span></div>
<br></div></div>_______________________________________________<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" target="_blank">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>
<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" target="_blank">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><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div>Nasir Mahmood<br></div>
</font></span></div>
</blockquote></div><br></div>