Ask Your Question
0

Error while executing neutron agent-list

asked 2016-08-03 11:19:31 -0600

Nishu Kumar gravatar image

# neutron agent-list Request Failed: internal server error while processing your request. # This is what I get in neutron-server.log

2016-08-03 11:41:17.714 1753 TRACE oslo_messaging.rpc.dispatcher raise errorclass, errorvalue 2016-08-03 11:41:17.714 1753 TRACE oslo_messaging.rpc.dispatcher OperationalError: (OperationalError) (1054, "Unknown column 'agents.load' in 'field list'") '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, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %s AND agents.host = %s AND agents.admin_state_up = 1' ('L3 agent', 'kll5044') 2016-08-03 11:41:17.714 1753 TRACE oslo_messaging.rpc.dispatcher

The same error in openvswitch-agent.log 2016-08-03 12:13:46.589 5172 TRACE neutron.plugins.openvswitch.agent.ovs_neutron_agent RemoteError: Remote error: OperationalError (OperationalError) (1054, "Unknown column 'agents.load' in 'field list'") '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, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %s AND agents.host = %s' ('Open vSwitch agent', 'kll5044') 2016-08-03 12:13:46.589 5172 TRACE neutron.plugins.openvswitch.agent.ovs_neutron_agent [u'Traceback (most recent call last):\n', u' File "/usr/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply\n executor_callback))\n', u' File "/usr/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch\n executor_callback)\n', u' File "/usr/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 130, in _do_dispatch\n result = func(ctxt, **new_args)\n', u' File "/usr/lib/python2.7/dist-packages/neutron/db/agents_db.py", line 281, in report_state\n self.plugin.create_or_update_agent(context, agent_state)\n', u' File "/usr/lib/python2.7/dist-packages/neutron/db/agents_db.py", line 238, in create_or_update_agent\n return self._create_or_update_agent(context, agent)\n', u' File "/usr/lib/python2.7/dist-packages/neutron/db/agents_db.py", line 217, in _create_or_update_agent\n context, agent[\'agent_type\'], agent[\'host\'])\n', u' File "/usr/lib/python2.7/dist-packages/neutron/db/agents_db.py", line 193, in _get_agent_by_type_and_host\n Agent.host == host).one()\n', u' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2395, in one\n ret = list(self)\n', u' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2438, in __iter__\n return self._execute_and_instances(context)\n', u' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances\n result = conn.execute(querycontext.statement, self._params)\n', u' File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute\n return meth(self, multiparams, params)\n', u' File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection\n return connection._execute_clauseelement(self, multiparams, params)\n', u' File "/usr/lib/python2 ... (more)

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2016-08-04 02:04:42 -0600

Sofiane68 gravatar image

When you go to your controller node and you type

mysql 
show databases;

did you see neutron?

edit flag offensive delete link more

Comments

Yes PFB output

MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | glance | | information_schema | | keystone | | mysql | | neutron | | nova | | performance_schema | +-----------

Nishu Kumar gravatar imageNishu Kumar ( 2016-08-04 05:59:49 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2016-08-03 11:19:31 -0600

Seen: 326 times

Last updated: Aug 04 '16