[Building Sakai] Sakai Memory Issues

[John Bush]

we are on the 2.9 tag.   I don't have a smokin' gun yet to really say
if that's the root cause or not.  We are using appdynamics to look at
things in production.  What we are seeing is a single request run this
type of query literary hundreds of times.

[SELECT special_access_id, forum_id, topic_id, start_date,
hide_until_open, end_date, allow_until_date, override_start_date,
override_hide_until_open, override_end_date,
override_allow_until_date, password, lock_end_date, users FROM
jforum_special_access WHERE forum_id = '116964'  AND topic_id > 0]

Each one is fast and our database has no issue.  Eventually we see
getting connections taking awhile and threads get blocked but we
aren't running into any type of bottleneck load or connection wise on
the db.  I think the appservers are simply running stupid amounts of
queries and just eating up connections and then blocking and keeping
things in memory.  Its just a hunch right now.  Its the best we've got
so far.

I wrote some code to cache this stuff yesterday, we are QA'ing today.
Again, I'm not sure its jforum, but jforum certainly isn't helping.

On Tue, Oct 8, 2013 at 6:22 AM, Mike Jennings <mike_jennings at unc.edu> wrote:
> John,
>
> We are using JForum and Sakai 2.9.2 and are not seeing any Memory Issues to
> date.  What version of JForum's do you suspect this memory leak in?
>
> Mike Jennings
>
>
> On 10/07/2013 05:39 PM, John Bush wrote:
>>
>> We've been having an issue like this with one client, we think it
>> might be related to jforum.  Do you use jforum ?
>>
>> On Mon, Oct 7, 2013 at 1:11 PM, William Karavites
>> <willkara at oit.rutgers.edu> wrote:
>>>
>>> Hello Community,
>>>
>>> I was wondering if there were any outstanding or recently fixed memory
>>> usage
>>> issues for Sakai. We recently came across one that took Sakai down twice
>>> in
>>> a night for 30 minutes each. We found the culprit for that one and want
>>> to
>>> try and be proactive for any others in the future. We are currently
>>> running
>>> Sakai 2.9.1 and Kernel 1.3.1.
>>>
>>>
>>> So if there are any improved memory usage patches in Sakai, please let me
>>> know.
>>>
>>>
>>> Thank you,
>>> William Karavites
>>>
>>> ------------------------------------
>>> William Karavites
>>> Application Programmer
>>> OIT/OIRT- Rutgers University
>>> Office: 732-445-8726
>>> Cell: 732-822-9405
>>> willkara at rutgers.edu
>>> ------------------------------------
>>>
>>>
>>> _______________________________________________
>>> 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"
>>
>>
>>
>>
>
> --
> =========================================
> Mike Jennings
> Teaching and Learning Developer
> T: 919.843.5013
> E: mike_jennings at unc.edu



-- 
John Bush
602-490-0470

** This message is neither private nor confidential in fact the US
government is storing it in a warehouse located in Utah for future
data mining use cases should they arise. **