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

Mondrian queries hang after timeout

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 3.4.1 GA (4.5.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • 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.

      Description

      Mondrian is behaving abruptly if system is used by multiple users for long time. All the query requests are waiting forever at Mondrian server.

      After analyzing thread dump, we found that threads are blocked at Mondrian.

      Please find the details below...

      Thread 26163 "http-9000-2": (state = BLOCKED)
      at sun.misc.Unsafe.park(Native Method)
      at java.util.concurrent.locks.LockSupport.park(LockSupport.java:156)
      at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:811)
      at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(AbstractQueuedSynchronizer.java:969)
      at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(AbstractQueuedSynchronizer.java:1281)
      at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:218)
      at java.util.concurrent.FutureTask.get(FutureTask.java:83)
      at mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:131)
      at mondrian.rolap.RolapConnection.execute(RolapConnection.java:622)
      at mondrian.olap4j.MondrianOlap4jCellSet.execute(MondrianOlap4jCellSet.java:87)
      at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:415)
      at mondrian.olap4j.MondrianOlap4jPreparedStatement.executeQuery(MondrianOlap4jPreparedStatement.java:72)
      at mondrian.xmla.XmlaHandler.executeQuery(XmlaHandler.java:1685)
      at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:731)
      at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:646)
      at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:505)
      at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:317)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        PractiTest Integration




          Attachments

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. MONDRIAN-1217 Statement.cancel() during fact query leads to permanent segment lock

            • 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

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                greg.taylor@cunet.com Greg Taylor
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: