get statistics do not work with postgresql database
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Fix Released
|
High
|
gordon chung | ||
Icehouse |
Fix Released
|
High
|
Dirk Mueller |
Bug Description
Steps to reproduce:
1. Install devstack with postgresql database
2. Configure ceilometer to using postgresql
3. Get meter list(200 OK)
4. Get statistics for any meters(By example: vcpus).
Expected result: 200 OK
Actual result:
Status: 500
Body:
{"error_message": {"debuginfo": null, "faultcode": "Server", "faultstring": "(ProgrammingError) column \"meter.
=======
Stacktrace(in ceilometer-api log):
=======
2013-11-28 12:42:22.639 23577 ERROR wsme.api [-] Server-side error: "(ProgrammingError) column "meter.
LINE 1: SELECT meter.counter_unit AS unit, min(meter.
^
'SELECT meter.counter_unit AS unit, min(meter.
Traceback (most recent call last):
File "/usr/local/
result = f(self, *args, **kwargs)
File "/opt/stack/
for c in computed]
File "/opt/stack/
for res in self._make_
File "/usr/local/
return self._execute_
File "/usr/local/
result = conn.execute(
File "/usr/local/
params)
File "/usr/local/
compiled_sql, distilled_params
File "/usr/local/
context)
File "/usr/local/
context)
File "/usr/local/
cursor.
ProgrammingError: (ProgrammingError) column "meter.
LINE 1: SELECT meter.counter_unit AS unit, min(meter.
^
'SELECT meter.counter_unit AS unit, min(meter.
localhost - - [28/Nov/2013 12:42:22] "GET /v2/meters/
Changed in ceilometer: | |
assignee: | nobody → Ilya Tyaptin (ityaptin) |
status: | New → In Progress |
Changed in ceilometer: | |
assignee: | Ilya Tyaptin (ityaptin) → Alexei Kornienko (alexei-kornienko) |
tags: | added: havana-backport-potential |
Changed in ceilometer: | |
importance: | Undecided → High |
milestone: | none → juno-1 |
Changed in ceilometer: | |
status: | Fix Committed → Fix Released |
Changed in ceilometer: | |
milestone: | juno-1 → 2014.2 |
Fix proposed to branch: master /review. openstack. org/59204
Review: https:/