Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-674

Deadlocks as a result of the speedup by joining on idset table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: TBD
    • Resolution: Fixed
    • Affects Version/s: Reporting 0.9.0
    • Fix Version/s: Reporting 0.9.1
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Undetermined

      Description

      If you are evaluating multiple things at once (e.g. you have a scheduled report running, and a user accesses a UI feature that evaluates a cohort definition) you can run into deadlocks with the reporting_idset table.

      You might see an exception like "Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction" but the message isn't always the same.

      This was introduced in REPORT-474

        Attachments

          Activity

            People

            Assignee:
            mseaton Mike Seaton
            Reporter:
            darius Darius Jazayeri [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: