Request failed with "neutron router-list"

[albertomolina]

It seems there is a bug with neutron routers. After execute "neutron router-list" Request Failed: internal server error while processing your request.

TRACE:

2014-06-09 09:09:21.732 27827 ERROR neutron.api.v2.resource [req-f63c7e2f-41e2-42d7-a77e-0b7de34060bc None] index failed 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource Traceback (most recent call last): 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 87, in resource 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource result = method(request=request, _args) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 287, in index 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource return self._items(request, True, parent_id) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 236, in _items 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource obj_list = obj_getter(request.context, _kwargs) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/extraroute_db.py", line 165, in get_routers 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource marker=marker, page_reverse=page_reverse) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/l3_db.py", line 267, in get_routers 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource page_reverse=page_reverse) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/db/db_base_plugin_v2.py", line 197, in _get_collection 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource items = [dict_func(c, fields) for c in query] 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2404, in iter 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource return self._execute_and_instances(context) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2419, in _execute_and_instances 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource result = conn.execute(querycontext.statement, self._params) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 720, in execute 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource return meth(self, multiparams, params) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 317, in _execute_on_connection 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 817, in _execute_clauseelement 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource compiled_sql, distilled_params 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 947, in _execute_context 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource context) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1108, in _handle_dbapi_exception 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource exc_info 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 940, in _execute_context 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource context) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 435, in do_execute 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource cursor.execute(statement, parameters) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource self.errorhandler(self, exc, value) 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource raise errorclass, errorvalue 2014-06-09 09:09:21.732 27827 TRACE neutron.api.v2.resource OperationalError: (OperationalError) (1054, "Unknown column 'routers.enable_snat' in 'field list'") 'SELECT routers.tenant_id AS routers_tenant_id, routers.id AS routers_id, routers.name AS routers_name, routers.status AS routers_status, routers.admin_state_up AS routers_admin_state_up, routers.gw_port_id AS routers_gw_port_id, routers.enable_snat AS routers_enable_snat, routerroutes_1.destination AS routerroutes_1_destination, routerroutes_1.nexthop AS routerroutes_1_nexthop, routerroutes_1.router_id AS routerroutes_1_router_id \nFROM routers LEFT OUTER JOIN routerroutes AS routerroutes_1 ON routers.id = routerroutes_1.router_id' ()

[josedom24]

A mi parece que me da otro error:

ERROR: neutronclient.shell Request Failed: internal server error while processing your request. Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/neutronclient/shell.py", line 526, in run_subcommand return run_command(cmd, cmd_parser, sub_argv) File "/usr/lib/python2.7/dist-packages/neutronclient/shell.py", line 79, in run_command return cmd.run(known_args) File "/usr/lib/python2.7/dist-packages/neutronclient/common/command.py", line 34, in run return super(OpenStackCommand, self).run(parsed_args) File "/usr/lib/python2.7/dist-packages/cliff/display.py", line 80, in run column_names, data = self.take_action(parsed_args) File "/usr/lib/python2.7/dist-packages/neutronclient/common/command.py", line 40, in take_action return self.get_data(parsed_args) File "/usr/lib/python2.7/dist-packages/neutronclient/neutron/v2_0/init.py", line 610, in get_data data = self.retrieve_list(parsed_args) File "/usr/lib/python2.7/dist-packages/neutronclient/neutron/v2_0/init.py", line 579, in retrieve_list data = self.call_server(neutron_client, search_opts, parsed_args) File "/usr/lib/python2.7/dist-packages/neutronclient/neutron/v2_0/init.py", line 551, in call_server data = obj_lister(_search_opts) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 111, in with_params ret = self.function(instance, args, _kwargs) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 386, in list_routers __params) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1250, in list for r in self._pagination(collection, path, *_params): File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1263, in _pagination res = self.get(path, params=params) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1236, in get headers=headers, params=params) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1221, in retry_request headers=headers, params=params) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1164, in do_request self._handle_fault_response(status_code, replybody) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 1134, in _handle_fault_response exception_handler_v20(status_code, des_error_body) File "/usr/lib/python2.7/dist-packages/neutronclient/v2_0/client.py", line 84, in exception_handler_v20 message=error_dict) NeutronClientException: Request Failed: internal server error while processing your request. DEBUG: neutronclient.shell clean_up ListRouter DEBUG: neutronclient.shell Got an error: Request Failed: internal server error while processing your request.

[josedom24]

En horizon como administrador me sale que el agente openvswitch no está activado.

[josedom24]

Parece que tenemos problemas al acceder a las bases de datos, la instrucción se ejecuta como admin:

$ nova-manage --verbose service list Command failed, please check log for more info 2014-06-09 19:39:59.209 7464 CRITICAL nova [req-5fb1c97e-5a23-4be6-97a6-9cec0d301bc2 None None] OperationalError: (OperationalError) unable to open database file None None 2014-06-09 19:39:59.209 7464 TRACE nova Traceback (most recent call last): 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/bin/nova-manage", line 10, in 2014-06-09 19:39:59.209 7464 TRACE nova sys.exit(main()) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1374, in main 2014-06-09 19:39:59.209 7464 TRACE nova ret = fn(_fn_args, _fn_kwargs) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 685, in list 2014-06-09 19:39:59.209 7464 TRACE nova services = db.service_get_all(ctxt) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 111, in service_get_all 2014-06-09 19:39:59.209 7464 TRACE nova return IMPL.service_get_all(context, disabled) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 146, in wrapper 2014-06-09 19:39:59.209 7464 TRACE nova return f(_args, _kwargs) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 451, in service_get_all 2014-06-09 19:39:59.209 7464 TRACE nova query = model_query(context, models.Service) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 234, in model_query 2014-06-09 19:39:59.209 7464 TRACE nova session = kwargs.get('session') or get_session(use_slave=use_slave) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 122, in get_session 2014-06-09 19:39:59.209 7464 TRACE nova facade = _create_facade_lazily(use_slave) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 104, in _create_facade_lazily 2014-06-09 19:39:59.209 7464 TRACE nova dict(CONF.database.iteritems()) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 831, in init 2014-06-09 19:39:59.209 7464 TRACE nova retry_interval=kwargs.get('retry_interval', 10)) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 648, in create_engine 2014-06-09 19:39:59.209 7464 TRACE nova engine.connect() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1709, in connect 2014-06-09 19:39:59.209 7464 TRACE nova return self._connection_cls(self, kwargs) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 59, in init 2014-06-09 19:39:59.209 7464 TRACE nova self.connection = connection or engine.raw_connection() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1778, in raw_connection 2014-06-09 19:39:59.209 7464 TRACE nova return self.pool.unique_connection() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 273, in unique_connection 2014-06-09 19:39:59.209 7464 TRACE nova return _ConnectionFairy._checkout(self) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 626, in _checkout 2014-06-09 19:39:59.209 7464 TRACE nova fairy = _ConnectionRecord.checkout(pool) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 433, in checkout 2014-06-09 19:39:59.209 7464 TRACE nova rec = pool._do_get() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1038, in _do_get 2014-06-09 19:39:59.209 7464 TRACE nova return self._create_connection() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 278, in _create_connection 2014-06-09 19:39:59.209 7464 TRACE nova return _ConnectionRecord(self) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 404, in __init 2014-06-09 19:39:59.209 7464 TRACE nova self.connection = self.connect() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 527, in connect 2014-06-09 19:39:59.209 7464 TRACE nova connection = self.__pool._creator() 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 95, in connect 2014-06-09 19:39:59.209 7464 TRACE nova connection_invalidated=invalidated 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 185, in raise_from_cause 2014-06-09 19:39:59.209 7464 TRACE nova reraise(type(exception), exception, tb=exc_tb) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 89, in connect 2014-06-09 19:39:59.209 7464 TRACE nova return dialect.connect(_cargs, _cparams) 2014-06-09 19:39:59.209 7464 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 376, in connect 2014-06-09 19:39:59.209 7464 TRACE nova return self.dbapi.connect(_cargs, _cparams) 2014-06-09 19:39:59.209 7464 TRACE nova OperationalError: (OperationalError) unable to open database file None None 2014-06-09 19:39:59.209 7464 TRACE nova

[albertomolina]

¿Estás ejecutando todos los playbooks? Ten en cuenta que se va subiendo el site.yaml solo con los últimos plays descomentados. Debes descomentar desde el principio hasta el rol "horizon"

[albertomolina]

Solucionado con la actualización de los paquetes de neutron a 2014.1-7