Loading...

XML

Word

Printable

Type: Improvement
Resolution: Won't Do
Priority: Minor
Fix Version/s: None
Affects Version/s: 2.9.5, 3.0.3, 3.1
Component/s: Database SQL/XMLDB
Labels:
- patch
- triaged

Affected Branches:
MOODLE_29_STABLE, MOODLE_30_STABLE, MOODLE_31_STABLE
Pull from Repository:
git://github.com/junpataleta/moodle.git
Pull Main Branch:
~~MDL-53735~~-master
Pull Main Diff URL:
https://github.com/junpataleta/moodle/compare/f4a2d69631...MDL-53735-master
Testing Instructions:
1. Run PHPUnit tests for lib/dml/test/dml_test.php.
  - Confirm that it passes.

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.

has a non-specific relationship to

MDL-66864 Upgrade fails with error 'number of parameters must be between 0 and 65535' on large sites

Closed

has been marked as being related by

MDL-53425 Unable to reset Dashboard for all users - postgres fails if number of parameters over 65535

Closed

MDL-66498 Analytics cleanup() causes error for large moodle installations under postgres

Closed

will be (partly) resolved by

MDL-70055 Support large number of SQL-IN parameters in Postgres

Closed

will help resolve

MDL-60208 Background processing for question engine (core\task\question_cron_task) failed with error ORA-01795

Closed

MDL-67746 Cleanup of task logs fails with big number of records to be deleted

Closed

(1 will help resolve)

Assignee:: Unassigned

Reporter:: Jun Pataleta

Participants:: CiBoT, Damyon Wiese, David Monllaó, Eloy Lafuente (stronk7), Jun Pataleta, Matt Porritt, Russell Smith, Yolanda Ordoñez Rufat

Votes:: 4 Vote for this issue

Watchers:: 14 Start watching this issue

Created:: 07/Apr/16 8:08 PM

Updated:: 02/Dec/22 7:40 AM

Resolved:: 02/Dec/22 7:40 AM

Details

Description

Attachments

Issue Links

Activity

People

Dates

Clockify