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

Having trouble performing certain actions with courses with more than 65,000 participants.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.8.8
    • Fix Version/s: None
    • Component/s: Assignment
    • Labels:
      None
    • Affected Branches:
      MOODLE_38_STABLE

      Description

      My installation has more than 310,000 registered users and I am having trouble performing certain actions with courses with more than 65,000 participants.

      Activity: Assignment
      Action: ".../mod/assign/view.php?id=13507&action=grading"

      Error message:

      "
      Informações de depuração: number of parameters must be between 0 and 65535
      SELECT COUNT(1) FROM mdl_user u
      LEFT JOIN mdl_assign_submission s
      ON u.id = s.userid
      AND s.assignment = $1
      AND s.latest = 1 LEFT JOIN mdl_assign_grades g
      ON g.assignment = $2
      AND u.id = g.userid
      AND (g.attemptnumber = s.attemptnumber OR s.attemptnumber IS NULL) LEFT JOIN mdl_assign_user_flags uf
      ON u.id = uf.userid
      AND uf.assignment = $3 WHERE u.id IN ($4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,...,$103155,$103156,$103157,$103158,$103159,$103160,$103161,$103162,$103163,$103164,$103165,$103166,$103167,$103168,$103169,$103170,$103171,$103172,$103173,$103174,$103175,$103176,$103177,$103178,$103179,$103180) AND (s.timemodified IS NOT NULL AND
      s.status = $103181 AND
      (s.timemodified >= g.timemodified OR g.timemodified IS NULL OR g.grade IS NULL))
      [array (
      0 => 1155,
      1 => 1155,
      2 => 1155,
      3 => 69825,
      4 => 156745,
      5 => 167532,
      6 => 107379,
      7 => 142310,
      8 => 121667,
      9 => 25670,
      10 => 140283,

      ...

      103171 => 242395,
      103172 => 236426,
      103173 => 242727,
      103174 => 285776,
      103175 => 242729,
      103176 => 242730,
      103177 => 215323,
      103178 => 56541,
      103179 => 65575,
      103180 => 'submitted',
      )]
      Error code: dmlreadexception
      Rastreamento de pilha:

      line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 259 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
      line 870 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
      line 1587 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1660 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1870 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
      line 1615 of /lib/tablelib.php: call to moodle_database->count_records_sql()
      line 1669 of /lib/tablelib.php: call to table_sql->query_db()
      line 1469 of /mod/assign/renderer.php: call to table_sql->out()
      line 1250 of /mod/assign/renderer.php: call to mod_assign_renderer->flexible_table()
      line 462 of /lib/outputrenderers.php: call to mod_assign_renderer->render_assign_grading_table()
      line 4555 of /mod/assign/locallib.php: call to plugin_renderer_base->render()
      line 4640 of /mod/assign/locallib.php: call to assign->view_grading_table()
      line 649 of /mod/assign/locallib.php: call to assign->view_grading_page()
      line 55 of /mod/assign/view.php: call to assign->view()
      "

      Moodle 3.8
      Ubuntu 20.04
      PHP 7.4
      PostgreSQL 12
      +310k users

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            caiado Ricardo Caiado
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: