Trying to graph the geometric mean results in an internal server error

[ldionne]

Then click on Graph.

This was found in the production server configuration built with Docker Compose. The logs show:

| Traceback (most recent call last):
webserver  |   File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1511, in wsgi_app
webserver  |     response = self.full_dispatch_request()
webserver  |   File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 919, in full_dispatch_request
webserver  |     rv = self.handle_user_exception(e)
webserver  |   File "/usr/local/lib/python3.10/site-packages/flask_restful/__init__.py", line 298, in error_router
webserver  |     return original_handler(e)
webserver  |   File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 917, in full_dispatch_request
webserver  |     rv = self.dispatch_request()
webserver  |   File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 902, in dispatch_request
webserver  |     return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]
webserver  |   File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/decorators.py", line 54, in wrap
webserver  |     return f(**args)
webserver  |   File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/views.py", line 1155, in v4_graph
webserver  |     data = load_geomean_data(field, machine, limit, xaxis_date, revision_cache)
webserver  |   File "/usr/local/lib/python3.10/site-packages/lnt/server/ui/views.py", line 956, in load_geomean_data
webserver  |     data = multidict.multidict(
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
webserver  |     return self._execute_and_instances(context)
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
webserver  |     result = conn.execute(querycontext.statement, self._params)
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
webserver  |     return meth(self, multiparams, params)
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
webserver  |     return connection._execute_clauseelement(self, multiparams, params)
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
webserver  |     ret = self._execute_context(
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
webserver  |     self._handle_dbapi_exception(
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
webserver  |     util.raise_(
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
webserver  |     raise exception
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
webserver  |     self.dialect.do_execute(
webserver  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
webserver  |     cursor.execute(statement, parameters)
webserver  | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.GroupingError) column "NT_Order.ID" must appear in the GROUP BY clause or be used in an aggregate function
webserver  | LINE 1: SELECT min("NT_Sample".execution_time) AS min_1, "NT_Order"....