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

Problems with Infinispan segment cache

    XMLWordPrintable

    Details

    • 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

      We have encountered a problem with the Infinispan segment caching implementation.

      It seems to occur when a query timeout is reached while Mondrian is actively saving segments to the cache.

      Example:
      mondrian.rolap.queryTimeout = 120

      A query that takes longer than 120 seconds can be actively saving to the cache when the queryTimeout is reached.

      If the same query is run again, it immediately goes to the cache and the first object it tries to get from the cache is an object that was not actually cached. This is obvserved by looking at the logs.

      For example, the second time the query is run, immediately after the MDX query is logged, it tries to get a segment from the cache. Looking at the logs from the previous cache, many similar segment keys are saved, but the exact segment key that it is trying to get below was never actually saved into the cache (maybe it was about to be, im not sure). Mondrian then just seems to hang, no additional logging happens until the 2 minute query timeout has been reached.

      2012-02-23 21:06:15,344 DEBUG [mondrian.rolap.RolapResultShepherd$executor] [mondrian.mdx]

      {209.131.62.113} {ba7cdfa0-5ea5-4527-a1ad-2352f2017fe4} 115: select {[Measures].[Delv Clicks], [Measures].[Delv eCPM], [Measures].[Delv CTR], [Measures].[Delv Impressions], [Measures].[Delv Noad Impressions]} ON COLUMNS,
      NON EMPTY Order([Site].[Sites].[Site].Members, [Measures].[Delv Clicks], BASC) ON ROWS
      from [DIY]
      where ([Time].[Days].[2012].[Q1 2012].[01/2012].[01/15/2012] : [Time].[Days].[2012].[Q1 2012].[01/2012].[01/31/2012])

      2012-02-23 21:06:15,828 DEBUG [mondrian.rolap.RolapResultShepherd$executor] [mondrian.rolap.RolapUtil] {209.131.62.113}

      {ba7cdfa0-5ea5-4527-a1ad-2352f2017fe4}

      Getting segment from SegmentCache com.pentaho.analysis.segmentcache.impl.infinispan.InfinispanSegmentCache.
      Header:
      *Segment Header
      Schema:[DIY]
      Checksum:[ed7a2a71bbe5a04fda5307837730c6bb]
      Cube:[DIY]
      Measure:[Delv Revn Exchg Curr]
      Axes:[

      {DIM_DAY.DAY_ID=('20120115','20120116','20120117','20120118','20120119','20120120','20120121','20120122','20120123','20120124','20120125','20120126','20120127','20120128','20120129','20120130','20120131')} {DIM_SITE.SITE_ID=('446255104','446305104','446455104','446555104')}

      ]
      Excluded Regions:[]
      Compound Predicates:[]
      ID:[842786707f27ec49a5a8e0f99574c922902fcda93239950939250c75853c12b5]

        PractiTest Integration




          Attachments

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              adeshazor Anthony de Shazor (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: