I admin I have never seen anything like this.
The issue must then be either in configure_db or register_models, both in
db/api.py, even if I would have expected to see "Database Registration
Exception" in the logs.
However, I cannot say what's the root cause for the issue - Quantum,
sqlAlchemy, or something else in your environment.
I know this sounds odd, but if you can instrument configure_db code to see
which paths are taken into that routine that might help us understand a
little bit better what's happening in your environment, and maybe file a
bug for Quantum if required.
I am on the #openstack-dev IRC channel, my nick is salv-orlando. Feel free
to ping me.
Salvatore
On 25 July 2012 21:57, Nicolas de BONFILS <openst...@nicolas2bonfils.com>wrote:
>
> 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
