Unable to retrieve information horizon dashboard

asked 2014-08-15 06:22:13 -0500

JayFitz91 gravatar image

When I log onto the horizon dashboard, I get a bunch of messages on each tab e.g (Unable to retrieve router list, unable to retrieve images etc.) I have this error in my neutron server.log

2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp     reraise(type(exception), exception, tb=exc_tb)
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp     context)
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp     cursor.execute(statement, parameters)
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp OperationalError: (OperationalError) no such table: ml2_gre_endpoints u'SELECT ml2_gre_endpoints.ip_address AS ml2_gre_endpoints_ip_address \nFROM ml2_gre_endpoints \nWHERE ml2_gre_endpoints.ip_address = ?' (u'10.10.250.54',)
2014-08-15 12:15:50.145 937 TRACE neutron.openstack.common.rpc.amqp 
2014-08-15 12:15:50.147 937 ERROR neutron.openstack.common.rpc.common [req-d9ffdcba-7b94-4e62-b2c0-b5c34d47037c None] Returning exception (OperationalError) no such table: ml2_gre_endpoints u'SELECT ml2_gre_endpoints.ip_address AS ml2_gre_endpoints_ip_address \nFROM ml2_gre_endpoints \nWHERE ml2_gre_endpoints.ip_address = ?' (u'10.10.250.54',) to caller
2014-08-15 12:15:50.147 937 ERROR neutron.openstack.common.rpc.common [req-d9ffdcba-7b94-4e62-b2c0-b5c34d47037c None] ['Traceback (most recent call last):\n', '  File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rpc/amqp.py", line 462, in _process_data\n    **args)\n', '  File "/usr/lib/python2.7/dist-packages/neutron/common/rpc.py", line 45, in dispatch\n    neutron_ctxt, version, method, namespace, **kwargs)\n', '  File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rpc/dispatcher.py", line 172, in dispatch\n    result = getattr(proxyobj, method)(ctxt, **kwargs)\n', '  File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_tunnel.py", line 108, in tunnel_sync\n    tunnel = driver.obj.add_endpoint(tunnel_ip)\n', '  File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_gre.py", line 185, in add_endpoint\n    filter_by(ip_address=ip).one())\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2310, in one\n    ret = list(self)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2353, in __iter__\n    return self._execute_and_instances(context)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2368, in _execute_and_instances\n    result = conn.execute(querycontext.statement, self._params)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute\n    params)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement\n    compiled_sql, distilled_params\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context\n    context)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py ...
(more)
edit retag flag offensive close merge delete

Comments

There is a pretty clear clue in the log: a table is missing. Edit your question and add more details about how you installed openstack, maybe there is a bug in the packages or something else.

smaffulli gravatar imagesmaffulli ( 2014-08-15 16:59:28 -0500 )edit