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)
    • Fix Version/s: 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.

        PractiTest Integration




          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

            is duplicated by

            Bug - A problem which impairs or prevents the functions of the product. MONDRIAN-1409 XMLA (OLAP input in PDI) queries are causing high CPU usage.

            • Medium - An issue that impacts the ability to use Pentaho in a production environment but business operation is able to continue, although it may, to a certain extent, be hindered. A viable documented workaround exists for the issue and can be used in a production environment.
            • Closed
            is related to

            Task - A task that needs to be done. MONDRIAN-1590 Test MONDRIAN-1569 in 4.8.2

            • Unknown - Priority Unknown or Unassigned
            • Open

              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: