-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
3.1.6, 3.1.7, 3.1.8, 3.2.3, 3.2.4
-
MOODLE_31_STABLE, MOODLE_32_STABLE
-
wip-
MDL-60481-master -
Submitting an Excel file into an assignment that contains data beyond row 65,536 will cause a unoconv document conversion to hang up until it is killed manually when viewed within Moodle's grading interface, with the nasty side effect of locking the teacher's moodle session until that manual kill occurs.
We suspect that the same issue exists when the Excel file is converted by the cron as well. We routinely find and fix these hung cron issues by clearing the submission out of mdl_assignfeedback_editpdf_queue, killing the cron, and killing all soffice.bin processes.
This could potentially be resolved if Moodle were to somehow check the row count on the excel file and if it exceeds the row limit of 65,536, not pass the file along to unoconv, while providing a relevant error message to the instructor instead explaining why it can't be converted.
To replicate this issue:
- Create an Excel file with data beyond row 65,536. Row 1,048,576 to be more specific, as this is the row we've seen this occur with so far, but theoretically it should be any row beyond 65,536.
- Submit the Excel file to an assignment.
- Attempt to grade the assignment within the grader interface.
- Wait awhile.
- Search for and kill the hung unoconv process.
- duplicates
-
MDL-57202 Large docs/PDFs cripple grading interface
- Open