2026-03-22 18:17:54,466 ERROR: Exception: Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.GroupingError: column "NT_Order.ID" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT min("NT_Sample".execution_time) AS min_1, "NT_Order"....
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1511, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 919, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.10/site-packages/flask_restful/__init__.py", line 298, in error_router
return original_handler(e)
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 917, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 902, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) # type: ignore[no-any-return]
File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/decorators.py", line 54, in wrap
return f(**args)
File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/views.py", line 1155, in v4_graph
data = load_geomean_data(field, machine, limit, xaxis_date, revision_cache)
File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/views.py", line 956, in load_geomean_data
data = multidict.multidict(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.GroupingError) column "NT_Order.ID" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT min("NT_Sample".execution_time) AS min_1, "NT_Order"....
^
[SQL: SELECT min("NT_Sample".execution_time) AS min_1, "NT_Order"."ID" AS "NT_Order_ID", "NT_Order"."NextOrder" AS "NT_Order_NextOrder", "NT_Order"."PreviousOrder" AS "NT_Order_PreviousOrder", "NT_Order".llvm_project_revision AS "NT_Order_llvm_project_revision", min("NT_Run"."StartTime") AS min_2
FROM "NT_Sample" JOIN "NT_Run" ON "NT_Run"."ID" = "NT_Sample"."RunID" JOIN "NT_Order" ON "NT_Order"."ID" = "NT_Run"."OrderID" JOIN "NT_Test" ON "NT_Test"."ID" = "NT_Sample"."TestID"
WHERE "NT_Run"."MachineID" = %(MachineID_1)s AND "NT_Sample".execution_time IS NOT NULL GROUP BY "NT_Order".llvm_project_revision, "NT_Test"."ID", "NT_Test"."Name"]
[parameters: {'MachineID_1': 1}]
(Background on this error at: http://sqlalche.me/e/13/f405)
[in app.py:135]