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

question_stats_cleanup_task fails with "number of parameters must be between 0 and 65535"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Minor
    • None
    • 4.1.2
    • Questions
    • None
    • MOODLE_401_STABLE

    Description

      The scheduled task \core\task\question_stats_cleanup_task fails with:
      Debug info:
      number of parameters must be between 0 and 65535
      DELETE FROM mdl2_question_response_analysis WHERE id IN ($1,$2,
      [...]

      The task is trying to delete 1.4 million entries in mdl2_question_response_analysis on our system (PHP 8.0, Postgres).

      Attachments

        Issue Links

          Activity

            People

              mgauk Martin Gauk
              mgauk Martin Gauk
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.