Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Unable to retrieve information horizon dashboard

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", line 1024, in _handle_dbapi_exception\n    exc_info\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause\n    reraise(type(exception), exception, tb=exc_tb)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context\n    context)\n', '  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute\n    cursor.execute(statement, parameters)\n', "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',)\n"]

and this error is from my server.log.1 in neutron:

2014-08-15 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
2014-08-15 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp     exc_info
2014-08-15 06:42:19.049 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 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp     reraise(type(exception), exception, tb=exc_tb)
2014-08-15 06:42:19.049 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 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp     context)
2014-08-15 06:42:19.049 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 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp     cursor.execute(statement, parameters)
2014-08-15 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp OperationalError: (OperationalError) no such table: agents u'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents.binary AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations \nFROM agents \nWHERE agents.agent_type = ? AND agents.host = ?' (u'DHCP agent', u'icehouse-network')
2014-08-15 06:42:19.049 937 TRACE neutron.openstack.common.rpc.amqp

I haven't a clue what's wrong, can anyone help me out? I can give more info on request