Public bug reported: When listing resource providers in placement with a postgresql database, this error recently started showing up:
column "root_rp.uuid" must appear in the GROUP BY clause or be used in an aggregate function And then once you fix that it says the same for parent_rp.uuid. It's not clear when this problem came on the scene, since we don't test regularly with postgresql, but I do use it in my experiments with placement in a container [1] and it wasn't there as of April 6th, and probably a bit later. Work is in progress to fix this as well as turn on an experimental job for checking with postgres every now and again. [1] https://hub.docker.com/r/cdent/placedock/ ** Affects: nova Importance: Low Assignee: Chris Dent (cdent) Status: In Progress ** Tags: placement -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1765204 Title: Listing resource providers in placement with a postgresql backend gets a group by error Status in OpenStack Compute (nova): In Progress Bug description: When listing resource providers in placement with a postgresql database, this error recently started showing up: column "root_rp.uuid" must appear in the GROUP BY clause or be used in an aggregate function And then once you fix that it says the same for parent_rp.uuid. It's not clear when this problem came on the scene, since we don't test regularly with postgresql, but I do use it in my experiments with placement in a container [1] and it wasn't there as of April 6th, and probably a bit later. Work is in progress to fix this as well as turn on an experimental job for checking with postgres every now and again. [1] https://hub.docker.com/r/cdent/placedock/ To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1765204/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp