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

[Sentry] Extended Deadlock detected

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • None
    • Data Pipeline
    • 5
    • False
    • None
    • False
    • Low

      We are having some deadlocks on Postgres when trying to delete and re-checking some rows on table reporting_ocpusagelineitem_daily_summary_2024_02:

      deadlock detected
DETAIL: Process 21664 waits for ShareLock on transaction 834767683; blocked by process 21131.
Process 21131 waits for ShareLock on transaction 834767716; blocked by process 21664.
HINT: See server log for query details.
CONTEXT: while deleting tuple (50651,2) in relation "reporting_ocpusagelineitem_daily_summary_2024_02"

      Issues links: https://red-hat-it.sentry.io/issues/4667068690/?project=1822753, https://red-hat-it.sentry.io/issues/4635301750/

      Related fix: https://github.com/project-koku/koku/pull/4250
       
       
       

       
       
       
       

       
       
       
       

       

            Unassigned Unassigned
            rh-ee-lbacciot Lucas Bacciotti
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated: