Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1217

Statement.cancel() during fact query leads to permanent segment lock

    Details

    • Customer Case:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • QA Validation Status:
      Not Yet Validated
    • CI Build:
      Master 73a81a097a1507ec198add70d05c2c67e7bf9905, Lagunitas 86787193734df631b334649e5b88d5c93941cd78
    • Sprint Status:
      In-Sprint

      Description

      We see a reproducible catastrophic issue with Mondrian's cache behavior. When an MDX statement is cancelled during a segment fetch, those segments are not properly marked as failed. Any future attempt to run a query that overlaps those segments will wait forever for that segment to complete.

      We believe this happens because the execution gets the exception and calls end(), which calls statements.clear() before the RolapResultShepherd has made a pass through to clean up the cancelled executions.

      Success Criteria:
      Research Spike - need to be able to reproduce.
      1. Mondrian1217.java
        52 kB
        Brandon Bruce
      2. threadDump.txt
        43 kB
        Kurtis Walker
      3. threadDump2.txt
        237 kB
        Kurtis Walker

        Issue Links

          Activity

          Hide
          Sarah Gerweck added a comment -
          Glad to see some progress on this one! We will try to pull in the new revision next week.
          Show
          Sarah Gerweck added a comment - Glad to see some progress on this one! We will try to pull in the new revision next week.
          Hide
          Slawomir Chodnicki added a comment -
          Closing tentatively. Please reopen if the issue persists.
          Show
          Slawomir Chodnicki added a comment - Closing tentatively. Please reopen if the issue persists.
          Hide
          Domen Pogacnik added a comment -
          I experience the same issue while using Mondrian 3.4.9. Can you point me to a commit that fixed that?
          Show
          Domen Pogacnik added a comment - I experience the same issue while using Mondrian 3.4.9. Can you point me to a commit that fixed that?
          Show
          Luc Boudreau added a comment - @Domen: https://github.com/pentaho/mondrian/commit/73a81a097a1507ec198add70d05c2c67e7bf9905
          Hide
          Brandon Bruce added a comment -
          Luc created a program to test this.
          Show
          Brandon Bruce added a comment - Luc created a program to test this.

            People

            • Assignee:
              Unassigned User
              Reporter:
              Sarah Gerweck
            • Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: