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

error reading from database (vers 2.3)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Deferred
    • Affects Version/s: 2.3.1
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Affected Branches:
      MOODLE_23_STABLE

      Description

      We have just upgraded from 1.9 thru 2.2 to 2.3.1 and after that cron was hanging like described http://moodle.org/mod/forum/discuss.php?d=207273. Our Moodle version was 2.3.1 build 2012-07-06.

      We upgraded to the latest 2.3.1+ weekly build (2012-07-26). Site administration/Registration and Cron command /usr/bin/php /usr/moodle2back/admin/cli/cron.php end now with error (Error reading from database).
      ===
      Software versions:
      mysql Ver 14.14 Distrib 5.5.25a, for Linux (x86_64) using readline 5.1

      PHP 5.3.15 (cli) (built: Jul 20 2012 13:23:50)
      Copyright (c) 1997-2012 The PHP Group
      Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies

      Red Hat Enterprise Linux Server release 6.3 (Santiago)
      ===

      In Debugging mode:

      [root@ceres moodle23latest]# /usr/bin/php /usr/moodle2back/admin/cli/cron.php
      Server Time: Tue, 31 Jul 2012 16:04:09 +0300

      Created missing context instances
      Cleaned up stale user sessions
      Running auth crons if required...
      Running enrol crons if required...
      Running cron for enrol_self...
      Starting activity modules
      Processing module function assignment_cron ...... used 2 dbqueries
      ... used 0.009260892868042 seconds
      done.
      Processing module function chat_cron ...... used 5 dbqueries
      ... used 0.0016460418701172 seconds
      done.
      Processing module function forum_cron ...Starting digest processing...
      Cleaned old digest records
      ... used 3 dbqueries
      ... used 0.0019478797912598 seconds
      done.
      Processing module function quiz_cron ...
      Starting quiz reports
      Finished quiz reports
      ... used 3 dbqueries
      ... used 0.0024828910827637 seconds
      done.
      Processing module function scorm_cron ...... used 1 dbqueries
      ... used 0.0036370754241943 seconds
      done.
      Processing module function workshop_cron ... processing workshop subplugins ...
      Starting workshop allocation methods
      Processing cron function for workshopallocation_scheduled...
      ... no workshops awaiting scheduled allocation. done. (1 dbqueries, 0 seconds)
      Finished workshop allocation methods
      ... used 6 dbqueries
      ... used 0.010161876678467 seconds
      done.
      Processing module function assign_cron ...done.
      ... used 6 dbqueries
      ... used 0.021576166152954 seconds
      done.
      <pre>
      </pre>Finished activity modules
      Starting blocks
      Processing cron function for rss_client....
      0 feeds refreshed (took 0.0010330000000001 seconds)
      done.
      Finished blocks
      Starting admin reports
      Finished admin reports
      Starting main gradebook job...
      done.
      Starting processing the event queue...
      done.
      Starting course reports
      Finished course reports
      Starting gradebook plugins
      Finished gradebook plugins
      Fetching external blog entries...done.
      Deleting blog associations linked to non-existent contexts...done.
      Registreerimis uuenduse algamine jaoturis...
      Default exception handler: Viga andmebaasist lugemisel Debug: Every derived table must have its own alias
      SELECT COUNT FROM (
      SELECT DISTINCT ue.userid, e.courseid
      FROM mdl_user_enrolments ue, mdl_enrol e, mdl_course c
      WHERE ue.enrolid = e.id
      AND e.courseid <> ?
      AND c.id = e.courseid
      AND c.visible = 1)
      [array (
      0 => '1',
      )]
      Error code: dmlreadexception

      • line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 945 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1346 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      • line 1419 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      • line 1590 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      • line 4044 of /course/lib.php: call to moodle_database->count_records_sql()
      • line 255 of /admin/registration/lib.php: call to average_number_of_participants()
      • line 66 of /admin/registration/lib.php: call to registration_manager->get_site_info()
      • line 380 of /lib/cronlib.php: call to registration_manager->cron()
      • line 61 of /admin/cli/cron.php: call to cron_run()

      !!! Viga andmebaasist lugemisel !!!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              tonut Tõnu Toomeoja
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: