resource-list seems not work with postgresql
Bug #1241526 reported by
Mehdi Abaakouk
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Fix Released
|
High
|
Thomas Maddox | ||
Havana |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
Hi,
I have created some ceilometerclient very simple test in tempest https:/
And ceilometer resource-list won't work with postgres backend:
Ceilometer API error on this test:
http://
Cheers,
Changed in ceilometer: | |
status: | New → Triaged |
importance: | Undecided → High |
Changed in ceilometer: | |
milestone: | none → icehouse-1 |
status: | Fix Committed → Fix Released |
Changed in ceilometer: | |
milestone: | icehouse-1 → 2014.1 |
To post a comment you must log in.
Looks to be because of three non-aggregate values being selected from an aggregated subquery:
(SELECT
max(meter. id) AS max_id,
anon_2. resource_ id AS resource_id,
anon_2. max_ts AS max_ts,
anon_2. min_ts AS min_ts
meter. resource_ id AS resource_id,
max( meter.timestamp ) AS max_ts,
min( meter.timestamp ) AS min_ts
meter. resource_ id = anon_2.resource_id AND
meter. timestamp = anon_2.max_ts
FROM meter,
(SELECT
FROM meter
GROUP BY meter.resource_id) AS anon_2
WHERE
GROUP BY meter.resource_id)
The logs were complaining about anon_2.resource_id; I'd wager the other 2 will cause trouble as well.