<div dir="ltr"><div><div><div><div><div><div><div>Hi Nitish,<br><br></div>Below is the output.<br><br></div><span style="background-color:rgb(255,0,0)">On powerpc i.e. not working setup<br><br>root@t1040rdb:~# mysql -u root -p<br>Enter password: <br>Welcome to the MariaDB monitor. Commands end with ; or \g.<br>Your MariaDB connection id is 45<br>Server version: 5.5.39-MariaDB Source distribution<br><br>Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br><br>MariaDB [(none)]> use neutron<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Database changed<br>MariaDB [neutron]> show tables<br> -> <br><br></span></div><span style="background-color:rgb(255,0,0)">show tables shows nothing.<br></span><br></div><span style="background-color:rgb(255,255,0)">On x86 i.e working setup<br><br>ashish@ashish-To-be-filled-by-O-E-M:~$ mysql -u root -p<br>Enter password: <br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 389<br>Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)<br><br>Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.<br><br>Oracle is a registered trademark of Oracle Corporation and/or its<br>affiliates. Other names may be trademarks of their respective<br>owners.<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br><br>mysql> use neutron<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Database changed<br>mysql> show tables<br> -> <br><br></span></div><span style="background-color:rgb(255,255,255)">Looks like both are same.<br><br>..<br><br></span></div><span style="background-color:rgb(255,255,255)">Regards<br><br></span></div>Rahul Arora<span style="background-color:rgb(255,255,255)"><br></span><div><div><div><div><br><br><br><div><br><span style="background-color:rgb(255,0,0)"><span style=""></span></span><br></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 8:07 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">Rahul,<div>After "use neutron", try "show tables" in both the machines and let me know what is the output.</div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div>Regards,<br></div>Nitish B.<br></div></div></div><div><div class="h5">
<br><div class="gmail_quote">On Fri, Oct 16, 2015 at 8:04 PM, Rahul Arora <span dir="ltr"><<a href="mailto:rahul1991.arora@gmail.com" target="_blank">rahul1991.arora@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"><div><div><div>HI Nitish,<br><br></div>Actually i am running openstack kilo on my powerpc platform now.I am able to run it on the x86 successfully.<br><br></div>On the running setup i.e on x86 machine also i am having same output of the status command in neutron database,See below.<br><br>mysql> use neutron<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Database changed<br>mysql> status<br>--------------<br>mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (i686) using readline 6.3<br><br>Connection id: 381<span><br>Current database: neutron<br>Current user: root@localhost<br>SSL: Not in use<br>Current pager: stdout<br>Using outfile: ''<br>Using delimiter: ;<br></span>Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)<br>Protocol version: 10<br>Connection: 127.0.0.1 via TCP/IP<br>Server characterset: latin1<br>Db characterset: utf8<br>Client characterset: utf8<br>Conn. characterset: utf8<br>TCP port: 3306<br>Uptime: 1 day 3 hours 52 min 27 sec<br><br>Threads: 12 Questions: 576409 Slow queries: 0 Opens: 1600 Flush tables: 1 Open tables: 374 Queries per second avg: 5.744<br><br><br></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">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.</blockquote><span><div><br> </div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><b>neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head</b></blockquote><div><br></div></span><div>But this command is successful in x86 machine.<br><br></div><div>On powerpc i am getting below error while running it,<br><br></div><div>raise errorclass, errorvalueegards<br></div><div>sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create table 'neutron.nuage_routerroutes_mapping' (errno: 121)") '\nCREATE TA<br>BLE nuage_routerroutes_mapping (\n\tdestination VARCHAR(64) NOT NULL, \n\tnexthop VARCHAR(64) NOT NULL, \n\trouter_id VARCHAR(36) NOT NULL, \n\<br>tnuage_route_id VARCHAR(36), \n\tPRIMARY KEY (destination, nexthop, router_id), \n\tFOREIGN KEY(router_id) REFERENCES routers (id) ON DELETE CA<br>SCADE\n)ENGINE=InnoDB\n\n' ()<br><br><br></div><div>I am not able to solve this.Please help me on this,<br><br>..<br><br>Regards<br><br></div><div>Rahul Arora<br></div><div><br><br> <br></div><div><br> </div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"> <br></blockquote></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 7:56 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">Rahul,<div>Clearly, neutron didn't create the tables right. You may have to re-install/re-configure neutron.</div><div><br></div><div>Thanks.</div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div>Regards,<br></div>Nitish B.<br></div></div></div><div><div>
<br><div class="gmail_quote">On Fri, Oct 16, 2015 at 7:55 PM, Rahul Arora <span dir="ltr"><<a href="mailto:rahul1991.arora@gmail.com" target="_blank">rahul1991.arora@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"><div>Hi Nitish.<br><br></div>Below is the output of status of neutron database.Yes i am using "use neutron" before running the command.<br><br>MariaDB [neutron]> status<br>--------------<br>mysql Ver 15.1 Distrib 5.5.39-MariaDB, for Linux (powerpc) using readline 5.1<br><br>Connection id: 42<br>Current database: neutron<br>Current user: root@localhost<br>SSL: Not in use<br>Current pager: stdout<br>Using outfile: ''<br>Using delimiter: ;<br>Server: MariaDB<br>Server version: 5.5.39-MariaDB Source distribution<br>Protocol version: 10<br>Connection: Localhost via UNIX socket<br>Server characterset: utf8<br>Db characterset: utf8<br>Client characterset: latin1<br>Conn. characterset: latin1<br>UNIX socket: /var/lib/mysql/mysql.sock<br>Uptime: 1 hour 15 min 15 sec<br><br>Threads: 11 Questions: 24713 Slow queries: 5 Opens: 164 F<br></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 7:51 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">Rahul,<div>Please check the version of MySQL/MariaDB which you are using. For quick reference, you can use the following command in mysql: "<strong style="color:rgb(0,0,0);font-family:'Courier New',Courier,fixed,monospace;font-size:13px;line-height:20px;margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;background:transparent"><code style="margin:0px;padding:1px;border:0px;outline:0px;font-size:12.35px;vertical-align:baseline;color:inherit;font-family:'Courier New',Courier,fixed,monospace;background-image:initial;background-color:inherit;background-repeat:initial">SHOW VARIABLES LIKE "%version%";"</code></strong></div><div><br></div><div><font face="arial, helvetica, sans-serif" color="#000000"><span style="line-height:20px">Also, before you run "show tables", you need to select the DB to use, using "use <db_name>".</span></font></div><div><font face="arial, helvetica, sans-serif" color="#000000"><span style="line-height:20px"><br></span></font></div><div><font face="arial, helvetica, sans-serif" color="#000000"><span style="line-height:20px">Thanks.</span></font></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div>Regards,<br></div>Nitish B.<br></div></div></div><div><div>
<br><div class="gmail_quote">On Fri, Oct 16, 2015 at 6:41 PM, Rahul Arora <span dir="ltr"><<a href="mailto:rahul1991.arora@gmail.com" target="_blank">rahul1991.arora@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"><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" target="_blank">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)<span><br> File "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br></span> 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<span><font color="#888888"><br><br></font></span></div><span><font color="#888888">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></font></span></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><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><font color="#888888">-- <br><div>Nasir Mahmood<br></div>
</font></span></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>