-
Bug
-
Resolution: Done-Errata
-
Normal
-
None
-
None
-
5
-
False
-
None
-
False
-
-
TrinoUserError: line 84:37: mismatched input 'IN'. Expecting: 'AND', 'EXCEPT', 'FETCH', 'GROUP', 'HAVING', 'INTERSECT', 'LIMIT', 'OFFSET', 'OR', 'ORDER', 'UNION', 'WINDOW', <EOF> File "koku/trino_database.py", line 151, in executescript cur.execute(stmt, params=s_params) File "trino/dbapi.py", line 587, in execute self._iterator = iter(self._query.execute()) File "trino/client.py", line 810, in execute self._result.rows += self.fetch() File "trino/client.py", line 830, in fetch status = self._request.process(response) File "trino/client.py", line 609, in process raise self._process_error(response["error"], response.get("id"))TrinoStatementExecError: line 84:37: mismatched input 'IN'. Expecting: 'AND', 'EXCEPT', 'FETCH', 'GROUP', 'HAVING', 'INTERSECT', 'LIMIT', 'OFFSET', 'OR', 'ORDER', 'UNION', 'WINDOW', <EOF> File "celery/app/trace.py", line 734, in __protected_call__ return self.run(*args, **kwargs) File "masu/processor/tasks.py", line 538, in update_summary_tables raise ex File "masu/processor/tasks.py", line 515, in update_summary_tables start_date, end_date = updater.update_summary_tables( File "masu/processor/report_summary_updater.py", line 147, in update_summary_tables start_date, end_date = self._updater.update_summary_tables(start_date, end_date, invoice_month=invoice_month) File "masu/processor/ocp/ocp_report_parquet_summary_updater.py", line 129, in update_summary_tables accessor.populate_line_item_daily_summary_table_trino( File "masu/database/ocp_report_db_accessor.py", line 373, in populate_line_item_daily_summary_table_trino self._execute_trino_multipart_sql_query(sql, bind_params=sql_params) File "masu/database/report_db_accessor_base.py", line 153, in _execute_trino_multipart_sql_query return trino_db.executescript(trino_conn, sql, params=bind_params, preprocessor=self.trino_prepare_query) File "koku/trino_database.py", line 158, in executescript raise trino_statement_error from trino_exc
This looks like koku/masu/database/trino_sql/reporting_ocpusagelineitem_daily_summary.sql.
- is incorporated by
-
COST-4775 operator: v3.2.1 release
- Closed
- links to
-
RHBA-2024:129263 Cost Management security fix and enhancement update