Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-4624

[Sentry] - TrinoStatementExecError Mismatched Input

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done-Errata
    • Icon: Normal Normal
    • None
    • None
    • Data Pipeline
    • 5
    • False
    • None
    • False

      Sentry Issue

      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.

            mskarbek Michael Skarbek
            rh-ee-sdoran Sam Doran
            Daniel Chorvatovic Daniel Chorvatovic
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: