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

Sentry: Error when trying to insert a duplicate key in "reporting_ocptags_values" table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Normal Normal
    • 2023Q1
    • None
    • Data Pipeline
    • False
    • None
    • False

      https://red-hat-it.sentry.io/issues/4015574590/?project=1822753&referrer=slack

      IntegrityError masu.processor.tasks.update_summary_table
      duplicate key value violates unique constraint "reporting_ocptags_values_key_value_key"
      DETAIL:  Key (key, value)=(app, alertmanager) already exists.
      
      UniqueViolation: duplicate key value violates unique constraint "reporting_ocptags_values_key_value_key"
      DETAIL:  Key (key, value)=(app, alertmanager) already exists.
      
        File "django/db/backends/utils.py", line 84, in _execute
          return self.cursor.execute(sql, params)
      IntegrityError: duplicate key value violates unique constraint "reporting_ocptags_values_key_value_key"
      DETAIL:  Key (key, value)=(app, alertmanager) already exists.
      
        File "celery/app/trace.py", line 734, in __protected_call__
          return self.run(*args, **kwargs)
        File "masu/processor/tasks.py", line 501, in update_summary_tables
          raise ex
        File "masu/processor/tasks.py", line 477, in update_summary_tables
          updater.update_summary_tables(start_date, end_date, tracing_id, invoice_month=invoice_month)
        File "masu/processor/report_summary_updater.py", line 169, 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 159, in update_summary_tables
          accessor.populate_volume_label_summary_table([report_period_id], start_date, end_date)
        File "masu/database/ocp_report_db_accessor.py", line 462, in populate_volume_label_summary_table
          self._execute_processing_script(
        File "koku/database.py", line 607, in _execute_processing_script
          cur.execute(sql_stmt, params)
        File "django/db/backends/utils.py", line 66, in execute
          return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
        File "django/db/backends/utils.py", line 75, in _execute_with_wrappers
          return executor(sql, params, many, context)
        File "django/db/backends/utils.py", line 84, in _execute
          return self.cursor.execute(sql, params)
        File "django/db/utils.py", line 90, in __exit__
          raise dj_exc_value.with_traceback(traceback) from exc_value
        File "django/db/backends/utils.py", line 84, in _execute
          return self.cursor.execute(sql, params)
      

            rh-ee-sdoran Sam Doran
            rh-ee-sdoran Sam Doran
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: