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 <nasir.mahm...@gmail.com>
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 <bestofnith...@gmail.com>
> 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 <rahul1991.ar...@gmail.com>
>> 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 : openst...@lists.openstack.org
>>> Unsubscribe :
>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>>>
>>>
>>
>> _______________________________________________
>> Mailing list:
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>> Post to : openst...@lists.openstack.org
>> Unsubscribe :
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>>
>>
>
>
> --
> Nasir Mahmood
>
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
