Public bug reported: As reported in the Ironic CI [1], the query performed in ``FloatingIP.get_scoped_floating_ips`` is failing because of: """ ERROR oslo_messaging.rpc.server oslo_db.exception.DBError: (psycopg2.errors.GroupingError) column "subnetpools.address_scope_id" must appear in the GROUP BY clause or be used in an aggregate function May 03 18:42:03.790127 np0033933847 neutron-server[90676]: ERROR oslo_messaging.rpc.server LINE 2: ...standard_attr_id AS floatingips_standard_attr_id, subnetpool... """
The patch that introduced the "GROUP BY" clause is [2]. Snippet: https://paste.opendev.org/show/bPxCQXpieE5G5v31xudJ/ [1]https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_291/882164/1/check/ironic-tempest-pxe_ipmitool-postgres/291f2f8/controller/logs/screen-q-svc.txt [2]https://review.opendev.org/c/openstack/neutron/+/876168 ** Affects: neutron Importance: Medium Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez) Status: New ** Changed in: neutron Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez) ** Changed in: neutron Importance: Undecided => Medium -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/2019186 Title: [PostgreSQL] Issue with "get_scoped_floating_ips" query Status in neutron: New Bug description: As reported in the Ironic CI [1], the query performed in ``FloatingIP.get_scoped_floating_ips`` is failing because of: """ ERROR oslo_messaging.rpc.server oslo_db.exception.DBError: (psycopg2.errors.GroupingError) column "subnetpools.address_scope_id" must appear in the GROUP BY clause or be used in an aggregate function May 03 18:42:03.790127 np0033933847 neutron-server[90676]: ERROR oslo_messaging.rpc.server LINE 2: ...standard_attr_id AS floatingips_standard_attr_id, subnetpool... """ The patch that introduced the "GROUP BY" clause is [2]. Snippet: https://paste.opendev.org/show/bPxCQXpieE5G5v31xudJ/ [1]https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_291/882164/1/check/ironic-tempest-pxe_ipmitool-postgres/291f2f8/controller/logs/screen-q-svc.txt [2]https://review.opendev.org/c/openstack/neutron/+/876168 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/2019186/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
