Hi Nitish. Below is the output of status of neutron database.Yes i am using "use neutron" before running the command.
MariaDB [neutron]> status -------------- mysql Ver 15.1 Distrib 5.5.39-MariaDB, for Linux (powerpc) using readline 5.1 Connection id: 42 Current database: neutron Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 5.5.39-MariaDB Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 hour 15 min 15 sec Threads: 11 Questions: 24713 Slow queries: 5 Opens: 164 F On Fri, Oct 16, 2015 at 7:51 PM, nithish B <[email protected]> wrote: > 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
