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

Sentry: IntegrityError on reporting_awsorganizationalunit table on provider delete

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Undefined Undefined
    • April 2024, 2024Q2
    • None
    • None
    • None
    • 5
    • False
    • None
    • False

      When inserting records into the reporting_awscostentrylineitem_daily_summary table,
      we don't join on org units with a source_uuid for the source being processed.
      This likely causes cascade delete to fail when attempting to remove related records in the reporting_awsorganizationalunit on source delete.
       
      sql to insert into reporting_awscostentrylineitem_daily_summary:
      https://github.com/project-koku/koku/blob/main/koku/reporting/provider/aws/models.py#L144
       
       
      Sentry:
      https://red-hat-it.sentry.io/issues/5058587341/?alert_rule_id=930641&alert_type=issue&notification_uuid=f0ec39b3-d961-4a50-8ef9-cd324aa7d5c9&project=1822753&referrer=slack
       
       
      Slack discussion:
      https://redhat-internal.slack.com/archives/C024FE2HNF7/p1710357219066899
       
       
       
       

            mskarbek Michael Skarbek
            rh-ee-dnakabaa David Nakabaale
            Eva Šebestová Eva Šebestová
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: