Open Stack

Greetings folks,

I have spent a substantial amount of time investigating CI issues as of
recent, and I noticed that at some point the legacy
"ironic-tempest-pxe_ipmitool-postgres" CI job which has been kept around as
a non-voting postgres support canary, is now failing on the master branch.

Specifically, looking through the logs[0], it appears that structurally the
queries are no longer compatible.

np0033933847 neutron-server[90677]: WARNING oslo_db.sqlalchemy.exc_filters
[None req-155d0299-07ef-433a-8576-467127c82be4 None None] DBAPIError
exception wrapped.: 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:41:57.893335 np0033933847 neutron-server[90677]: LINE 2:
...standard_attr_id AS floatingips_standard_attr_id, subnetpool...
May 03 18:41:57.893335 np0033933847 neutron-server[90677]:
                                             ^
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters   File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line
1900, in _execute_context
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters     self.dialect.do_execute(
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters   File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line
736, in do_execute
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters 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:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters LINE 2: ...standard_attr_id AS
floatingips_standard_attr_id, subnetpool...
May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR
oslo_db.sqlalchemy.exc_filters
                 ^

>From Ironic's point of view, we're wondering if this is expected? Is it
likely to be fixed? If there are no plans to fix the DB queries, Ironic
will have no choice but to drop the CI job.

Thanks in advance!

-Julia

[0]:
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstack.org/pipermail/openstack-discuss/attachments/20230510/76c0c4d8/attachment-0001.htm>