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

Upgrade Moodle 3.5: Error reseting user dashboard in PostgreSQL very large sites

    XMLWordPrintable

    Details

    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_35_STABLE

      Description

      We are testing the Moodle upgrade to 3.5 in large site (more than 170.000 user)  and instalation return the follow error:

      Debug info: number of parameters must be between 0 and 65535
      DELETE FROM mdl_user_preferences WHERE name IN

      Our environment are:

      • Linux RedHat 7
      • PHP 7.1
      • Apache 2.4
      • Postgres 9.6

      This issue likes related with MDL-53425: When reset all user dashboard in a large site.

       

      David

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              panidvd David Paniagua Ruano
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              3 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 minutes
                  5m