On Fri, 2015-10-16 at 20:04 +0530, EXT Rahul Arora wrote: HI Nitish, Actually i am running openstack kilo on my powerpc platform now.I am able to run it on the x86 successfully.
On the running setup i.e on x86 machine also i am having same output of the status command in neutron database,See below. mysql> use neutron Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> status -------------- mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (i686) using readline 6.3 Connection id: 381 Current database: neutron Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu) Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Server characterset: latin1 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 1 day 3 hours 52 min 27 sec Threads: 12 Questions: 576409 Slow queries: 0 Opens: 1600 Flush tables: 1 Open tables: 374 Queries per second avg: 5.744 I am wondering what is the issue in powerpc.So i guess cause is i am not able to run below command successfully on the powerpc. neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head But this command is successful in x86 machine. On powerpc i am getting below error while running it, raise errorclass, errorvalueegards sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create table 'neutron.nuage_routerroutes_mapping' (errno: 121)") '\nCREATE TA BLE nuage_routerroutes_mapping (\n\tdestination VARCHAR(64) NOT NULL, \n\tnexthop VARCHAR(64) NOT NULL, \n\trouter_id VARCHAR(36) NOT NULL, \n\ tnuage_route_id VARCHAR(36), \n\tPRIMARY KEY (destination, nexthop, router_id), \n\tFOREIGN KEY(router_id) REFERENCES routers (id) ON DELETE CA SCADE\n)ENGINE=InnoDB\n\n' () I am not able to solve this.Please help me on this, .. Regards Rahul Arora How are you installing juno? Is it a packaged version (devstack / ansible etc) or manually? It might be that you have MariaDB compiled for x86 on there (different instruction sets). On Fri, Oct 16, 2015 at 7:56 PM, nithish B <[email protected]<mailto:[email protected]>> wrote: Rahul, Clearly, neutron didn't create the tables right. You may have to re-install/re-configure neutron. Thanks. Regards, Nitish B. On Fri, Oct 16, 2015 at 7:55 PM, Rahul Arora <[email protected]<mailto:[email protected]>> wrote: 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]<mailto:[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]<mailto:[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<http://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]<mailto:[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]<mailto:[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]<mailto:[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<http://networks.id> AS networks_id, networks.name<http://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<http://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<http://subnets_1.id> AS subnets_1_id, subnets_1.name<http://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<http://networks.id> = externalnetworks.network_id LEFT OUTER JOIN subnets AS subnets_1 ON networks.id<http://networks.id> = subnets_1.network_id LEFT OUTER JOIN ipallocationpools AS ipallocationpools_1 ON subnets_1.id<http://subnets_1.id> = ipallocationpools_1.subnet_id LEFT OUTER JOIN dnsnameservers AS dnsnameservers_1 ON subnets_1.id<http://subnets_1.id> = dnsnameservers_1.subnet_id LEFT OUTER JOIN subnetroutes AS subnetroutes_1 ON subnets_1.id<http://subnets_1.id> = subnetroutes_1.subnet_id LEFT OUTER JOIN externalnetworks AS externalnetworks_1 ON networks.id<http://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]<mailto:[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]<mailto:[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]<mailto:[email protected]>?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
