GET /v1/resources failed on sqlalchemy db backend

[Lianhao Lu]

When using sqlalchemy db backend, calling the Web API "GET /v1/resources" fails with the following output of ceilometer-api:

2013-02-22 16:35:36.939 18967 DEBUG ceilometer.storage [-] looking for 'mysql' driver in 'ceilometer.storage' get_engine /opt/stack/ceilometer/ceilometer/storage/__init__.py:57
2013-02-22 16:35:37.035 18967 INFO ceilometer.storage.impl_sqlalchemy [-] connecting to mysql://root:123456@localhost/ceilometer?charset=utf8
2013-02-22 16:35:37.097 18967 ERROR ceilometer.api [-] Exception on /v1/resources [GET]
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api Traceback (most recent call last):
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1687, in wsgi_app
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api response = self.full_dispatch_request()
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1360, in full_dispatch_request
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api rv = self.handle_user_exception(e)
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1358, in full_dispatch_request
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api rv = self.dispatch_request()
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1344, in dispatch_request
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api return self.view_functions[rule.endpoint](**req.view_args)
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/opt/stack/ceilometer/ceilometer/api/v1/blueprint.py", line 250, in list_all_resources
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api project=acl.get_limited_to_project(flask.request.headers))
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/opt/stack/ceilometer/ceilometer/api/v1/blueprint.py", line 215, in _list_resources
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api return flask.jsonify(resources=list(resources))
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api File "/opt/stack/ceilometer/ceilometer/storage/impl_sqlalchemy.py", line 264, in get_resources
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api raise NotImplementedError('metaquery not implemented')
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api NotImplementedError: metaquery not implemented
2013-02-22 16:35:37.097 18967 TRACE ceilometer.api
127.0.0.1 - - [22/Feb/2013 16:35:37] "GET /v1/resources HTTP/1.1" 500 -

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/22669

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/22669
Committed: http://github.com/openstack/ceilometer/commit/84f5e6318c7830c30e196625b05379aceb4f9bb1
Submitter: Jenkins
Branch: master

commit 84f5e6318c7830c30e196625b05379aceb4f9bb1
Author: Lianhao Lu <email address hidden>
Date: Fri Feb 22 17:20:03 2013 +0800

    Allow empty dict as metaquery param for sqlalchemy.

    Corrected the test of metaquery param in sqlalchemy backend.

    Fixed bug #1131620.

    Change-Id: Ief7e78444b99f6e8a46bd634c9be12708e10b212