Havana 2013.2.1 RC: Resource Usage shows traceback with Ceilometer using MySQL backend

[Akihiro Motoki]

I ran stable/havana branch with devstack with Ceilometer.
When I visited Admin -> Resource Usage panel, I got the traceback.

horizon_error.log : http://paste.openstack.org/show/54653/
ceilometer-api.log : http://paste.openstack.org/show/54654/
traceback : http://paste.openstack.org/show/54655/

It seems "Resource Usage" implementation in Horizon calls unsupported method.

The versions I used are:
horizon : commit 5d9684d8c273e4a8cc7113ace6e157187a73db5b
ceilometer : commit 5cbb96511cd0489aaa311d57a42cd962ec7d73b6
python-ceilometerclient: commit 35e20cbfb27b7df86a88ca6f106ee4d690fb2679

[Akihiro Motoki (amotoki)]

I haven't checked it occurs in the master, but I think it is a release critical bug for havana stable update 2013.2.1.

[Julie Pichon (jpichon)]

This happens when using the mysql backend instead of the mongo backend in Ceilometer, as it is not feature complete and doesn't support features like the stats function required by the Resource Usages "Stats" panel. I'm not sure if mysql is recommended as a supported backend for Ceilometer in Havana.

Note that "mysql" is the default backend when using Devstack, due to something related to the Ubuntu mongo packages. To test with mongo, change the following line in devstack's lib/ceilometer file:

# Set up database backend
CEILOMETER_BACKEND=${CEILOMETER_BACKEND:-mysql}

to:

CEILOMETER_BACKEND=${CEILOMETER_BACKEND:-mongo}

Then re-run ./stack.sh. (You may have to install the mongodb package manually first if Ceilometer was previously installed already - tested on Fedora 19).

[Julie Pichon (jpichon)]

Additional information:

The SQLAlchemy backend is supported although Ceilometer users should be aware that it doesn't have feature parity with the mongo backend.

Notably it doesn't support features like the metadata-constrained querying of statistics required by the 'Resource Usages' panel. Horizon and alarming need to make this kind of queries.

There's no way for Horizon to see which backend is in use so, it seems it will be up to administrators to be aware of the features they need when installing Ceilometer...

The version of mongodb available in Ubuntu 12.04 is too old, which is why the devstack default was switched to mysql.

[Akihiro Motoki (amotoki)]

After tested with MongoDB 2.4.6, the error disappeared.
I marked it invalid. Thanks.

[Akihiro Motoki (amotoki)]

I changed the title and mark it "Won't fix".