Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1569

Queries via XMLA will crash the JVM and host OS.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 GA (4.8.0 GA Suite Release), 3.5.x (4.8.1 GA Suite Release), 3.6.0 (5.0.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Environment:
      Java 1.6.0_45 64bit CentOS 6.4 64bit fully patched
    • Story Points:
      2
    • 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.
    • Browser:
      Google Chrome 21.x
    • Operating System/s:
      CentOS 6.x

      Description

      10 Minute video walking through reproducing the crash. PDI OLAP Input step speaks XMLA to the BI Server, new mondrian.server.DynamicContentFinder$timer threads are created each time a query is run and never disposed of after the query completes.

      http://www.screencast.com/t/P7WwB5Vd1

      I doubt caching is working for XMLA queries because of how slowly they run despite being the exact same.

      Be careful about running the BI Server on your host OS without the protection of a Virtual Machine as it may make your host OS unstable because of spawning so many threads (the bug). This effect will spill out of your Java VM.

      All you need to do is run the attached transformation against your own server and monitor what happens.

        Attachments

        1. catalina.out
          129 kB
        2. CreateRowsForLooping.ktr
          20 kB
        3. Loop to crash the server.kjb
          20 kB
        4. mondrian.log
          221 kB
        5. pentaho.log
          197 kB
        6. Reproduce Errors with Mondrian 4_8_1_EE.ktr
          20 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              brandonjusa Brandon Jackson
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: