[Building Sakai] Production issue with Lesson Builder

[May, Megan Marie]

Thanks Bryan!     We started looking at that patch last night.

Does that help with the excessive number of items?  Even with 1 import we've seen a high number of duplicate entries (over 1000).
Megan

From: Bryan Holladay [mailto:holladay at longsight.com]
Sent: Monday, January 13, 2014 8:38 AM
To: May, Megan Marie
Cc: sakai-dev (sakai-dev at collab.sakaiproject.org)
Subject: Re: [Building Sakai] Production issue with Lesson Builder

My first assumption would be that it is from importing previous course LB's into the new courses.  We've seen a lot of issues with performance, excessive number of items and server stress with this process.  We created/provided this jira to help alleviate some of the issue:

SAK-23897 Site Info -> Import from site needs to run in a seperate thread and email user when finished

We were seeing instructors importing several times b/c it would either time out or they'd give up on the process and try again (or click several times).  If I wanted to bring down a Sakai server, that is how I would do it (site import with LB)

-Bryan

On Sun, Jan 12, 2014 at 1:22 PM, May, Megan Marie <mmmay at iu.edu<mailto:mmmay at iu.edu>> wrote:
On Friday the following SQL began running for excessive periods of time

update lesson_builder_items set pageId=:1 , sequence=:2 , type=:3 , sakaiId=:4 , name=:5 , html=:6 , description=:7 , height=:8 , width=:9 , alt=:10 , nextPage=:11 , format=:12 , required=:13 , alternate=:14 , prerequisite=:15 , subrequirement=:16 , requirementText=:17 , sameWindow=:18 , groups=:19 , anonymous=:20 , showComments=:21 , forcedCommentsAnonymous=:22 , gradebookId=:23 , gradebookPoints=:24 , gradebookTitle=:25 , altGradebook=:26 , altPoints=:27 , altGradebookTitle=:28 where id=:29

As a stop gap we've bounced the app servers these are occurring on.    We've noted HUGE increases in the number of rows in LESSON_BUILDER_ITEMS  & the increases pertain to  rows in lesson_builder_items show a SAKAIID of "/dummy"  (Import issues?)   The behavior seems like a loop - and we've looked at LSNBLDR-304 although the cause of it is ambiguous so we're hesitant to move forward with it.

Has anyone encountered this?

Megan

Megan May
Manager, Learning Management Systems / Kuali Student Development
UITS Enterprise Student Systems
Enterprise Software Division
Indiana University
Office:  317-274-4528<tel:317-274-4528>















_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140113/6a89af34/attachment.html