<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Hi,</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Dnia czwartek, 11 maja 2023 10:10:50 CEST Rodolfo Alonso Hernandez pisze:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Hi Julia:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Let me open a LP bug for this issue. I'll check if this call is being</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> tested in our CI and with the specific DB backend.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Regards.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> On Wed, May 10, 2023 at 7:32 PM Julia Kreger <juliaashleykreger@gmail.com></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Greetings folks,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > I have spent a substantial amount of time investigating CI issues as of</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > recent, and I noticed that at some point the legacy</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "ironic-tempest-pxe_ipmitool-postgres" CI job which has been kept around as</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > a non-voting postgres support canary, is now failing on the master branch.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Specifically, looking through the logs[0], it appears that structurally</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > the queries are no longer compatible.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > np0033933847 neutron-server[90677]: WARNING oslo_db.sqlalchemy.exc_filters</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > [None req-155d0299-07ef-433a-8576-467127c82be4 None None] DBAPIError</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > exception wrapped.: psycopg2.errors.GroupingError: column</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "subnetpools.address_scope_id" must appear in the GROUP BY clause or be</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > used in an aggregate function</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: LINE 2:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > ...standard_attr_id AS floatingips_standard_attr_id, subnetpool...</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > ^</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters File</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > 1900, in _execute_context</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters File</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > 736, in do_execute</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters psycopg2.errors.GroupingError: column</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "subnetpools.address_scope_id" must appear in the GROUP BY clause or be</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > used in an aggregate function</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters LINE 2: ...standard_attr_id AS</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > floatingips_standard_attr_id, subnetpool...</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > May 03 18:41:57.893335 np0033933847 neutron-server[90677]: ERROR</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > oslo_db.sqlalchemy.exc_filters</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > ^</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > From Ironic's point of view, we're wondering if this is expected? Is it</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > likely to be fixed? If there are no plans to fix the DB queries, Ironic</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > will have no choice but to drop the CI job.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Thanks in advance!</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > -Julia</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > [0]:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right: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</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> ></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">We have only one postgres related job in our periodic queue neutron-ovn-tempest-postgres-full and it seems to be pretty stable [1]. I don't know however if it somehow skips this path but I don't see any errors like that in the neutron's log file.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">[1] <a href="https://zuul.openstack.org/builds?job_name=neutron-ovn-tempest-postgres-full&project=openstack/neutron">https://zuul.openstack.org/builds?job_name=neutron-ovn-tempest-postgres-full&project=openstack/neutron</a></p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-- </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Slawek Kaplonski</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Principal Software Engineer</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Red Hat</p>
</body>
</html>