The tables were successfully recreated.
The only advice I can give is to 1) verify no table actually appears
when you do "show tables" for ovs_quantum, and 2) drop the current
ovs_quantum schema and create a new one (with no tables).
Did it several times, also check the user privileges in mysql, recreate
it, restart mysql, still no success
Even if the service starts fine, I guess it then fails when you try to
perform any operations. It would be nice to see that traceback.
for quantum-server :
2012-07-25 21:53:12 DEBUG [routes.middleware] No route matched for
GET /ports.json
2012-07-25 21:53:12 DEBUG [routes.middleware] Matched GET /ports.json
2012-07-25 21:53:12 DEBUG [routes.middleware] Route path:
'/ports{.format}', defaults: {'action': u'index', 'controller':
wsgify(quantum.api.v2.resource.resource, RequestClass=<class
'quantum.api.v2.resource.Request'>)}
2012-07-25 21:53:12 DEBUG [routes.middleware] Match dict: {'action':
u'index', 'controller': wsgify(quantum.api.v2.resource.resource,
RequestClass=<class 'quantum.api.v2.resource.Request'>), 'format':
u'json'}
2012-07-25 22:01:12 DEBUG [eventlet.wsgi.server] 192.168.23.5 - -
[25/Jul/2012 22:01:12] "GET /v2.0/networks.json HTTP/1.1" 200 124
0.001811
for quantum-agent (repeating at infinity):
ERROR:__main__:Main-loop Exception:
Traceback (most recent call last):
File
"/xxxx/openstack/quantum/quantum/plugins/openvswitch/agent/ovs_quantum_agent.py",
line 450, in daemon_loop
for p in db.ports.all())
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py",
line 809, in __getattr__
return self.entity(attr)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py",
line 806, in entity
return self.map_to(attr, tablename=attr, schema=schema)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py",
line 689, in map_to
schema=schema or self.schema)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py",
line 314, in __new__
table._init(name, metadata, *args, **kw)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py",
line 377, in _init
self._autoload(metadata, autoload_with, include_columns)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py",
line 393, in _autoload
self, include_columns, exclude_columns
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 2412, in run_callable
return conn.run_callable(callable_, *args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1959, in run_callable
return callable_(self, *args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 264, in reflecttable
return insp.reflecttable(table, include_columns, exclude_columns)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py",
line 350, in reflecttable
tbl_opts = self.get_table_options(table_name, schema,
**table.kwargs)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py",
line 178, in get_table_options
**kw)
File "<string>", line 1, in <lambda>
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py",
line 47, in cache
ret = fn(self, con, *args, **kw)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py",
line 2036, in get_table_options
parsed_state = self._parsed_state_or_create(connection, table_name,
schema, **kw)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py",
line 2135, in _parsed_state_or_create
info_cache=kw.get('info_cache', None)
File "<string>", line 1, in <lambda>
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py",
line 47, in cache
ret = fn(self, con, *args, **kw)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py",
line 2160, in _setup_parser
full_name=full_name)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/base.py",
line 2247, in _show_create_table
raise exc.NoSuchTableError(full_name)
NoSuchTableError: `ports`
for quantum-dhcp (repeating at infinity):
2012-07-25 21:53:20 INFO [quantum.agent.dhcp_agent] Connecting to
database "ovs_quantum" on 192.168.23.5
2012-07-25 21:53:20 WARNING [quantum.agent.dhcp_agent] Unable to get
network state delta. Exception: `subnets`
--
Mailing list: https://launchpad.net/~netstack
Post to : netstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~netstack
More help : https://help.launchpad.net/ListHelp
