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

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • 3.5
    • None
    • Installation
    • PostgreSQL
    • 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

              Unassigned Unassigned
              panidvd David Paniagua Ruano
              Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              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