[Building Sakai] Production issue with Lesson Builder

[Bryan Holladay]

>Does that help with the excessive number of items?

Yes and no.  It prevents the excessive number of orphaned pages by the
instructor re-importing and deleting the half imported material.  I've seen
cases where it takes 10+ minutes for the import to complete, which is why
instructor's keep trying the import and causing millions of pages to be
created.  We actually had to track the instructor down and tell them to
stop importing until we get the fix in since every time we restarted the
instructor went back in to re-import.  However, this patch doesn't address
the issue inside of LB's import code.  So I'm sure there is room for more
improvement, but it seemed like it was the combination of multiple imports
+ non-performant import code.  The good/bad thing about this issue is that
it only comes up in the first week or so of the semester.  So it won't be
an issue again until next semester and any fix you add you won't really be
certain until then as well.  I'm not going to jinx us by saying everything
is going fine so far with that patch with this start of this semester but
you can infer that if you wish ;)

Thanks,
Bryan

On Mon, Jan 13, 2014 at 9:16 AM, May, Megan Marie <mmmay at iu.edu> wrote:

>  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> 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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> 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"
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140113/e2215b06/attachment.html