Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41751

Large SiteStats reports can cause out of memory conditions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 12.6, 19.0
    • Fix Version/s: None
    • Component/s: Sitestats
    • Labels:
      None
    • Test Plan:
      Hide
      1. Bring up a Sakai app server with a heap size of 8G (or smaller)
      2. Create a site
      3. Outside Sakai, populate the SST_RESOURCES table with 2 million rows with the site id of the site created above (in our case, almost all the events were from anonymous users, as the resources were flagged public)
      4. In Sakai in the site, go to Site Stats / Reports / Add / What Activity = Resources / When Period = All / Generate Report

      The report definition has a "Number of results" selector which is unchecked by default, and the solution is probably to impose an absolute maximum value, but not sure where exactly (maybe lower-level, in the service).

      Show
      Bring up a Sakai app server with a heap size of 8G (or smaller) Create a site Outside Sakai, populate the SST_RESOURCES table with 2 million rows with the site id of the site created above (in our case, almost all the events were from anonymous users, as the resources were flagged public) In Sakai in the site, go to Site Stats / Reports / Add / What Activity = Resources / When Period = All / Generate Report The report definition has a "Number of results" selector which is unchecked by default, and the solution is probably to impose an absolute maximum value, but not sure where exactly (maybe lower-level, in the service).

      Description

      In a site with a large number of SiteStats read events (we have one such with 2.3 million rows in SST_RESOURCES), generating a SiteStats report on resource access can cause the app server to run out of memory over a period of time (8G heap).

      There should be an upper limit on the number of rows included in a SiteStats report.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                smarquard Stephen Marquard
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Git Source Code