[Building Sakai] SiteStats leaking memory?

[Brian Jones]

This is only semi-related, but we've found that on SiteStats 2.2.2 using
Oracle (10g), this list being so massive causes ORA-01795 exceptions to be
thrown, rendering the SiteStats tool un-usable.

In Oracle, you can only put a maximum of 1000 elements in an 'IN' clause.
Other queries in SiteStats have been optimized for this Oracle situation,
but not all:

https://jira.sakaiproject.org/browse/STAT-331

Cheers,

Brian Jones
Applications Development
Information Technology Services
Support Services Building, Room 4326
Western University
(519) 661-2111 x86969
bjones86 at uwo.ca


-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org
[mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Matthew
Buckett
Sent: Wednesday, November 14, 2012 6:04 AM
To: Sakai Developers
Subject: Re: [Building Sakai] SiteStats leaking memory?

On Wed, Nov 14, 2012 at 10:27 AM, Matthew Buckett
<matthew.buckett at it.ox.ac.uk> wrote:
> While looking through a heap dump I've got:
>
> org.sakaiproject.sitestats.impl.event.EventRegistryServiceImpl.toolEve
> ntIds
>
> as an list containing 7.6 million items, all of them a event string, 
> it looks like ever single event is ending up in this list, it's only 
> eating up 61MB, but still it's a little worrying. We're running 
> Sitestats 2.2.1, but the code doesn't look very different in trunk.

Ok, so it's not capturing every event, due to YourKit's display of the
underlying array I was misreading it. Actually it's appending pres.being
every time it processes an event.

Filed as:

https://jira.sakaiproject.org/browse/STAT-332

--
  Matthew Buckett, VLE Developer, IT Services, University of Oxford
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
with a subject of "unsubscribe"