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

Split very large SQL-IN parameters to chunks

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Won't Do
    • 2.9.5, 3.0.3, 3.1
    • None
    • Database SQL/XMLDB

    Description

      When querying/deleting records by bulk, we can get errors when the values array becomes too large (i.e. > 65535 parameters for PostgreSQL, >1000 for Oracle). Basically, this involves the \moodle_database methods that use where_clause_list(), such as \moodle_database::get_recordset_list(), \moodle_database::get_records_list(), and \moodle_database::delete_records_list().

      We need to split the values array into chunks in order to avoid these errors.

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-66864 Upgrade fails with error 'number of parameters must be between 0 and 65535' on large sites

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-53425 Unable to reset Dashboard for all users - postgres fails if number of parameters over 65535

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-66498 Analytics cleanup() causes error for large moodle installations under postgres

          • Major - Major loss of function, incorrect output
          • Closed
          will be (partly) resolved by

          Improvement - An enhancement to an existing Moodle feature. MDL-70055 Support large number of SQL-IN parameters in Postgres

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will help resolve

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-60208 Background processing for question engine (core\task\question_cron_task) failed with error ORA-01795

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-67746 Cleanup of task logs fails with big number of records to be deleted

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              Votes:
              4 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: