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