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

ORACLE - DB blocked by a lot of Update lesson_builder_items calls

    XMLWordPrintable

    Details

    • 20 status:
      Please Merge
    • Test Plan:
      Hide

      Activate DEBUG.org.hibernate

      1. Enter as a student or instructor on a Lessons builder page.

      You shouldn't see any update lesson_builder_items call on tomcat log.

      Show
      Activate DEBUG.org.hibernate 1. Enter as a student or instructor on a Lessons builder page. You shouldn't see any  update lesson_builder_items  call on tomcat log.

      Description

      On Oracle server we have noticed that
      everytime an user enters on a Lesson Builder tool it produces a lot of calls

       update lesson_builder_items set html=?, description=?, alt=? where id=?

      If we add more items, more update calls are generated.

      Ex: We add 6 more subpages. On log appeas

      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set html=?, description=?, alt=? where id=? 

      Ex: We add 5 more text items.  On log appears (the 6 of above and the new ones)

      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set sakaiId=?, name=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set sakaiId=?, name=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set sakaiId=?, name=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set sakaiId=?, name=?, description=?, alt=? where id=?
      DEBUG http-nio-8080-exec-2 org.hibernate.SQL - update lesson_builder_items set sakaiId=?, name=?, description=?, alt=? where id=?

       Please see related jira.

       

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  jesusmmp Jesus Maria Mendez
                  Reporter:
                  jesusmmp Jesus Maria Mendez
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration