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, Michael Hawkins, 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