Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-31870

Time out error when creating a course category on a site with lots of courses

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.2.1
    • Fix Version/s: None
    • Component/s: Course
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      I got a time out error when creating a new category. My development has just over 10k courses.

      The URL was http://localhost/moodle/dev/master/course/editcategory.php?parent=0

      The category was actually created. Problem may have been in fixing the sort order but thats a guess.

      Timed out while waiting for session lock.
      Wait for your current requests to finish and try again later.
      Stack trace:

      line 1237 of /lib/dml/mysqli_native_moodle_database.php: dml_sessionwait_exception thrown
      line 593 of /lib/sessionlib.php: call to mysqli_native_moodle_database->get_session_lock()
      line ? of unknownfile: call to database_session->handler_read()
      line 184 of /lib/sessionlib.php: call to session_start()
      line 473 of /lib/sessionlib.php: call to session_stub->__construct()
      line 60 of /lib/sessionlib.php: call to database_session->__construct()
      line 692 of /lib/setup.php: call to session_get_instance()
      line 29 of /config.php: call to require_once()
      line 9 of /course/editcategory.php: call to require_once()

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: