quantum-server will not start: no such table: agents u'SELECT agents.id AS agents_id...

Asked by James Graves

I can got get quantum-server service to run nor can i get it to run manually

i believe it says that i have not defined a sql_cnnection and that's not true because it was set when i first setup the node

I have put ~~~~~~ where hostnames, ip's, usernames because i can not disclose the,

root@~~~~~~~~:/home/~~~~~~# sudo -u quantum quantum-server --config-dir /etc/quantum --config-file /etc/quantum/quantum.conf
2013-07-10 14:57:18 INFO [quantum.common.config] Logging enabled!
2013-07-10 14:57:18 INFO [quantum.common.config] Config paste file: /etc/quantum/api-paste.ini
2013-07-10 14:57:19 INFO [quantum.manager] Loading Plugin: quantum.plugins.openvswitch.ovs_quantum_plugin.OVSQuantumPluginV2
2013-07-10 14:57:19 WARNING [quantum.db.api] Option 'sql_connection' not specified in any config file - using default value 'sqlite://'
2013-07-10 14:57:19 INFO [quantum.plugins.openvswitch.ovs_quantum_plugin] Network VLAN ranges: {}
2013-07-10 14:57:19 INFO [quantum.openstack.common.rpc.common] Connected to AMQP server on ~~~~~~:5672
2013-07-10 14:57:19 INFO [quantum.api.extensions] Initializing extension manager.
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: agent.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: agent
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: l3.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: flavor.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: l3.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: router
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: flavor.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension flavor not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: providernet.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: loadbalancer.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension lbaas not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: portbindings.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: binding
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: servicetype.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension service-type not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: agentscheduler.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: agent_scheduler
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: securitygroup.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: routerservicetype.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension router-service-type not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: agentscheduler.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: providernet.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: provider
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: __init__.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: routedserviceinsertion.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: portsecurity.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: portsecurity.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension port-security not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: __init__.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: extraroute.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: extraroute
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: routedserviceinsertion.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension routed-service-insertion not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: quotasv2.py
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loaded extension: quotas
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: extraroute.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: portbindings.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: loadbalancer.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: agent.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: servicetype.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: routerservicetype.pyc
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: securitygroup.py
2013-07-10 14:57:19 WARNING [quantum.api.extensions] Extension security-group not supported by any of loaded plugins
2013-07-10 14:57:19 INFO [quantum.api.extensions] Loading extension file: quotasv2.pyc
2013-07-10 14:57:19 INFO [keystoneclient.middleware.auth_token] Starting keystone auth_token middleware
2013-07-10 14:57:19 INFO [keystoneclient.middleware.auth_token] Using /var/lib/quantum/keystone-signing as cache directory for signing certificate
2013-07-10 14:57:19 INFO [quantum.service] Quantum service started, listening on 0.0.0.0:9696
2013-07-10 14:57:19 ERROR [quantum.openstack.common.rpc.amqp] Exception during message handling
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/quantum/openstack/common/rpc/amqp.py", line 430, in _process_data
    rval = self.proxy.dispatch(ctxt, version, method, **args)
  File "/usr/lib/python2.7/dist-packages/quantum/common/rpc.py", line 43, in dispatch
    quantum_ctxt, version, method, **kwargs)
  File "/usr/lib/python2.7/dist-packages/quantum/openstack/common/rpc/dispatcher.py", line 133, in dispatch
    return getattr(proxyobj, method)(ctxt, **kwargs)
  File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 173, in report_state
    plugin.create_or_update_agent(context, agent_state)
  File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 145, in create_or_update_agent
    context, agent['agent_type'], agent['host'])
  File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 121, in _get_agent_by_type_and_host
    Agent.host == host).one()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one
    ret = list(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
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'Linux bridge agent', u'~~~~~~')
2013-07-10 14:57:19 INFO [quantum.openstack.common.rpc.common] Connected to AMQP server on ~~~~~~:5672
2013-07-10 14:57:19 ERROR [quantum.openstack.common.rpc.common] Returning exception (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'Linux bridge agent', u'~~~~~~') to caller
2013-07-10 14:57:19 ERROR [quantum.openstack.common.rpc.common] ['Traceback (most recent call last):\n', ' File "/usr/lib/python2.7/dist-packages/quantum/openstack/common/rpc/amqp.py", line 430, in _process_data\n rval = self.proxy.dispatch(ctxt, version, method, **args)\n', ' File "/usr/lib/python2.7/dist-packages/quantum/common/rpc.py", line 43, in dispatch\n quantum_ctxt, version, method, **kwargs)\n', ' File "/usr/lib/python2.7/dist-packages/quantum/openstack/common/rpc/dispatcher.py", line 133, in dispatch\n return getattr(proxyobj, method)(ctxt, **kwargs)\n', ' File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 173, in report_state\n plugin.create_or_update_agent(context, agent_state)\n', ' File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 145, in create_or_update_agent\n context, agent[\'agent_type\'], agent[\'host\'])\n', ' File "/usr/lib/python2.7/dist-packages/quantum/db/agents_db.py", line 121, in _get_agent_by_type_and_host\n Agent.host == host).one()\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one\n ret = list(self)\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__\n return self._execute_and_instances(context)\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, 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 1449, in execute\n params)\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement\n compiled_sql, distilled_params\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context\n context)\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context\n context)\n', ' File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute\n cursor.execute(statement, parameters)\n', "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'Linux bridge agent', u'~~~~~~')\n"]
2013-07-10 14:57:19 INFO [quantum.openstack.common.rpc.common] Connected to AMQP server on ~~~~~~:5672
^C
root@~~~~~~:/home/~~~~~~#

I killed it after it started spewing out all those long sets of errors because it would do it for each hyperviser

I am using GRE and OVS OpenVSwitch if that helps

Question information

Language:
English Edit question
Status:
Solved
For:
neutron Edit question
Assignee:
No assignee Edit question
Solved by:
James Graves
Solved:
Last query:
Last reply:
Revision history for this message
James Luhrsen (jamo) said :
#1

Double check your ovs_quantum_plugin.ini file and make sure the sql_connection is correct.

I can reproduce the same errors you see when I comment my sql_connection line out and restart quantum-server.

Revision history for this message
James Graves (powercamg4) said :
#2

Checked them and its correct

[DATABASE]
sql_connection = mysql://(User):(Pass)@(controller-ip)/quantum
reconnect_interval = 2

Revision history for this message
James Luhrsen (jamo) said :
#3

shot in the dark, but maybe your pointer to the plugin.ini file is not correct?

mine is in /etc/default/quantum-server pointing to the location of ovs_quantum_plugin.ini

Revision history for this message
James Graves (powercamg4) said :
#4

# defaults for quantum-server

# path to config file corresponding to the core_plugin specified in
# quantum.conf
QUANTUM_PLUGIN_CONFIG="/etc/quantum/plugins/openvswitch/ovs_quantum_plugin.ini"

This whats in the file

Revision history for this message
James Graves (powercamg4) said :
#5

bump

Revision history for this message
James Graves (powercamg4) said :
#6

canceled

Revision history for this message
James Luhrsen (jamo) said :
#7

HI James,

Did you figure it out? if so, what ended up being the issue? It might be helpful to the next one of us that runs in to it.

Revision history for this message
Xavier Peralta Ramos (javierperalta30) said :
#8

James,

how do you solved it?